DBA Data[Home] [Help]

APPS.CN_SCA_TRX_PROC_PVT dependencies on FND_GLOBAL

Line 147: l_user_id NUMBER(15) := fnd_global.user_id;

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;

Line 148: l_resp_id NUMBER(15) := fnd_global.resp_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;

Line 149: l_login_id NUMBER(15) := fnd_global.login_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:

Line 150: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

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;

Line 151: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

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;

Line 152: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_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;
156:

Line 352: l_user_id NUMBER(15) := fnd_global.user_id;

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:

Line 353: l_login_id NUMBER(15) := fnd_global.login_id;

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 ');

Line 1199: fnd_global.user_id,

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,

Line 1201: fnd_global.user_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,

Line 1203: fnd_global.login_id,

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,

Line 1659: fnd_global.user_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,

Line 1661: fnd_global.user_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,

Line 1663: fnd_global.login_id,

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,

Line 2016: fnd_global.user_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,

Line 2018: fnd_global.user_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,

Line 2020: fnd_global.login_id,

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,

Line 2165: x_request_id => fnd_global.conc_request_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 );

Line 2381: x_request_id => fnd_global.conc_request_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

Line 3216: fnd_global.user_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,

Line 3218: fnd_global.user_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,

Line 3220: fnd_global.login_id,

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,

Line 3772: fnd_global.user_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,

Line 3774: fnd_global.user_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,

Line 3776: fnd_global.login_id,

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,

Line 3929: l_request_id := fnd_global.conc_request_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