9: Know limitations, enhancements or remarks
10: Change History
11: Who When What
12: ayedubat 31-DEC-2002 Changed the cur_person_present_in_oss to fetch the records from
13: igs_pe_person_base_v instead of igs_pe_person to improve performance
14: for bug, 2726113
15: (reverse chronological order - newest change first)
16: ***************************************************************/
17:
17:
18: /* To check if the person is present in the oss tables*/
19: CURSOR cur_person_present_in_oss( l_per_id IGS_PE_PERSON.person_id%TYPE) IS
20: SELECT COUNT(*) n_count
21: FROM igs_pe_person_base_v
22: WHERE person_id = l_per_id;
23: person_present_rec cur_person_present_in_oss%ROWTYPE;
24:
25: BEGIN
170:
171: /* smaddali added this cursor to get the person_number to display in the log file , bug 2497516 */
172: CURSOR c_person ( cp_person_id igs_pe_person.person_id%TYPE ) IS
173: SELECT person_number
174: FROM igs_pe_person_base_v
175: WHERE person_id = cp_person_id ;
176: l_person_number igs_pe_person.person_number%TYPE := NULL ;
177:
178: /* cursor to select all applicants and details whose details have not been exported to HESA */
268: SELECT igs_ad_interface_batch_id_s.NEXTVAL
269: FROM dual;
270:
271: -- Get the Person number for the passed person id.
272: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
273: SELECT person_number, last_name surname, first_name given_names, gender sex, birth_date birth_dt
274: FROM igs_pe_person_base_v
275: WHERE person_id = cp_person_id;
276: l_person_info_rec c_person_info%ROWTYPE;
270:
271: -- Get the Person number for the passed person id.
272: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
273: SELECT person_number, last_name surname, first_name given_names, gender sex, birth_date birth_dt
274: FROM igs_pe_person_base_v
275: WHERE person_id = cp_person_id;
276: l_person_info_rec c_person_info%ROWTYPE;
277:
278: -- Get the admission application instance interface records whose import has failed