APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_UNIT_SETS

Line 1232: igs_ad_unit_sets

1228: unit_set_cd,
1229: version_number,
1230: rank
1231: FROM
1232: igs_ad_unit_sets
1233: WHERE
1234: person_id = cp_person_id and
1235: nominated_course_cd = cp_nominated_course_cd and
1236: sequence_number = cp_sequence_number and

Line 1649: Igs_Ad_Unit_Sets_PKG.INSERT_ROW(

1645:
1646: -- Unitsets
1647: FOR c_unitsets_rec IN c_unitsets_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1648: l_last_error := 'IGS_AD_CHILD_UNIT_SETS';
1649: Igs_Ad_Unit_Sets_PKG.INSERT_ROW(
1650: X_ROWID => l_rowid,
1651: X_UNIT_SET_ID => l_primary_key,
1652: X_PERSON_ID => c_unitsets_rec.person_id ,
1653: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,