APPS.RCI_ORG_CERT_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 259: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_SUMM_F';

255: x_global_start_date => g_global_start_date
256: ,x_rci_schema => g_rci_schema);
257:
258: l_stmnt_id := 10;
259: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_SUMM_F';
260:
261: ----dbms_output.put_line( '2 **************' );
262:
263: l_stmnt_id := 20;

Line 441: INSERT INTO rci_dr_inc( fact_name

437: end loop;
438:
439:
440: l_stmnt_id :=50;
441: INSERT INTO rci_dr_inc( fact_name
442: ,last_run_date
443: ,created_by
444: ,creation_date
445: ,last_update_date

Line 526: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_SUMM_F';

522: x_global_start_date => g_global_start_date
523: ,x_rci_schema => g_rci_schema);
524:
525: l_stmnt_id := 10;
526: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_SUMM_F';
527:
528: ----dbms_output.put_line( '2 **************' );
529:
530: l_stmnt_id := 20;

Line 707: INSERT INTO rci_dr_inc( fact_name

703:
704: ----dbms_output.put_line( '5 **************' );
705:
706: l_stmnt_id :=60;
707: INSERT INTO rci_dr_inc( fact_name
708: ,last_run_date
709: ,created_by
710: ,creation_date
711: ,last_update_date

Line 1224: UPDATE rci_dr_inc

1220: ----dbms_output.put_line( '5 **************' );
1221:
1222:
1223: l_stmnt_id :=30;
1224: UPDATE rci_dr_inc
1225: SET last_run_date = l_run_date
1226: ,last_update_date = sysdate
1227: ,last_updated_by = l_user_id
1228: ,last_update_login = l_login_id