APPS.IGS_AD_IMP_003 dependencies on IGS_AD_APP_INTENT

Line 379: AND EXISTS (SELECT 1 FROM igs_ad_app_intent b

375: error_text = l_error_text1
376: WHERE
377: interface_run_id = p_interface_run_id
378: AND status = '2'
379: AND EXISTS (SELECT 1 FROM igs_ad_app_intent b
380: WHERE b.person_id = a.person_id
381: AND b.admission_appl_number = a.admission_appl_number
382: AND b.intent_type_id = a.intent_type_id);
383:

Line 442: p_desc_flex_name => 'IGS_AD_APP_INTENT_FLEX'

438: p_attribute17 => l_appint_rec.attribute17,
439: p_attribute18 => l_appint_rec.attribute18,
440: p_attribute19 => l_appint_rec.attribute19,
441: p_attribute20 => l_appint_rec.attribute20,
442: p_desc_flex_name => 'IGS_AD_APP_INTENT_FLEX'
443: ) THEN
444:
445: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E423', 8405);
446:

Line 458: igs_ad_app_intent_pkg.insert_row (

454:
455: END IF;
456: IF l_error_code IS NULL THEN
457: l_rowid := NULL;
458: igs_ad_app_intent_pkg.insert_row (
459: x_rowid => l_rowid,
460: x_app_intent_id => l_app_int_id,
461: x_person_id => l_appint_rec.person_id,
462: x_admission_appl_number => l_appint_rec.admission_appl_number,