[Home] [Help]
148: Created By : rbezawad
149: Date Created By : 11-NOV-2002
150: Purpose : 1) The admissions decision import process is used to suspend the OSS Applications for the UCAS Wrong Application
151: and the Choice Number marked as lost.
152: 2) The Person Alternate Id stored in IGS_PE_ALT_PERS_ID table for the UCAS Wrong Applicaton should be end dated.
153: 3) Delete the Wrong Application related data from UCAS interface tables.
154: 4) If all wrong application data is successfully deleted from UCAS Interface tables then mark the applicants as
155: expunged by setting the flag in IGS_UC_WRONG_APP.EXPUNGED to 'Y'.
156: 5) log the message in the log file for the each step whether the processing is succussful or not.
158: Know limitations, enhancements or remarks
159: Change History
160: Who When What
161: pkpatel 2-DEC-2002 Bug No: 2599109
162: Modified igs_pe_alt_pers_id_pkg signature to include REGION_CD
163: rbezawad 16-Oct-03 Modified logic to expunge at Application Choice level rather only at Application
164: level w.r.t. ucfd209 build, bug: 2669228.
165: ssaleem 09-FEB-05 Bug 3882788 - DELETION OF INVALID ALTERNATE PERSON IDS
166: anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
255:
256: --To get the Person alternate ID record to End Date
257: CURSOR cur_alt_pers_id (cp_app_no igs_uc_wrong_app.app_no%TYPE) IS
258: SELECT api.ROWID row_id, api.*
259: FROM igs_pe_alt_pers_id api,
260: igs_uc_applicants ucap
261: WHERE api.pe_person_id = ucap.oss_person_id
262: AND api.api_person_id = TO_CHAR(ucap.app_no)
263: AND ucap.app_no = cp_app_no
574: FETCH cur_alt_pers_id INTO l_alt_pers_id_rec;
575:
576: IF cur_alt_pers_id%FOUND THEN
577: BEGIN
578: igs_pe_alt_pers_id_pkg.Update_Row ( x_mode => 'R',
579: x_rowid => l_alt_pers_id_rec.row_id,
580: x_pe_person_id => l_alt_pers_id_rec.pe_person_id,
581: x_api_person_id => l_alt_pers_id_rec.api_person_id,
582: x_api_person_id_uf => l_alt_pers_id_rec.api_person_id_uf,