APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_AD_PS_APPL_INST_PKG

Line 1056: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

1052:
1053: FOR c_upd_acai_rec IN c_upd_acai_cur LOOP
1054:
1055: -- Offer validations is successful then update the offer
1056: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
1057: x_rowid => c_upd_acai_rec.row_id ,
1058: x_person_id => c_upd_acai_rec.person_id ,
1059: x_admission_appl_number => c_upd_acai_rec.admission_appl_number ,
1060: x_nominated_course_cd => c_upd_acai_rec.nominated_course_cd ,

Line 1280: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

1276:
1277: -- This procedure updates only entry qualification status from old to new future term application
1278: FOR c_upd_acai_old_rec IN c_upd_acai_old_cur LOOP
1279: FOR c_upd_acai_new_rec IN c_upd_acai_new_cur LOOP
1280: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
1281: x_rowid => c_upd_acai_new_rec.row_id ,
1282: x_person_id => c_upd_acai_new_rec.person_id ,
1283: x_admission_appl_number => c_upd_acai_new_rec.admission_appl_number ,
1284: x_nominated_course_cd => c_upd_acai_new_rec.nominated_course_cd ,

Line 1397: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

1393: x_decline_ofr_reason => c_upd_acai_old_rec.decline_ofr_reason
1394: );
1395:
1396: -- Also update the future application number in the old application number for link
1397: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
1398: x_rowid => c_upd_acai_old_rec.row_id ,
1399: x_person_id => c_upd_acai_old_rec.person_id ,
1400: x_admission_appl_number => c_upd_acai_old_rec.admission_appl_number ,
1401: x_nominated_course_cd => c_upd_acai_old_rec.nominated_course_cd ,

Line 1596: igs_ad_ps_appl_inst_pkg.update_row (

1592: FETCH cur_appl_details INTO cur_appl_details_rec;
1593: CLOSE cur_appl_details;
1594:
1595:
1596: igs_ad_ps_appl_inst_pkg.update_row (
1597: X_ROWID => cur_appl_details_rec.ROWID ,
1598: x_PERSON_ID => cur_appl_details_rec.PERSON_ID ,
1599: x_ADMISSION_APPL_NUMBER => cur_appl_details_rec.ADMISSION_APPL_NUMBER ,
1600: x_NOMINATED_COURSE_CD => cur_appl_details_rec.NOMINATED_COURSE_CD ,