APPS.IGS_AD_IMP_001 dependencies on IGS_AD_GEN_016

Line 205: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)

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'
207: AND interface_run_id = p_interface_run_id
208: AND (
209: EXISTS (SELECT 1 FROM igs_ad_insthist_int WHERE status <> '1' AND interface_ps_appl_inst_id = apinst.interface_ps_appl_inst_id)

Line 220: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)

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'
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)

Line 240: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)

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'
242: AND interface_run_id = p_interface_run_id
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;

Line 250: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)

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'
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;

Line 260: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)

256: -- Based upon academic history child
257: UPDATE igs_ad_acadhis_int_all acadhis
258: SET status = '4',
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;

Line 270: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)

266: -- Based upon test result child
267: UPDATE igs_ad_test_int tst
268: SET status = '4',
269: error_code = 'E347',
270: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
271: WHERE status = '1'
272: AND interface_run_id = p_interface_run_id
273: AND EXISTS (SELECT 1 FROM igs_ad_test_segs_int WHERE status <> '1' AND interface_test_id = tst.interface_test_id);
274: COMMIT;

Line 382: IF igs_ad_gen_016.chk_src_cat (p_source_type_id, p_category_entity_table(idx).category_name) THEN

378: l_success := 0;
379: l_error := 0;
380: l_warning := 0;
381: l_total_rec := 0;
382: IF igs_ad_gen_016.chk_src_cat (p_source_type_id, p_category_entity_table(idx).category_name) THEN
383: OPEN c_ref_cur FOR 'SELECT status, count(*) reccount FROM ' ||
384: p_category_entity_table(idx).entity_name ||
385: ' WHERE interface_run_id = :1 GROUP BY status'
386: USING p_interface_run_id;