APPS.IGS_AD_IMP_001 dependencies on IGS_AD_PS_APPL_INST_INT

Line 202: UPDATE igs_ad_ps_appl_inst_int apinst

198: TO_CHAR(l_request_id));
199: END IF;
200:
201: -- Based upon application instance child
202: UPDATE igs_ad_ps_appl_inst_int apinst
203: SET status = '4',
204: error_code = 'E347',
205: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
206: WHERE status = '1'

Line 224: EXISTS (SELECT 1 FROM igs_ad_ps_appl_inst_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)

220: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
221: WHERE status = '1'
222: AND interface_run_id = p_interface_run_id
223: AND (
224: EXISTS (SELECT 1 FROM igs_ad_ps_appl_inst_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)
225: OR EXISTS (SELECT 1 FROM igs_ad_othinst_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)
226: OR EXISTS (SELECT 1 FROM igs_ad_acadint_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)
227: OR EXISTS (SELECT 1 FROM igs_ad_appint_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)
228: OR EXISTS (SELECT 1 FROM igs_ad_splint_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)

Line 507: igs_ad_ps_appl_inst_int aplinst,

503: UNION ALL
504: SELECT 1
505: FROM igs_ad_interface int,
506: igs_ad_apl_int aplint,
507: igs_ad_ps_appl_inst_int aplinst,
508: igs_ad_insthist_int applinsthist
509: WHERE int.interface_id = aplint.interface_id
510: AND aplint.interface_appl_id = aplinst.interface_appl_id
511: AND applinsthist.interface_ps_appl_inst_id = aplinst.interface_ps_appl_inst_id