APPS.IGS_AD_IMP_015 dependencies on IGS_AD_ACADHIS_INT_ALL

Line 358: UPDATE igs_ad_acadhis_int_all

354: END IF;
355:
356: -- If record failed only due to child record failure
357: -- then set status back to 1 and nullify error code/text
358: UPDATE igs_ad_acadhis_int_all
359: SET error_code = NULL,
360: error_text = NULL,
361: status = '1'
362: WHERE interface_run_id = p_interface_run_id

Line 371: FROM igs_ad_acadhis_int_all

367: UPDATE igs_ad_txcpt_int a
368: SET interface_run_id = p_interface_run_id,
369: (person_id,education_id)
370: = (SELECT person_id,NVL(education_id,update_education_id)
371: FROM igs_ad_acadhis_int_all
372: WHERE interface_acadhis_id = a.interface_acadhis_id)
373: WHERE interface_acadhis_id IN (SELECT interface_acadhis_id
374: FROM igs_ad_acadhis_int_all
375: WHERE interface_run_id = p_interface_run_id

Line 374: FROM igs_ad_acadhis_int_all

370: = (SELECT person_id,NVL(education_id,update_education_id)
371: FROM igs_ad_acadhis_int_all
372: WHERE interface_acadhis_id = a.interface_acadhis_id)
373: WHERE interface_acadhis_id IN (SELECT interface_acadhis_id
374: FROM igs_ad_acadhis_int_all
375: WHERE interface_run_id = p_interface_run_id
376: AND status IN ('1','4'));
377:
378: -- If record failed only due to child record failure