Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips
Arguments Source

RHN_INSTALL_ORG_SATELLITES

Arguments:

NameData TypeDefault ValueIn/Out
FOR_CUSTOMER_IDNUMBER(38) IN
SAT_CLUSTER_IDNUMBER(12) IN
USERNAMEVARCHAR2(40) IN
DDL script

Source

Legend: comment string keyword reserved word operator
     1: procedure
     2: rhn_install_org_satellites
     3: (
     4:     for_customer_id in web_customer.id%type,
     5:     sat_cluster_id in rhn_sat_cluster.recid%type,
     6:     username in rhn_command_queue_instances.last_update_user%type
     7: )
     8: is
     9:     cursor satellite_cursor is
    10:         select recid from rhn_sat_cluster
    11:         where customer_id = for_customer_id
    12:         and recid not in (
    13:             select netsaint_id from rhn_ll_netsaint
    14:         )
    15:         minus
    16:         select recid from rhn_sat_cluster
    17:         where customer_id = for_customer_id
    18:         and recid not in (sat_cluster_id);
    19:     command_instance_id rhn_command_queue_instances.recid%type;
    20: begin
    21:     rhn_prepare_install(username, command_instance_id, 1);
    22:     for satellite in satellite_cursor loop
    23:         rhn_install_satellite(command_instance_id, satellite.recid);
    24:     end loop;
    25: end rhn_install_org_satellites;