APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_APPL_PGMAPPRV

Line 1482: igs_ad_appl_pgmapprv

1478: program_approval_date,
1479: program_approval_status,
1480: approval_notes
1481: FROM
1482: igs_ad_appl_pgmapprv
1483: WHERE
1484: person_id = cp_person_id and
1485: nominated_course_cd = cp_nominated_course_cd and
1486: sequence_number = cp_sequence_number and

Line 1891: IGS_AD_APPL_PGMAPPRV_pkg.INSERT_ROW(

1887: -- program approval
1888:
1889: FOR c_pgmapp_rec IN c_pgmapp_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1890: l_last_error := 'IGS_AD_CHILD_PRG_APPR';
1891: IGS_AD_APPL_PGMAPPRV_pkg.INSERT_ROW(
1892: X_ROWID => l_rowid,
1893: X_APPL_PGMAPPRV_ID => l_primary_key,
1894: X_PERSON_ID => c_pgmapp_rec.person_id,
1895: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,