DBA Data[Home] [Help]

APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_AD_APPL_PGMAPPRV

Line 891: igs_ad_appl_pgmapprv

887: program_approval_date,
888: program_approval_status,
889: approval_notes
890: FROM
891: igs_ad_appl_pgmapprv
892: WHERE
893: person_id = cp_person_id and
894: nominated_course_cd = cp_nominated_course_cd and
895: sequence_number = cp_sequence_number and

Line 1143: IGS_AD_APPL_PGMAPPRV_pkg.INSERT_ROW(

1139: -- program approval
1140:
1141: 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
1142: l_last_error := 'IGS_AD_CHILD_PRG_APPR';
1143: IGS_AD_APPL_PGMAPPRV_pkg.INSERT_ROW(
1144: X_ROWID => l_rowid,
1145: X_APPL_PGMAPPRV_ID => l_primary_key,
1146: X_PERSON_ID => c_pgmapp_rec.person_id,
1147: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,