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.IGS_AD_IMP_001 dependencies on IGS_AD_TRMDT_INT

Line 237: UPDATE igs_ad_trmdt_int trmdt

233: );
234: COMMIT;
235:
236: -- Based upon transcript term child
237: UPDATE igs_ad_trmdt_int trmdt
238: SET status = '4',
239: error_code = 'E347',
240: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
241: WHERE status = '1'

Line 253: AND EXISTS (SELECT 1 FROM igs_ad_trmdt_int WHERE status <> '1' AND interface_transcript_id = txcpt.interface_transcript_id);

249: error_code = 'E347',
250: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
251: WHERE status = '1'
252: AND interface_run_id = p_interface_run_id
253: AND EXISTS (SELECT 1 FROM igs_ad_trmdt_int WHERE status <> '1' AND interface_transcript_id = txcpt.interface_transcript_id);
254: COMMIT;
255:
256: -- Based upon academic history child
257: UPDATE igs_ad_acadhis_int_all acadhis