[Home] [Help]
3:
4:
5: -- Global variables
6: g_he_submsn_return igs_he_submsn_return%ROWTYPE;
7: g_he_submsn_header igs_he_submsn_header%ROWTYPE;
8:
9:
10:
11: PROCEDURE check_associations(p_user_return_subclass IN VARCHAR2) IS
363: AND version_number = cp_version_number;
364:
365: -- Alternate ID Cursor
366: CURSOR c_alternate_id (p_person_id igs_pe_person.person_id%TYPE,
367: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
368: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
369: SELECT api_person_id,person_id_type, LENGTH(api_person_id) api_length
370: FROM igs_pe_alt_pers_id
371: WHERE pe_person_id = p_person_id
364:
365: -- Alternate ID Cursor
366: CURSOR c_alternate_id (p_person_id igs_pe_person.person_id%TYPE,
367: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
368: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
369: SELECT api_person_id,person_id_type, LENGTH(api_person_id) api_length
370: FROM igs_pe_alt_pers_id
371: WHERE pe_person_id = p_person_id
372: AND person_id_type IN ('HUSID', 'UCASID', 'GTTRID', 'NMASID', 'SWASID')
380: -- or DUPLICATE where the unit attempt enrollment date is less than or equal to the reporting
381: -- period end date.
382: CURSOR c_enr_su (p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
383: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
384: p_enrolment_end_date igs_he_submsn_header.enrolment_end_date%TYPE) IS
385: SELECT 'X'
386: FROM igs_en_su_attempt_all
387: WHERE person_id = p_person_id
388: AND course_cd = p_course_cd
884: shd.enrolment_start_date,
885: shd.enrolment_end_date,
886: shd.offset_days,
887: NVL(shd.apply_to_atmpt_st_dt,'N') apply_to_atmpt_st_dt
888: FROM igs_he_submsn_header shd,
889: igs_he_submsn_return rtn
890: WHERE rtn.sub_rtn_id = p_sub_rtn_id
891: AND rtn.submission_name = shd.submission_name;
892: