APPS.RCI_ORG_DFCY_ETL_PKG dependencies on RCI_DR_INC

Line 95: FROM rci_dr_inc

91: l_stmt_id := 0;
92:
93: SELECT last_run_date
94: into l_last_run_date
95: FROM rci_dr_inc
96: WHERE fact_name = p_fact_name ;
97:
98: RETURN l_last_run_date;
99: EXCEPTION

Line 193: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_PROC_DFCY_F';

189: x_global_start_date => g_global_start_date
190: ,x_rci_schema => g_rci_schema);
191:
192: l_stmnt_id := 10;
193: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_PROC_DFCY_F';
194:
195: ----dbms_output.put_line( '2 **************' );
196:
197: l_stmnt_id := 20;

Line 452: INSERT INTO rci_dr_inc( fact_name

448:
449: ----dbms_output.put_line( '5 **************' );
450:
451: l_stmnt_id :=60;
452: INSERT INTO rci_dr_inc( fact_name
453: ,last_run_date
454: ,created_by
455: ,creation_date
456: ,last_update_date

Line 536: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_PROC_DFCY_F';

532: x_global_start_date => g_global_start_date
533: ,x_rci_schema => g_rci_schema);
534:
535: l_stmnt_id := 10;
536: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_PROC_DFCY_F';
537:
538: ----dbms_output.put_line( '2 **************' );
539:
540: l_stmnt_id := 20;

Line 714: INSERT INTO rci_dr_inc( fact_name

710:
711: ----dbms_output.put_line( '5 **************' );
712:
713: l_stmnt_id :=60;
714: INSERT INTO rci_dr_inc( fact_name
715: ,last_run_date
716: ,created_by
717: ,creation_date
718: ,last_update_date

Line 993: UPDATE rci_dr_inc

989: end loop;
990:
991:
992: l_stmnt_id :=50;
993: UPDATE rci_dr_inc
994: SET last_run_date = l_run_date
995: ,last_update_date = sysdate
996: ,last_updated_by = l_user_id
997: ,last_update_login = l_login_id

Line 1232: UPDATE rci_dr_inc

1228: end loop;
1229:
1230:
1231: l_stmnt_id :=50;
1232: UPDATE rci_dr_inc
1233: SET last_run_date = l_run_date
1234: ,last_update_date = sysdate
1235: ,last_updated_by = l_user_id
1236: ,last_update_login = l_login_id