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 ');
1197: NULL,
1198: CCLA.ROLLUP_DATE,
1199: CCLA.SOURCE_DOC_ID,
1200: CCLA.SOURCE_DOC_TYPE,
1201: fnd_global.user_id,
1202: Sysdate,
1203: fnd_global.user_id,
1204: Sysdate,
1205: fnd_global.login_id,
1199: CCLA.SOURCE_DOC_ID,
1200: CCLA.SOURCE_DOC_TYPE,
1201: fnd_global.user_id,
1202: Sysdate,
1203: fnd_global.user_id,
1204: Sysdate,
1205: fnd_global.login_id,
1206: CCLA.TRANSACTION_CURRENCY_CODE,
1207: CCLA.EXCHANGE_RATE,
1201: fnd_global.user_id,
1202: Sysdate,
1203: fnd_global.user_id,
1204: Sysdate,
1205: fnd_global.login_id,
1206: CCLA.TRANSACTION_CURRENCY_CODE,
1207: CCLA.EXCHANGE_RATE,
1208: NULL,
1209: CCLA.TRX_ID,
1657: NULL,
1658: CCLA.ROLLUP_DATE,
1659: CCLA.SOURCE_DOC_ID,
1660: CCLA.SOURCE_DOC_TYPE,
1661: fnd_global.user_id,
1662: Sysdate,
1663: fnd_global.user_id,
1664: Sysdate,
1665: fnd_global.login_id,
1659: CCLA.SOURCE_DOC_ID,
1660: CCLA.SOURCE_DOC_TYPE,
1661: fnd_global.user_id,
1662: Sysdate,
1663: fnd_global.user_id,
1664: Sysdate,
1665: fnd_global.login_id,
1666: CCLA.TRANSACTION_CURRENCY_CODE,
1667: CCLA.EXCHANGE_RATE,
1661: fnd_global.user_id,
1662: Sysdate,
1663: fnd_global.user_id,
1664: Sysdate,
1665: fnd_global.login_id,
1666: CCLA.TRANSACTION_CURRENCY_CODE,
1667: CCLA.EXCHANGE_RATE,
1668: CCLA.ACCTD_TRANSACTION_AMOUNT,
1669: CCLA.TRX_ID,
2014: NULL,
2015: CCLA.ROLLUP_DATE,
2016: CCLA.SOURCE_DOC_ID,
2017: CCLA.SOURCE_DOC_TYPE,
2018: fnd_global.user_id,
2019: Sysdate,
2020: fnd_global.user_id,
2021: Sysdate,
2022: fnd_global.login_id,
2016: CCLA.SOURCE_DOC_ID,
2017: CCLA.SOURCE_DOC_TYPE,
2018: fnd_global.user_id,
2019: Sysdate,
2020: fnd_global.user_id,
2021: Sysdate,
2022: fnd_global.login_id,
2023: CCLA.TRANSACTION_CURRENCY_CODE,
2024: CCLA.EXCHANGE_RATE,
2018: fnd_global.user_id,
2019: Sysdate,
2020: fnd_global.user_id,
2021: Sysdate,
2022: fnd_global.login_id,
2023: CCLA.TRANSACTION_CURRENCY_CODE,
2024: CCLA.EXCHANGE_RATE,
2025: CCLA.ACCTD_TRANSACTION_AMOUNT,
2026: CCLA.TRX_ID,
2163: cn_message_pkg.begin_batch
2164: (x_process_type => 'RESULTS_TRANSFER',
2165: x_parent_proc_audit_id => null,
2166: x_process_audit_id => l_process_audit_id,
2167: x_request_id => fnd_global.conc_request_id,
2168: p_org_id => p_org_id);
2169:
2170: debugmsg('Results Transfer : Start of Transfer');
2171: debugmsg('Results Transfer : process_audit_id is ' || l_process_audit_id );
2379: cn_message_pkg.begin_batch
2380: (x_process_type => 'ALLOCATION_TRANSFER',
2381: x_parent_proc_audit_id => null,
2382: x_process_audit_id => l_process_audit_id,
2383: x_request_id => fnd_global.conc_request_id,
2384: p_org_id => p_org_id);
2385:
2386: SELECT cn_sca_logical_batches_s.NEXTVAL
2387: INTO l_logical_batch_id
3214: NULL,
3215: CCH.ROLLUP_DATE,
3216: NULL,
3217: CCH.SOURCE_DOC_TYPE,
3218: fnd_global.user_id,
3219: Sysdate,
3220: fnd_global.user_id,
3221: Sysdate,
3222: fnd_global.login_id,
3216: NULL,
3217: CCH.SOURCE_DOC_TYPE,
3218: fnd_global.user_id,
3219: Sysdate,
3220: fnd_global.user_id,
3221: Sysdate,
3222: fnd_global.login_id,
3223: CCH.ORIG_CURRENCY_CODE,
3224: CCH.EXCHANGE_RATE,
3218: fnd_global.user_id,
3219: Sysdate,
3220: fnd_global.user_id,
3221: Sysdate,
3222: fnd_global.login_id,
3223: CCH.ORIG_CURRENCY_CODE,
3224: CCH.EXCHANGE_RATE,
3225: -1 * NVL(CCH.TRANSACTION_AMOUNT, 0),
3226: NULL, -- CCH.TRX_ID,
3772: NULL,
3773: CCH.ROLLUP_DATE,
3774: NULL,
3775: CCH.SOURCE_DOC_TYPE,
3776: fnd_global.user_id,
3777: Sysdate,
3778: fnd_global.user_id,
3779: Sysdate,
3780: fnd_global.login_id,
3774: NULL,
3775: CCH.SOURCE_DOC_TYPE,
3776: fnd_global.user_id,
3777: Sysdate,
3778: fnd_global.user_id,
3779: Sysdate,
3780: fnd_global.login_id,
3781: CCH.ORIG_CURRENCY_CODE,
3782: CCH.EXCHANGE_RATE,
3776: fnd_global.user_id,
3777: Sysdate,
3778: fnd_global.user_id,
3779: Sysdate,
3780: fnd_global.login_id,
3781: CCH.ORIG_CURRENCY_CODE,
3782: CCH.EXCHANGE_RATE,
3783: -1 * NVL(CCH.TRANSACTION_AMOUNT, 0),
3784: NULL, -- CCH.TRX_ID,
3931:
3932:
3933: BEGIN
3934:
3935: l_request_id := fnd_global.conc_request_id;
3936:
3937: cn_message_pkg.begin_batch(
3938: x_process_type => 'SCA Batch Runner'
3939: ,x_parent_proc_audit_id => p_parent_proc_audit_id