DBA Data[Home] [Help]

APPS.CSD_RETURNS_BI_PVT dependencies on FND_GLOBAL

Line 135: l_user_id := NVL(fnd_global.USER_ID, -1);

131: -- Constants --
132: lc_proc_name CONSTANT VARCHAR2(30) := 'Initial_Load_RcvTxns_ETL';
133:
134: BEGIN
135: l_user_id := NVL(fnd_global.USER_ID, -1);
136: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
137: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
138: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
139: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

Line 136: l_login_id := NVL(fnd_global.LOGIN_ID, -1);

132: lc_proc_name CONSTANT VARCHAR2(30) := 'Initial_Load_RcvTxns_ETL';
133:
134: BEGIN
135: l_user_id := NVL(fnd_global.USER_ID, -1);
136: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
137: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
138: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
139: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
140: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

Line 137: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);

133:
134: BEGIN
135: l_user_id := NVL(fnd_global.USER_ID, -1);
136: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
137: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
138: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
139: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
140: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
141:

Line 138: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);

134: BEGIN
135: l_user_id := NVL(fnd_global.USER_ID, -1);
136: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
137: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
138: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
139: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
140: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
141:
142: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Receiving Transactions fact ...');

Line 139: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

135: l_user_id := NVL(fnd_global.USER_ID, -1);
136: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
137: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
138: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
139: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
140: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
141:
142: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Receiving Transactions fact ...');
143:

Line 140: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

136: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
137: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
138: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
139: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
140: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
141:
142: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Receiving Transactions fact ...');
143:
144: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_RCV_TXNS_F name ...');

Line 349: l_user_id := NVL(fnd_global.USER_ID, -1);

345: -- Constants --
346: lc_proc_name CONSTANT VARCHAR2(30) := 'Initial_Load_ShpTxns_ETL';
347:
348: BEGIN
349: l_user_id := NVL(fnd_global.USER_ID, -1);
350: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
351: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
352: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
353: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

Line 350: l_login_id := NVL(fnd_global.LOGIN_ID, -1);

346: lc_proc_name CONSTANT VARCHAR2(30) := 'Initial_Load_ShpTxns_ETL';
347:
348: BEGIN
349: l_user_id := NVL(fnd_global.USER_ID, -1);
350: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
351: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
352: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
353: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
354: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

Line 351: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);

347:
348: BEGIN
349: l_user_id := NVL(fnd_global.USER_ID, -1);
350: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
351: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
352: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
353: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
354: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
355:

Line 352: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);

348: BEGIN
349: l_user_id := NVL(fnd_global.USER_ID, -1);
350: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
351: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
352: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
353: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
354: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
355:
356: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Shipping Transactions fact ...');

Line 353: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

349: l_user_id := NVL(fnd_global.USER_ID, -1);
350: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
351: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
352: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
353: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
354: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
355:
356: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Shipping Transactions fact ...');
357:

Line 354: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

350: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
351: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
352: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
353: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
354: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
355:
356: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Shipping Transactions fact ...');
357:
358: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_SHP_TXNS_F name ...');

Line 529: l_user_id := NVL(fnd_global.USER_ID, -1);

525: -- Constants --
526: lc_proc_name CONSTANT VARCHAR2(30) := 'Initial_Load_MtlTxns_ETL';
527:
528: BEGIN
529: l_user_id := NVL(fnd_global.USER_ID, -1);
530: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
531: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
532: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
533: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

Line 530: l_login_id := NVL(fnd_global.LOGIN_ID, -1);

526: lc_proc_name CONSTANT VARCHAR2(30) := 'Initial_Load_MtlTxns_ETL';
527:
528: BEGIN
529: l_user_id := NVL(fnd_global.USER_ID, -1);
530: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
531: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
532: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
533: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
534: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

Line 531: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);

527:
528: BEGIN
529: l_user_id := NVL(fnd_global.USER_ID, -1);
530: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
531: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
532: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
533: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
534: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
535:

Line 532: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);

528: BEGIN
529: l_user_id := NVL(fnd_global.USER_ID, -1);
530: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
531: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
532: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
533: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
534: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
535:
536: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Material Transactions fact ...');

Line 533: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

529: l_user_id := NVL(fnd_global.USER_ID, -1);
530: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
531: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
532: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
533: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
534: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
535:
536: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Material Transactions fact ...');
537:

Line 534: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

530: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
531: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
532: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
533: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
534: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
535:
536: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Material Transactions fact ...');
537:
538: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_MTL_TXNS_F name ...');