DBA Data[Home] [Help]

APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_AD_PS_APPL_INST_PKG

Line 2030: igs_ad_ps_appl_inst_pkg.UPDATE_ROW (

2026: FUTURE_TERM_ADM_APPL_NUMBER and FUTURE_TERM_SEQUENCE_NUMBER
2027: to link with the new application instance*/
2028:
2029: IF l_instance_created = TRUE THEN
2030: igs_ad_ps_appl_inst_pkg.UPDATE_ROW (
2031: X_ROWID => l_appl_inst_rec.row_id,
2032: X_PERSON_ID => l_appl_inst_rec.person_id,
2033: X_ADMISSION_APPL_NUMBER => l_appl_inst_rec.ADMISSION_APPL_NUMBER,
2034: X_NOMINATED_COURSE_CD => l_appl_inst_rec.NOMINATED_COURSE_CD,

Line 2171: igs_ad_ps_appl_inst_pkg.UPDATE_ROW (

2167: l_appl_inst_rec.nominated_course_cd, l_sequence_number);
2168: FETCH c_get_appl_instance INTO l_get_appl_instance;
2169: CLOSE c_get_appl_instance;
2170:
2171: igs_ad_ps_appl_inst_pkg.UPDATE_ROW (
2172: X_ROWID => l_get_appl_instance.ROWID,
2173: X_PERSON_ID => l_get_appl_instance.PERSON_ID,
2174: X_ADMISSION_APPL_NUMBER => l_get_appl_instance.ADMISSION_APPL_NUMBER,
2175: X_NOMINATED_COURSE_CD => l_get_appl_instance.NOMINATED_COURSE_CD,

Line 2746: igs_ad_ps_appl_inst_pkg.UPDATE_ROW (

2742: FUTURE_TERM_ADM_APPL_NUMBER and FUTURE_TERM_SEQUENCE_NUMBER
2743: to link with the new application instance*/
2744:
2745: IF l_instance_created = TRUE THEN
2746: igs_ad_ps_appl_inst_pkg.UPDATE_ROW (
2747: X_ROWID => l_appl_inst_rec.row_id,
2748: X_PERSON_ID => l_appl_inst_rec.person_id,
2749: X_ADMISSION_APPL_NUMBER => l_appl_inst_rec.ADMISSION_APPL_NUMBER,
2750: X_NOMINATED_COURSE_CD => l_appl_inst_rec.NOMINATED_COURSE_CD,

Line 2892: igs_ad_ps_appl_inst_pkg.UPDATE_ROW (

2888: /* Update the new application instance PREVIOUS_TERM_ADM_APPL_NUMBER and
2889: PREVIOUS_TERM_SEQUENCE_NUMBER columns to link it with the old application */
2890:
2891:
2892: igs_ad_ps_appl_inst_pkg.UPDATE_ROW (
2893: X_ROWID => l_get_appl_instance.ROWID,
2894: X_PERSON_ID => l_get_appl_instance.PERSON_ID,
2895: X_ADMISSION_APPL_NUMBER => l_get_appl_instance.ADMISSION_APPL_NUMBER,
2896: X_NOMINATED_COURSE_CD => l_get_appl_instance.NOMINATED_COURSE_CD,