DBA Data[Home] [Help]

APPS.IGS_AD_IMP_001 dependencies on IGS_AD_TXCPT_INT

Line 247: UPDATE igs_ad_txcpt_int txcpt

243: AND EXISTS (SELECT 1 FROM igs_ad_tundt_int WHERE status <> '1' AND interface_term_dtls_id = trmdt.interface_term_dtls_id);
244: COMMIT;
245:
246: -- Based upon transcript child
247: UPDATE igs_ad_txcpt_int txcpt
248: SET status = '4',
249: error_code = 'E347',
250: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
251: WHERE status = '1'

Line 263: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int WHERE status <> '1' AND interface_acadhis_id = acadhis.interface_acadhis_id);

259: error_code = 'E347',
260: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
261: WHERE status = '1'
262: AND interface_run_id = p_interface_run_id
263: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int WHERE status <> '1' AND interface_acadhis_id = acadhis.interface_acadhis_id);
264: COMMIT;
265:
266: -- Based upon test result child
267: UPDATE igs_ad_test_int tst