SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't get a script to run

545948Feb 8 2007 — edited Feb 8 2007

Hi everyone.

I am trying to run a rather large script to configure a database for testing. I cannot get this script to run in SQLDeveloper though. When I attempt to run the script I get the following errors:

line 1: SQLPLUS Command Skipped: set serveroutput on;

line 4: SQLPLUS Command Skipped: var OUT_RUN_ID NUMBER;

line 5: SQLPLUS Command Skipped: var OUT_ORD_ID NUMBER;

Error starting at line 7 in command:

I also get this error everytime:
Error report:
Missing IN or OUT parameter at index:: 1

Lastly, those errors above occur when I hit "Run Script". If I just hit the "Run" command a popup warning appears with the following error (which didn't help much):
"ORA-01008 - Not all variables bound"

The code is pasted below in bold letters.
Any help is really appreciated.

Thanks!

set serveroutput on;

var OUT_RUN_ID NUMBER;
var OUT_ORD_ID NUMBER;

DECLARE
V_CPGN_C T_FBSOS_OFFR_STG.CPGN_C%TYPE := 'FSIA';
V_CPGN_ST_C T_FBSOS_OFFR_STG.CPGN_ST_C%TYPE := 'INIT';
V_DLVR_MODE_C T_FBSOS_OFFR_STG.DLVR_MODE_C%TYPE := 'A';
V_EXEC_MODE_C T_FBSOS_OFFR_STG.EXEC_MODE_C%TYPE := 'P';
V_INSRT_BCK_SLP_I T_FBSOS_OFFR_STG.INSRT_BCK_SLP_I%TYPE := 'N';
V_NIGO_I T_FBSOS_OFFR_STG.NIGO_I%TYPE := 'N';
V_ORIG_C T_FBSOS_OFFR_STG.ORIG_C%TYPE := 'PSW';
V_CREA_CORP_ID T_FBSOS_OFFR_STG.CREA_CORP_ID%TYPE := 'A414545';
V_CREA_SRC_C T_FBSOS_OFFR_STG.CREA_SRC_C%TYPE := 'FESCOXLIST';
V_FPRS_RULES_C T_FBSOS_OFFR_STG.FPRS_RULES_C%TYPE := 'R';
V_FPRS_LGC_FLG_C T_FBSOS_OFFR_STG.FPRS_LGC_FLG_C%TYPE := 'D';
V_PRTY_N T_FBSOS_OFFR_STG.PRTY_N%TYPE := 3;
V_CPGN_TTL_NM T_FBSRC_RUN_CTRL.CPGN_TTL_NM%TYPE := 'ChARM TEST Run';
V_OFFR_NM T_FBCFO_OFFR.OFFR_NM%TYPE := 'FSIA Regression Test Case';
V_FO_CREA_SRC_C T_FBCFO_OFFR.CREA_SRC_C%TYPE := 'UNICA';
V_KIT_C T_FBCFO_OFFR.KIT_C%TYPE := 'CERTFORS';
V_CHAN_TYPE_C_PART T_FBCCC_OFFR_CHAN_CNTNT.CHAN_TYPE_C%TYPE := 'PART';
V_CHAN_TYPE_C_ER T_FBCCC_OFFR_CHAN_CNTNT.CHAN_TYPE_C%TYPE := 'ER';
V_CHAN_TYPE_C_PR T_FBCCC_OFFR_CHAN_CNTNT.CHAN_TYPE_C%TYPE := 'PR';
V_CHAN_CNTNT_KEY_TYPE_C_TMPLT T_FBCCC_OFFR_CHAN_CNTNT.CHAN_CNTNT_KEY_TYPE_C%TYPE := 'TMPLT';
V_CHAN_CNTNT_KEY_TYPE_C_KITCD T_FBCCC_OFFR_CHAN_CNTNT.CHAN_CNTNT_KEY_TYPE_C%TYPE := 'KITCD';
V_CNTNT_KEY_VAL1_C_TMPLT T_FBCCC_OFFR_CHAN_CNTNT.CNTNT_KEY_VAL1_C%TYPE := 'EDE2B100903';
V_CNTNT_KEY_VAL1_C_KITCD T_FBCCC_OFFR_CHAN_CNTNT.CNTNT_KEY_VAL1_C%TYPE := 'CERTFORS';

BEGIN
/* GET RUN ID */
PKG_COMM_DELIVERY.PRC_GET_CAMPAIGNRUN_PK(:OUT_RUN_ID);
DBMS_OUTPUT.PUT_LINE(':OUT_RUN_ID IS:' || :OUT_RUN_ID);

/************** INSERT ORDERS FOR OFFER ID 14502 **************/

PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'529-04-4415',714798,'59892','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'012-54-1071',718029,'90480','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'524-92-5393',714798,'59892','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'426-65-8632',718029,'90480','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'521-27-1069',961,'26001','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-01-8910',961,NULL,'DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'043-84-3431',3340,'78172','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'050-44-7341',3340,'78172','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'527-80-6835',714798,'59892','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'445-40-1109',718029,'90480','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-38-8295',400934,'89766','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'001-94-3208',964,'41558','DC',V_CPGN_ST_C,'14502',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);

/************** INSERT ORDERS FOR OFFER ID 14503 **************/

PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'529-04-4415',714798,'59892','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'012-54-1071',718029,'90480','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'524-92-5393',714798,'59892','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'457-27-2540',400934,'89766','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'426-65-8632',718029,'90480','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'521-27-1069',961,'26001','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-01-0256',961,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'022-50-6395',3340,'78172','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'049-70-5638',3340,'78172','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'527-80-6835',714798,'59892','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'456-21-1304',961,'26001','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'445-40-1109',718029,'90480','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'501-94-5409',400934,'89766','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'001-50-2632',964,'41558','DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-82-9441',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-82-9441',725680,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-0459',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-1054',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-1462',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-1873',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-3673',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-4862',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-8836',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-82-0883',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-0777',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-1941',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-4121',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-84-7219',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-9468',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-4814',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-70-1031',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'003-76-4439',0,NULL,'DC',V_CPGN_ST_C,'14503',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);

/************** INSERT ORDERS FOR OFFER ID 14504 **************/

PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'534-66-4079',400934,'89766','DC',V_CPGN_ST_C,'14504',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14504',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-50-6543',718029,'90480','DC',V_CPGN_ST_C,'14504',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'539-62-2538',714798,'38300','DC',V_CPGN_ST_C,'14504',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'550-08-7040',400934,'89766','DC',V_CPGN_ST_C,'14504',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'456-51-3967',718029,NULL,'DC',V_CPGN_ST_C,'14504',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'501-94-5409',400934,'89766','DC',V_CPGN_ST_C,'14504',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14504',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-12-6830',718029,NULL,'DC',V_CPGN_ST_C,'14504',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);

/************** INSERT ORDERS FOR OFFER ID 14505 **************/

PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'101-42-9213',718029,'34024','DC',V_CPGN_ST_C,'14505',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14505',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-50-6543',718029,'90480','DC',V_CPGN_ST_C,'14505',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'539-62-2538',714798,'38300','DC',V_CPGN_ST_C,'14505',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'461-15-7347',961,'26001','DC',V_CPGN_ST_C,'14505',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'455-73-1286',718029,NULL,'DC',V_CPGN_ST_C,'14505',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'501-94-5409',400934,'89766','DC',V_CPGN_ST_C,'14505',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14505',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-28-7208',718029,NULL,'DC',V_CPGN_ST_C,'14505',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);

/************** INSERT ORDERS FOR OFFER ID 14506 **************/

PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'523-02-2886',714798,'38300','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'014-40-4319',718029,'90480','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'524-92-5393',714798,'59892','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'556-06-8886',400934,'89766','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'426-65-8632',718029,'90480','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'521-27-1069',961,'26001','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-07-4825',961,NULL,'DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'199-52-0488',961,'26001','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'079-62-4102',3340,'78172','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'527-80-6835',714798,'59892','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'483-74-8777',961,'26001','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'455-29-2919',718029,NULL,'DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-52-1974',400934,'89766','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'002-36-5606',964,'41558','DC',V_CPGN_ST_C,'14506',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);

/************** INSERT ORDERS FOR OFFER ID 14507 **************/

PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'199-52-0488',961,'26001','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'013-64-8385',718029,NULL,'DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'524-92-5393',714798,'59892','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'426-65-8632',718029,'90480','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'521-27-1069',961,'26001','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-03-2573',961,NULL,'DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'177-48-5768',3340,'78172','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'060-76-1120',3340,'78172','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'527-80-6835',714798,'59892','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'476-08-1565',961,'26001','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'455-29-2919',718029,NULL,'DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-46-4950',400934,'89766','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'002-30-8503',964,'41558','DC',V_CPGN_ST_C,'14507',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);

/************** INSERT ORDERS FOR OFFER ID 14508 **************/

PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'109-86-0765',718029,'90480','DC',V_CPGN_ST_C,'14508',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14508',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'101-38-5152',718029,NULL,'DC',V_CPGN_ST_C,'14508',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'539-62-2538',714798,'38300','DC',V_CPGN_ST_C,'14508',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'331-76-4233',961,'26001','DC',V_CPGN_ST_C,'14508',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'461-43-2183',718029,NULL,'DC',V_CPGN_ST_C,'14508',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-54-5520',718029,'90480','DC',V_CPGN_ST_C,'14508',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14508',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-22-8319',718029,NULL,'DC',V_CPGN_ST_C,'14508',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);

/************** INSERT ORDERS FOR OFFER ID 14509 **************/

PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'109-52-6399',718029,'90480','DC',V_CPGN_ST_C,'14509',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'330-56-4929',961,'37726','DC',V_CPGN_ST_C,'14509',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'101-34-2789',718029,'90480','DC',V_CPGN_ST_C,'14509',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'539-62-2538',714798,'38300','DC',V_CPGN_ST_C,'14509',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'492-88-8712',961,'26001','DC',V_CPGN_ST_C,'14509',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'457-90-5647',718029,NULL,'DC',V_CPGN_ST_C,'14509',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'501-94-5409',400934,'89766','DC',V_CPGN_ST_C,'14509',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'508-80-8212',714798,'59892','DC',V_CPGN_ST_C,'14509',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,:OUT_ORD_ID);
PKG_COMM_DELIVERY.PRC_ORDER_UI(NULL,V_CPGN_C,:OUT_RUN_ID,'100-22-5620',718029,NULL,'DC',V_CPGN_ST_C,'14509',V_EXEC_MODE_C,sysdate,V_DLVR_MODE_C,NULL,V_INSRT_BCK_SLP_I,V_NIGO_I,V_ORIG_C,V_CREA_CORP_ID,sysdate,V_CREA_SRC_C,NULL,NULL,V_PRTY_N,NULL,NULL,V_FPRS_RULES_C,V_FPRS_LGC_FLG_C,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU

Comments

Locked Post

New comments cannot be posted to this locked post.

Post Details

Locked on Mar 8 2007

Added on Feb 8 2007

3 comments

1,282 views