143: l_next_process VARCHAR2(30);
144: l_dummy VARCHAR2(500);
145: unfinished BOOLEAN := TRUE;
146:
147: l_user_id NUMBER(15) := fnd_global.user_id;
148: l_resp_id NUMBER(15) := fnd_global.resp_id;
149: l_login_id NUMBER(15) := fnd_global.login_id;
150: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
151: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
144: l_dummy VARCHAR2(500);
145: unfinished BOOLEAN := TRUE;
146:
147: l_user_id NUMBER(15) := fnd_global.user_id;
148: l_resp_id NUMBER(15) := fnd_global.resp_id;
149: l_login_id NUMBER(15) := fnd_global.login_id;
150: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
151: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
152: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
145: unfinished BOOLEAN := TRUE;
146:
147: l_user_id NUMBER(15) := fnd_global.user_id;
148: l_resp_id NUMBER(15) := fnd_global.resp_id;
149: l_login_id NUMBER(15) := fnd_global.login_id;
150: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
151: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
152: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
153:
146:
147: l_user_id NUMBER(15) := fnd_global.user_id;
148: l_resp_id NUMBER(15) := fnd_global.resp_id;
149: l_login_id NUMBER(15) := fnd_global.login_id;
150: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
151: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
152: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
153:
154: x_debug number;
147: l_user_id NUMBER(15) := fnd_global.user_id;
148: l_resp_id NUMBER(15) := fnd_global.resp_id;
149: l_login_id NUMBER(15) := fnd_global.login_id;
150: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
151: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
152: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
153:
154: x_debug number;
155: debug_v number;
148: l_resp_id NUMBER(15) := fnd_global.resp_id;
149: l_login_id NUMBER(15) := fnd_global.login_id;
150: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
151: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
152: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
153:
154: x_debug number;
155: debug_v number;
156:
348: loop_count NUMBER;
349: l_start_id cn_sca_process_batches.start_id%TYPE;
350: l_end_id cn_sca_process_batches.end_id%TYPE;
351:
352: l_user_id NUMBER(15) := fnd_global.user_id;
353: l_login_id NUMBER(15) := fnd_global.login_id;
354:
355: BEGIN
356:
349: l_start_id cn_sca_process_batches.start_id%TYPE;
350: l_end_id cn_sca_process_batches.end_id%TYPE;
351:
352: l_user_id NUMBER(15) := fnd_global.user_id;
353: l_login_id NUMBER(15) := fnd_global.login_id;
354:
355: BEGIN
356:
357: debugmsg(batch_type || ': Assign : Start ');
1195: NULL,
1196: CCLA.ROLLUP_DATE,
1197: CCLA.SOURCE_DOC_ID,
1198: CCLA.SOURCE_DOC_TYPE,
1199: fnd_global.user_id,
1200: Sysdate,
1201: fnd_global.user_id,
1202: Sysdate,
1203: fnd_global.login_id,
1197: CCLA.SOURCE_DOC_ID,
1198: CCLA.SOURCE_DOC_TYPE,
1199: fnd_global.user_id,
1200: Sysdate,
1201: fnd_global.user_id,
1202: Sysdate,
1203: fnd_global.login_id,
1204: CCLA.TRANSACTION_CURRENCY_CODE,
1205: CCLA.EXCHANGE_RATE,
1199: fnd_global.user_id,
1200: Sysdate,
1201: fnd_global.user_id,
1202: Sysdate,
1203: fnd_global.login_id,
1204: CCLA.TRANSACTION_CURRENCY_CODE,
1205: CCLA.EXCHANGE_RATE,
1206: NULL,
1207: CCLA.TRX_ID,
1655: NULL,
1656: CCLA.ROLLUP_DATE,
1657: CCLA.SOURCE_DOC_ID,
1658: CCLA.SOURCE_DOC_TYPE,
1659: fnd_global.user_id,
1660: Sysdate,
1661: fnd_global.user_id,
1662: Sysdate,
1663: fnd_global.login_id,
1657: CCLA.SOURCE_DOC_ID,
1658: CCLA.SOURCE_DOC_TYPE,
1659: fnd_global.user_id,
1660: Sysdate,
1661: fnd_global.user_id,
1662: Sysdate,
1663: fnd_global.login_id,
1664: CCLA.TRANSACTION_CURRENCY_CODE,
1665: CCLA.EXCHANGE_RATE,
1659: fnd_global.user_id,
1660: Sysdate,
1661: fnd_global.user_id,
1662: Sysdate,
1663: fnd_global.login_id,
1664: CCLA.TRANSACTION_CURRENCY_CODE,
1665: CCLA.EXCHANGE_RATE,
1666: CCLA.ACCTD_TRANSACTION_AMOUNT,
1667: CCLA.TRX_ID,
2012: NULL,
2013: CCLA.ROLLUP_DATE,
2014: CCLA.SOURCE_DOC_ID,
2015: CCLA.SOURCE_DOC_TYPE,
2016: fnd_global.user_id,
2017: Sysdate,
2018: fnd_global.user_id,
2019: Sysdate,
2020: fnd_global.login_id,
2014: CCLA.SOURCE_DOC_ID,
2015: CCLA.SOURCE_DOC_TYPE,
2016: fnd_global.user_id,
2017: Sysdate,
2018: fnd_global.user_id,
2019: Sysdate,
2020: fnd_global.login_id,
2021: CCLA.TRANSACTION_CURRENCY_CODE,
2022: CCLA.EXCHANGE_RATE,
2016: fnd_global.user_id,
2017: Sysdate,
2018: fnd_global.user_id,
2019: Sysdate,
2020: fnd_global.login_id,
2021: CCLA.TRANSACTION_CURRENCY_CODE,
2022: CCLA.EXCHANGE_RATE,
2023: CCLA.ACCTD_TRANSACTION_AMOUNT,
2024: CCLA.TRX_ID,
2161: cn_message_pkg.begin_batch
2162: (x_process_type => 'RESULTS_TRANSFER',
2163: x_parent_proc_audit_id => null,
2164: x_process_audit_id => l_process_audit_id,
2165: x_request_id => fnd_global.conc_request_id,
2166: p_org_id => p_org_id);
2167:
2168: debugmsg('Results Transfer : Start of Transfer');
2169: debugmsg('Results Transfer : process_audit_id is ' || l_process_audit_id );
2377: cn_message_pkg.begin_batch
2378: (x_process_type => 'ALLOCATION_TRANSFER',
2379: x_parent_proc_audit_id => null,
2380: x_process_audit_id => l_process_audit_id,
2381: x_request_id => fnd_global.conc_request_id,
2382: p_org_id => p_org_id);
2383:
2384: SELECT cn_sca_logical_batches_s.NEXTVAL
2385: INTO l_logical_batch_id
3212: NULL,
3213: CCH.ROLLUP_DATE,
3214: NULL,
3215: CCH.SOURCE_DOC_TYPE,
3216: fnd_global.user_id,
3217: Sysdate,
3218: fnd_global.user_id,
3219: Sysdate,
3220: fnd_global.login_id,
3214: NULL,
3215: CCH.SOURCE_DOC_TYPE,
3216: fnd_global.user_id,
3217: Sysdate,
3218: fnd_global.user_id,
3219: Sysdate,
3220: fnd_global.login_id,
3221: CCH.ORIG_CURRENCY_CODE,
3222: CCH.EXCHANGE_RATE,
3216: fnd_global.user_id,
3217: Sysdate,
3218: fnd_global.user_id,
3219: Sysdate,
3220: fnd_global.login_id,
3221: CCH.ORIG_CURRENCY_CODE,
3222: CCH.EXCHANGE_RATE,
3223: -1 * NVL(CCH.TRANSACTION_AMOUNT, 0),
3224: NULL, -- CCH.TRX_ID,
3768: NULL,
3769: CCH.ROLLUP_DATE,
3770: NULL,
3771: CCH.SOURCE_DOC_TYPE,
3772: fnd_global.user_id,
3773: Sysdate,
3774: fnd_global.user_id,
3775: Sysdate,
3776: fnd_global.login_id,
3770: NULL,
3771: CCH.SOURCE_DOC_TYPE,
3772: fnd_global.user_id,
3773: Sysdate,
3774: fnd_global.user_id,
3775: Sysdate,
3776: fnd_global.login_id,
3777: CCH.ORIG_CURRENCY_CODE,
3778: CCH.EXCHANGE_RATE,
3772: fnd_global.user_id,
3773: Sysdate,
3774: fnd_global.user_id,
3775: Sysdate,
3776: fnd_global.login_id,
3777: CCH.ORIG_CURRENCY_CODE,
3778: CCH.EXCHANGE_RATE,
3779: -1 * NVL(CCH.TRANSACTION_AMOUNT, 0),
3780: NULL, -- CCH.TRX_ID,
3925:
3926:
3927: BEGIN
3928:
3929: l_request_id := fnd_global.conc_request_id;
3930:
3931: cn_message_pkg.begin_batch(
3932: x_process_type => 'SCA Batch Runner'
3933: ,x_parent_proc_audit_id => p_parent_proc_audit_id