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_DR_INC

Line 90: FROM rci_dr_inc

86: l_stmt_id := 0;
87:
88: SELECT last_run_date
89: into l_last_run_date
90: FROM rci_dr_inc
91: WHERE fact_name = p_fact_name ;
92:
93: RETURN l_last_run_date;
94: EXCEPTION

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 374: INSERT INTO rci_dr_inc( fact_name

370: and acb.certification_period_set_name = agpv.period_set_name;
371:
372: l_stmnt_id :=40;
373:
374: INSERT INTO rci_dr_inc( fact_name
375: ,last_run_date
376: ,created_by
377: ,creation_date
378: ,last_update_date

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 574: INSERT INTO rci_dr_inc( fact_name

570: ----dbms_output.put_line( '4 **************' );
571:
572: l_stmnt_id :=50;
573:
574: INSERT INTO rci_dr_inc( fact_name
575: ,last_run_date
576: ,created_by
577: ,creation_date
578: ,last_update_date

Line 782: UPDATE rci_dr_inc

778: and acb.certification_period_name = agpv.period_name
779: and acb.certification_period_set_name = agpv.period_set_name;
780:
781: l_stmnt_id :=40;
782: UPDATE rci_dr_inc
783: SET last_run_date = l_run_date
784: ,last_update_date = sysdate
785: ,last_updated_by = l_user_id
786: ,last_update_login = l_login_id

Line 965: UPDATE rci_dr_inc

961: /** 10.19.2005 npanandi end ***/
962: ORDER BY execs.entity_id,execs.organization_id,execs.process_id asc;
963:
964: l_stmnt_id :=40;
965: UPDATE rci_dr_inc
966: SET last_run_date = l_run_date
967: ,last_update_date = sysdate
968: ,last_updated_by = l_user_id
969: ,last_update_login = l_login_id