APPS.IGS_UC_DAT_IMP_FROM_UCAS dependencies on IGS_UC_APPLICANTS

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 53: request_copy_app_frm_ind, cef_no are added to IGS_UC_APPLICANTS TBH call w.r.t. UCFD06, bug 2574566.

49: Known limitations,enhancements,remarks:
50: Change History
51: Who When What
52: rbezawad 2-Oct-2002 6 Columns choices_transparent_ind, extra_status, extra_passport_no, request_app_dets_ind,
53: request_copy_app_frm_ind, cef_no are added to IGS_UC_APPLICANTS TBH call w.r.t. UCFD06, bug 2574566.
54: ayedubat 13-NOV-2002 Columns from System_code to edu_qualification are added to IGS_UC_APPLICANTS TBH call for Enh Bug# 2643048
55: ayedubat 04-DEC-2002 Changed the WHERE clause of the cursor,cur_applicant to add to_char to a.app_no column since the column
56: b.api_person_id is a VARCHAR2 field and changed the comparision of b.person_id_type directly with UCASID to
57: the appropriate id of the UCAS system of the Applicant as for the small systems support

Line 54: ayedubat 13-NOV-2002 Columns from System_code to edu_qualification are added to IGS_UC_APPLICANTS TBH call for Enh Bug# 2643048

50: Change History
51: Who When What
52: rbezawad 2-Oct-2002 6 Columns choices_transparent_ind, extra_status, extra_passport_no, request_app_dets_ind,
53: request_copy_app_frm_ind, cef_no are added to IGS_UC_APPLICANTS TBH call w.r.t. UCFD06, bug 2574566.
54: ayedubat 13-NOV-2002 Columns from System_code to edu_qualification are added to IGS_UC_APPLICANTS TBH call for Enh Bug# 2643048
55: ayedubat 04-DEC-2002 Changed the WHERE clause of the cursor,cur_applicant to add to_char to a.app_no column since the column
56: b.api_person_id is a VARCHAR2 field and changed the comparision of b.person_id_type directly with UCASID to
57: the appropriate id of the UCAS system of the Applicant as for the small systems support
58: for the bug fix: 2670807

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

Line 190: igs_uc_applicants_pkg.update_row

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
194: ,x_check_digit => applicant_rec.check_digit