APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_OTHER_INST

Line 1253: igs_ad_other_inst

1249: sequence_number ,
1250: institution_code,
1251: new_institution
1252: FROM
1253: igs_ad_other_inst
1254: WHERE
1255: person_id = cp_person_id and
1256: admission_appl_number = cp_admission_appl_number;
1257:

Line 1669: IGS_AD_OTHER_INST_PKG.INSERT_ROW(

1665: --OTHER INSTITUTIONS
1666:
1667: FOR c_othinst_rec IN c_othinst_cur(p_person_id, p_old_admission_appl_number) LOOP
1668: l_last_error := 'IGS_AD_CHILD_OTH_INST';
1669: IGS_AD_OTHER_INST_PKG.INSERT_ROW(
1670: X_ROWID => l_rowid,
1671: X_OTHER_INST_ID => l_primary_key,
1672: X_PERSON_ID => c_othinst_rec.person_id,
1673: X_ADMISSION_APPL_NUMBER =>p_new_admission_appl_number,