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

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,

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

Line 1205: fnd_global.login_id,

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,

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

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

Line 1665: fnd_global.login_id,

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,

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

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

Line 2022: fnd_global.login_id,

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,

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

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

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

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

Line 3222: fnd_global.login_id,

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,

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

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

Line 3780: fnd_global.login_id,

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,

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