APPS.IGS_UC_DAT_IMP_FROM_UCAS dependencies on IGS_PE_ALT_PERS_ID_V

Line 47: Purpose : To update the IGS_UC_APPLICANTS.OSS_PERSON_ID column with the IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID column value.

43: ) IS
44: /******************************************************************
45: Created By : rbezawad
46: Date Created By : 10-Jun-2002
47: Purpose : To update the IGS_UC_APPLICANTS.OSS_PERSON_ID column with the IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID column value.
48: This needs to be run after running the "Import data from UCAS" and "Admission Import Process".
49: Known limitations,enhancements,remarks:
50: Change History
51: Who When What

Line 171: FROM igs_uc_applicants a, igs_pe_alt_pers_id_v b

167: ,a.nationality
168: ,a.dual_nationality
169: ,a.special_needs
170: ,a.country_birth
171: FROM igs_uc_applicants a, igs_pe_alt_pers_id_v b
172: WHERE a.oss_person_id IS NULL
173: AND b.api_person_id = to_char(a.app_no)
174: AND b.person_id_type = DECODE(a.system_code,'U','UCASID','G','GTTRID','N','NMASID','S','SWASID')
175: AND NVL(b.start_dt, SYSDATE) <= SYSDATE

Line 189: --Updates the IGS_UC_APPLICANTS.OSS_PERSON_ID column with the IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID column value.

185:
186: --Loop through the all the Applicants records that needs to populate the OSS_person_id value.
187: FOR applicant_rec IN cur_applicant
188: LOOP
189: --Updates the IGS_UC_APPLICANTS.OSS_PERSON_ID column with the IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID column value.
190: igs_uc_applicants_pkg.update_row
191: ( x_rowid => applicant_rec.rowid
192: ,x_app_id => applicant_rec.app_id
193: ,x_app_no => applicant_rec.app_no