DBA Data[Home] [Help]

APPS.CSD_HVR_BI_PVT dependencies on FND_GLOBAL

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

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

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

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

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

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

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

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

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

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

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

133: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
134: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
135: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
136: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
137: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
138:
139: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Repair Orders fact ...');
140:
141: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_REPAIR_ORDERS_F name ...');

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

264: lc_proc_name CONSTANT VARCHAR2(30) := 'Incr_Load_Ro_ETL';
265:
266: BEGIN
267:
268: l_user_id := NVL(fnd_global.USER_ID, -1);
269: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
270: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
271: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
272: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

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

265:
266: BEGIN
267:
268: l_user_id := NVL(fnd_global.USER_ID, -1);
269: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
270: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
271: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
272: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
273: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

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

266: BEGIN
267:
268: l_user_id := NVL(fnd_global.USER_ID, -1);
269: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
270: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
271: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
272: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
273: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
274:

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

267:
268: l_user_id := NVL(fnd_global.USER_ID, -1);
269: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
270: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
271: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
272: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
273: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
274:
275: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Repair Orders fact ...');

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

268: l_user_id := NVL(fnd_global.USER_ID, -1);
269: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
270: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
271: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
272: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
273: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
274:
275: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Repair Orders fact ...');
276:

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

269: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
270: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
271: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
272: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
273: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
274:
275: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Repair Orders fact ...');
276:
277: l_last_run_date := get_last_run_date(C_CSD_REPAIR_ORDERS_F);

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

388: -- Constants --
389: lc_proc_name CONSTANT VARCHAR2(30) := 'Initial_Load_Mtl_ETL';
390:
391: BEGIN
392: l_user_id := NVL(fnd_global.USER_ID, -1);
393: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
394: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
395: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
396: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

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

389: lc_proc_name CONSTANT VARCHAR2(30) := 'Initial_Load_Mtl_ETL';
390:
391: BEGIN
392: l_user_id := NVL(fnd_global.USER_ID, -1);
393: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
394: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
395: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
396: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
397: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

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

390:
391: BEGIN
392: l_user_id := NVL(fnd_global.USER_ID, -1);
393: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
394: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
395: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
396: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
397: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
398:

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

391: BEGIN
392: l_user_id := NVL(fnd_global.USER_ID, -1);
393: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
394: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
395: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
396: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
397: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
398:
399: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Materials Consumed fact ...');

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

392: l_user_id := NVL(fnd_global.USER_ID, -1);
393: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
394: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
395: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
396: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
397: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
398:
399: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Materials Consumed fact ...');
400:

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

393: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
394: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
395: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
396: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
397: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
398:
399: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Materials Consumed fact ...');
400:
401: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_MTL_CONSUMED_F name ...');

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

537: lc_proc_name CONSTANT VARCHAR2(30) := 'Incr_Load_Mtl_ETL';
538:
539: BEGIN
540:
541: l_user_id := NVL(fnd_global.USER_ID, -1);
542: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
543: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
544: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
545: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

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

538:
539: BEGIN
540:
541: l_user_id := NVL(fnd_global.USER_ID, -1);
542: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
543: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
544: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
545: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
546: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

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

539: BEGIN
540:
541: l_user_id := NVL(fnd_global.USER_ID, -1);
542: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
543: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
544: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
545: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
546: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
547:

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

540:
541: l_user_id := NVL(fnd_global.USER_ID, -1);
542: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
543: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
544: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
545: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
546: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
547:
548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Materials Consumed fact ...');

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

541: l_user_id := NVL(fnd_global.USER_ID, -1);
542: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
543: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
544: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
545: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
546: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
547:
548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Materials Consumed fact ...');
549:

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

542: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
543: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
544: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
545: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
546: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
547:
548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Materials Consumed fact ...');
549:
550: l_last_run_date := get_last_run_date(C_CSD_MTL_CONSUMED_F);

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

669: -- Constants --
670: lc_proc_name CONSTANT VARCHAR2(30) := 'Initial_Load_Res_ETL';
671:
672: BEGIN
673: l_user_id := NVL(fnd_global.USER_ID, -1);
674: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
675: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
676: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
677: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

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

670: lc_proc_name CONSTANT VARCHAR2(30) := 'Initial_Load_Res_ETL';
671:
672: BEGIN
673: l_user_id := NVL(fnd_global.USER_ID, -1);
674: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
675: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
676: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
677: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
678: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

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

671:
672: BEGIN
673: l_user_id := NVL(fnd_global.USER_ID, -1);
674: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
675: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
676: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
677: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
678: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
679:

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

672: BEGIN
673: l_user_id := NVL(fnd_global.USER_ID, -1);
674: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
675: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
676: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
677: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
678: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
679:
680: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Resources Consumed fact ...');

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

673: l_user_id := NVL(fnd_global.USER_ID, -1);
674: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
675: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
676: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
677: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
678: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
679:
680: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Resources Consumed fact ...');
681:

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

674: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
675: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
676: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
677: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
678: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
679:
680: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Resources Consumed fact ...');
681:
682: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RES_CONSUMED_F name ...');

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

806: lc_proc_name CONSTANT VARCHAR2(30) := 'Incr_Load_Res_ETL';
807:
808: BEGIN
809:
810: l_user_id := NVL(fnd_global.USER_ID, -1);
811: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
812: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
813: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
814: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);

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

807:
808: BEGIN
809:
810: l_user_id := NVL(fnd_global.USER_ID, -1);
811: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
812: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
813: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
814: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
815: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);

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

808: BEGIN
809:
810: l_user_id := NVL(fnd_global.USER_ID, -1);
811: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
812: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
813: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
814: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
815: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
816:

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

809:
810: l_user_id := NVL(fnd_global.USER_ID, -1);
811: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
812: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
813: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
814: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
815: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Resources Consumed fact ...');

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

810: l_user_id := NVL(fnd_global.USER_ID, -1);
811: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
812: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
813: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
814: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
815: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Resources Consumed fact ...');
818:

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

811: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
812: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID, -1);
813: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
814: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
815: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Resources Consumed fact ...');
818:
819: l_last_run_date := get_last_run_date(C_CSD_RES_CONSUMED_F);