APPS.IGS_AD_IMP_001 dependencies on IGS_AD_APL_INT

Line 217: UPDATE igs_ad_apl_int api

213: );
214: COMMIT;
215:
216: -- Based upon application child
217: UPDATE igs_ad_apl_int api
218: SET status = '4',
219: error_code = 'E347',
220: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
221: WHERE status = '1'

Line 297: EXISTS (SELECT 1 FROM igs_ad_apl_int WHERE status <> '1' AND interface_id = ad.interface_id)

293: error_code = 'E347'
294: WHERE status = '1'
295: AND interface_run_id = p_interface_run_id
296: AND (
297: EXISTS (SELECT 1 FROM igs_ad_apl_int WHERE status <> '1' AND interface_id = ad.interface_id)
298: OR EXISTS (SELECT 1 FROM igs_ad_test_int WHERE status <> '1' AND interface_id = ad.interface_id)
299: OR EXISTS (SELECT 1 FROM igs_ad_recruit_int WHERE status <> '1' AND interface_id = ad.interface_id)
300: OR EXISTS (SELECT 1 FROM igs_uc_qual_ints WHERE status <> '1' AND interface_id = ad.interface_id)
301: OR EXISTS (SELECT 1 FROM igs_ad_acadhis_int_all WHERE status <> '1' AND interface_id = ad.interface_id)

Line 494: igs_ad_apl_int aplint,

490: SELECT 1 INTO l_count2
491: FROM DUAL
492: WHERE EXISTS (SELECT 1
493: FROM igs_ad_interface int,
494: igs_ad_apl_int aplint,
495: igs_ad_apphist_int applhist
496: WHERE int.interface_id = aplint.interface_id
497: AND aplint.interface_appl_id = applhist.interface_appl_id
498: AND int.source_type_id = p_source_type_id

Line 506: igs_ad_apl_int aplint,

502: AND applhist.status = '2'
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