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