DELETE_CHANNEL

Arguments:

Source

Legend: comment string keyword reserved word operator

     1: procedure delete_channel (
     2: 	channel_id_in in number
     3: ) is
     4: begin
     5:         delete from rhnChannelPackage where channel_id = channel_id_in;
     6:         delete from rhnChannelErrata where channel_id = channel_id_in;
     7:         delete from rhnServerChannel where channel_id = channel_id_in;
     8:         delete from rhnRegTokenChannels where channel_id = channel_id_in;
     9:         delete from rhnDistChannelMap where channel_id = channel_id_in;
    10:         delete from rhnChannelFamilyMembers where channel_id = channel_id_in;
    11:         delete from rhnServerProfilePackage where server_profile_id in (
    12:             select id from rhnServerProfile where base_channel = channel_id_in
    13:         );
    14:         delete from rhnServerProfile where base_channel = channel_id_in;
    15:         delete from rhnChannel where id = channel_id_in;
    16: end;