753: l_msg_count NUMBER(2);
754:
755: l_wbsc_id IEB_WB_SVC_CATS.WBSC_ID%type;
756:
757: l_media_type IEB_SVC_CAT_TEMPS_B.media_type%type;
758:
759: l_parent_id IEB_WB_SVC_CATS.parent_id%type;
760:
761: l_cpn_svr_name IEB_WB_SVC_CATS.campaign_server_name%type;
779: x_msg_data := '';
780: x_msg_count := 0;
781:
782: select media_type into l_media_type
783: from IEB_SVC_CAT_TEMPS_B where media_type_id = p_media_type_id;
784:
785: for c_rec in c_cur LOOP
786:
787: select parent_id into l_parent_id
915: l_msg_count NUMBER(2);
916:
917: l_wbsc_id IEB_WB_SVC_CATS.WBSC_ID%type;
918:
919: l_media_type IEB_SVC_CAT_TEMPS_B.media_type%type;
920:
921: l_parent_id IEB_WB_SVC_CATS.parent_id%type;
922:
923: l_cpn_svr_name IEB_WB_SVC_CATS.campaign_server_name%type;
943: and wbsvr_wbsvr_id= p_server_id
944: and default_flag= 'Y';
945:
946: select media_type into l_media_type
947: from IEB_SVC_CAT_TEMPS_B where media_type_id = p_media_type_id;
948:
949:
950: SELECT DBMS_UTILITY.GET_TIME INTO l_time_stamp FROM dual;
951: