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_OPEN_REMED_SUMM_PKG dependencies on RCI_DR_INC

Line 807: INSERT INTO rci_dr_inc( fact_name

803: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
804: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
805: l_run_date := sysdate - 5/(24*60);
806:
807: INSERT INTO rci_dr_inc( fact_name
808: ,last_run_date
809: ,created_by
810: ,creation_date
811: ,last_update_date

Line 829: INSERT INTO rci_dr_inc( fact_name

825: ,l_program_id
826: ,l_program_login_id
827: ,l_program_application_id
828: ,l_request_id );
829: INSERT INTO rci_dr_inc( fact_name
830: ,last_run_date
831: ,created_by
832: ,creation_date
833: ,last_update_date

Line 869: added entries in rci_dr_inc audit table for every load

865: END insert_findings_increment_load;
866:
867: /** 12.16.2005 npanandi: changed a lot of things here
868: added valid report_date_julian in the ETL insert
869: added entries in rci_dr_inc audit table for every load
870: added misc procedures -- check_initial_load_setup and err_mesg
871: **/
872: PROCEDURE insert_findings_initial_load(
873: errbuf IN OUT NOCOPY VARCHAR2

Line 940: DELETE FROM rci_dr_inc where fact_name = 'RCI_OPEN_FINDINGS_F';

936: x_global_start_date => g_global_start_date
937: ,x_rci_schema => g_rci_schema);
938:
939: l_stmnt_id := 10;
940: DELETE FROM rci_dr_inc where fact_name = 'RCI_OPEN_FINDINGS_F';
941:
942: ----dbms_output.put_line( '2 **************' );
943:
944: l_stmnt_id := 20;

Line 1033: UPDATE rci_dr_inc

1029: END LOOP;
1030: END LOOP;
1031:
1032: begin
1033: UPDATE rci_dr_inc
1034: SET last_run_date = l_run_date
1035: ,last_update_date = sysdate
1036: ,last_updated_by = l_user_id
1037: ,last_update_login = l_login_id

Line 1050: INSERT INTO rci_dr_inc( fact_name

1046: END IF;
1047:
1048: exception
1049: when NO_DATA_FOUND then
1050: INSERT INTO rci_dr_inc( fact_name
1051: ,last_run_date
1052: ,created_by
1053: ,creation_date
1054: ,last_update_date

Line 1101: added entries in rci_dr_inc audit table for every load

1097: END insert_remeds_increment_load;
1098:
1099: /** 12.16.2005 npanandi: changed a lot of things here
1100: added valid report_date_julian in the ETL insert
1101: added entries in rci_dr_inc audit table for every load
1102: added misc procedures -- check_initial_load_setup and err_mesg
1103: **/
1104: PROCEDURE insert_remeds_initial_load(
1105: errbuf IN OUT NOCOPY VARCHAR2

Line 1170: DELETE FROM rci_dr_inc where fact_name = 'RCI_OPEN_REMEDIATIONS_F';

1166: x_global_start_date => g_global_start_date
1167: ,x_rci_schema => g_rci_schema);
1168:
1169: l_stmnt_id := 10;
1170: DELETE FROM rci_dr_inc where fact_name = 'RCI_OPEN_REMEDIATIONS_F';
1171:
1172: ----dbms_output.put_line( '2 **************' );
1173:
1174: l_stmnt_id := 20;

Line 1263: UPDATE rci_dr_inc

1259: END LOOP;
1260: END LOOP;
1261:
1262: begin
1263: UPDATE rci_dr_inc
1264: SET last_run_date = l_run_date
1265: ,last_update_date = sysdate
1266: ,last_updated_by = l_user_id
1267: ,last_update_login = l_login_id

Line 1280: INSERT INTO rci_dr_inc( fact_name

1276: END IF;
1277:
1278: exception
1279: when NO_DATA_FOUND then
1280: INSERT INTO rci_dr_inc( fact_name
1281: ,last_run_date
1282: ,created_by
1283: ,creation_date
1284: ,last_update_date