APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_PS_APPL_INST_PKG

Line 2340: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

2336:
2337: FOR c_upd_acai_rec IN c_upd_acai_cur LOOP
2338:
2339: -- Offer validations is successful then update the offer
2340: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
2341: x_rowid => c_upd_acai_rec.row_id ,
2342: x_person_id => c_upd_acai_rec.person_id ,
2343: x_admission_appl_number => c_upd_acai_rec.admission_appl_number ,
2344: x_nominated_course_cd => c_upd_acai_rec.nominated_course_cd ,

Line 2556: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

2552:
2553: -- This procedure updates only entry qualification status from old to new future term application
2554: FOR c_upd_acai_old_rec IN c_upd_acai_old_cur LOOP
2555: FOR c_upd_acai_new_rec IN c_upd_acai_new_cur LOOP
2556: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
2557: x_rowid => c_upd_acai_new_rec.row_id ,
2558: x_person_id => c_upd_acai_new_rec.person_id ,
2559: x_admission_appl_number => c_upd_acai_new_rec.admission_appl_number ,
2560: x_nominated_course_cd => c_upd_acai_new_rec.nominated_course_cd ,

Line 2673: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

2669: x_decline_ofr_reason => c_upd_acai_old_rec.decline_ofr_reason
2670: );
2671:
2672: -- Also update the future application number in the old application number for link
2673: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
2674: x_rowid => c_upd_acai_old_rec.row_id ,
2675: x_person_id => c_upd_acai_old_rec.person_id ,
2676: x_admission_appl_number => c_upd_acai_old_rec.admission_appl_number ,
2677: x_nominated_course_cd => c_upd_acai_old_rec.nominated_course_cd ,