eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCI_PROC_DETAIL_ETL_PKG dependencies on RCI_PROCESS_DETAIL_F

Line 252: DELETE FROM rci_dr_inc where fact_name = 'RCI_PROCESS_DETAIL_F';

248: x_global_start_date => g_global_start_date
249: ,x_rci_schema => g_rci_schema);
250:
251: l_stmnt_id := 10;
252: DELETE FROM rci_dr_inc where fact_name = 'RCI_PROCESS_DETAIL_F';
253:
254: ----dbms_output.put_line( '2 **************' );
255:
256: l_stmnt_id := 20;

Line 257: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_PROCESS_DETAIL_F');

253:
254: ----dbms_output.put_line( '2 **************' );
255:
256: l_stmnt_id := 20;
257: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_PROCESS_DETAIL_F');
258:
259: ----dbms_output.put_line( '3 **************' );
260: l_stmnt_id := 30;
261: l_run_date := sysdate - 5/(24*60);

Line 263: INSERT INTO RCI_PROCESS_DETAIL_F(

259: ----dbms_output.put_line( '3 **************' );
260: l_stmnt_id := 30;
261: l_run_date := sysdate - 5/(24*60);
262:
263: INSERT INTO RCI_PROCESS_DETAIL_F(
264: project_id
265: ,process_org_rev_id
266: ,fin_certification_id
267: ,certification_id

Line 385: 'RCI_PROCESS_DETAIL_F'

381: ,program_id
382: ,program_login_id
383: ,program_application_id
384: ,request_id ) VALUES (
385: 'RCI_PROCESS_DETAIL_F'
386: ,l_run_date
387: ,l_user_id
388: ,sysdate
389: ,sysdate

Line 449: DELETE FROM rci_dr_inc where fact_name = 'RCI_PROCESS_DETAIL_F';

445: x_global_start_date => g_global_start_date
446: ,x_rci_schema => g_rci_schema);
447:
448: l_stmnt_id := 10;
449: DELETE FROM rci_dr_inc where fact_name = 'RCI_PROCESS_DETAIL_F';
450:
451: ----dbms_output.put_line( '2 **************' );
452:
453: l_stmnt_id := 20;

Line 454: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_PROCESS_DETAIL_F');

450:
451: ----dbms_output.put_line( '2 **************' );
452:
453: l_stmnt_id := 20;
454: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_PROCESS_DETAIL_F');
455:
456: ----dbms_output.put_line( '3 **************' );
457: l_stmnt_id := 30;
458: l_run_date := sysdate - 5/(24*60);

Line 460: INSERT INTO RCI_PROCESS_DETAIL_F(

456: ----dbms_output.put_line( '3 **************' );
457: l_stmnt_id := 30;
458: l_run_date := sysdate - 5/(24*60);
459:
460: INSERT INTO RCI_PROCESS_DETAIL_F(
461: project_id
462: ,process_org_rev_id
463: ,fin_certification_id
464: ,certification_id

Line 585: 'RCI_PROCESS_DETAIL_F'

581: ,program_id
582: ,program_login_id
583: ,program_application_id
584: ,request_id ) VALUES (
585: 'RCI_PROCESS_DETAIL_F'
586: ,l_run_date
587: ,l_user_id
588: ,sysdate
589: ,sysdate

Line 654: l_last_run_date := get_last_run_date('RCI_PROCESS_DETAIL_F');

650: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
651:
652: l_stmnt_id := 10;
653: l_proc_name := 'run_incr_load_drm';
654: l_last_run_date := get_last_run_date('RCI_PROCESS_DETAIL_F');
655:
656: IF l_last_run_date IS NULL THEN
657: l_message := 'Please launch the Initial Load Request Set for the Organization Certification Summary page.';
658: RAISE INITIALIZATION_ERROR;

Line 670: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_PROCESS_DETAIL_F');

666: /** 01.16.06 npanandi: added below procedure cal as RSG errors otherwise **/
667: check_initial_load_setup(
668: x_global_start_date => g_global_start_date
669: ,x_rci_schema => g_rci_schema);
670: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_PROCESS_DETAIL_F');
671:
672: INSERT INTO RCI_PROCESS_DETAIL_F(
673: project_id
674: ,process_org_rev_id

Line 672: INSERT INTO RCI_PROCESS_DETAIL_F(

668: x_global_start_date => g_global_start_date
669: ,x_rci_schema => g_rci_schema);
670: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_PROCESS_DETAIL_F');
671:
672: INSERT INTO RCI_PROCESS_DETAIL_F(
673: project_id
674: ,process_org_rev_id
675: ,fin_certification_id
676: ,certification_id

Line 791: WHERE fact_name = 'RCI_PROCESS_DETAIL_F' ;

787: ,program_id = l_program_id
788: ,program_login_id = l_program_login_id
789: ,program_application_id = l_program_application_id
790: ,request_id = l_request_id
791: WHERE fact_name = 'RCI_PROCESS_DETAIL_F' ;
792:
793: l_stmnt_id :=50;
794: commit;
795: retcode := C_OK;

Line 840: l_last_run_date := get_last_run_date('RCI_PROCESS_DETAIL_F');

836: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
837:
838: l_stmnt_id := 10;
839: l_proc_name := 'run_incr_load_drm';
840: l_last_run_date := get_last_run_date('RCI_PROCESS_DETAIL_F');
841:
842: IF l_last_run_date IS NULL THEN
843: l_message := 'Please launch the Initial Load Request Set for the Organization Certification Summary page.';
844: RAISE INITIALIZATION_ERROR;

Line 852: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_PROCESS_DETAIL_F');

848: l_run_date := sysdate - 5/(24*60);
849: ---l_master_org := get_master_organization_id;
850:
851: l_stmnt_id := 30;
852: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_PROCESS_DETAIL_F');
853:
854: INSERT INTO RCI_PROCESS_DETAIL_F(
855: project_id
856: ,process_org_rev_id

Line 854: INSERT INTO RCI_PROCESS_DETAIL_F(

850:
851: l_stmnt_id := 30;
852: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_PROCESS_DETAIL_F');
853:
854: INSERT INTO RCI_PROCESS_DETAIL_F(
855: project_id
856: ,process_org_rev_id
857: ,fin_certification_id
858: ,certification_id

Line 974: WHERE fact_name = 'RCI_PROCESS_DETAIL_F' ;

970: ,program_id = l_program_id
971: ,program_login_id = l_program_login_id
972: ,program_application_id = l_program_application_id
973: ,request_id = l_request_id
974: WHERE fact_name = 'RCI_PROCESS_DETAIL_F' ;
975:
976:
977: commit;
978: retcode := C_OK;