[Home] [Help]
14:
15: /*-------------------------------------------------------------------------------------------------------------
16: Following package variable keeps the enrp_get_enr_cat function parameters values.
17: -------------------------------------------------------------------------------------------------------------*/
18: pkg_person_id igs_pe_person.person_id%TYPE;
19: pkg_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;
20: pkg_cal_type igs_ca_inst.cal_type%TYPE;
21: pkg_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
22: pkg_session_enrolment_cat igs_as_sc_atmpt_enr.enrolment_cat%TYPE;
138: --(pathipat) Modified cursor for performance issues. Bug No: 2432563
139: -- Removed variables not used.
140:
141: CURSOR c_prsn_encumb
142: (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
143: SELECT 1
144: FROM IGS_PE_PERS_ENCUMB
145: WHERE person_id = cp_person_id AND
146: (l_sysdate BETWEEN start_dt AND (expiry_dt - 1) OR
148:
149:
150: BEGIN
151:
152: -- This module determines whether or not a IGS_PE_PERSON is
153: -- an encumbranced student and returns the appropriate
154: -- indicator
155:
156: -- (pathipat) 'For' loop replaced with the following code, Bug: 2432563
516: p_enr_method_type OUT NOCOPY VARCHAR2 )
517: AS
518: BEGIN
519: DECLARE
520: v_person_id IGS_PE_PERSON.person_id%TYPE;
521: v_person_prefs_rec IGS_PE_PERS_PREFS%ROWTYPE;
522: CURSOR c_person(
523: cp_username IGS_PE_PERSON.oracle_username%TYPE) IS
524: SELECT person_id
519: DECLARE
520: v_person_id IGS_PE_PERSON.person_id%TYPE;
521: v_person_prefs_rec IGS_PE_PERS_PREFS%ROWTYPE;
522: CURSOR c_person(
523: cp_username IGS_PE_PERSON.oracle_username%TYPE) IS
524: SELECT person_id
525: FROM IGS_PE_PERSON
526: WHERE oracle_username = cp_username;
527: CURSOR c_person_prefs(
521: v_person_prefs_rec IGS_PE_PERS_PREFS%ROWTYPE;
522: CURSOR c_person(
523: cp_username IGS_PE_PERSON.oracle_username%TYPE) IS
524: SELECT person_id
525: FROM IGS_PE_PERSON
526: WHERE oracle_username = cp_username;
527: CURSOR c_person_prefs(
528: cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
529: SELECT *
524: SELECT person_id
525: FROM IGS_PE_PERSON
526: WHERE oracle_username = cp_username;
527: CURSOR c_person_prefs(
528: cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
529: SELECT *
530: FROM IGS_PE_PERS_PREFS
531: WHERE person_id = cp_person_id;
532: BEGIN
529: SELECT *
530: FROM IGS_PE_PERS_PREFS
531: WHERE person_id = cp_person_id;
532: BEGIN
533: -- this module gets the enrolment values for a IGS_PE_PERSON's preference
534: -- table
535:
536: -- commented after ORACLE_USERNAME issue...
537: -- added after ORACLE_USERNAME issue...
590: pue.s_encmb_effect_type = pee.s_encmb_effect_type AND
591: pue.pee_start_dt = pee.pee_start_dt AND
592: pue.pee_sequence_number = pee.sequence_number;
593: BEGIN
594: -- This function validates whether or not a IGS_PE_PERSON is
595: -- excluded from admission or enrolment in a specific IGS_PS_UNIT.
596: -- Validate the input parameters
597: IF p_person_id IS NULL OR
598: p_course_cd IS NULL OR
645: -- Cursor modified for the bug# 1956253
646: CURSOR pe_typ_cd IS
647: SELECT DISTINCT pti.person_type_code
648: FROM igs_pe_typ_instances_all pti,
649: igs_pe_person_types ppt
650: WHERE person_id = p_person_id AND
651: ppt.system_type = 'STUDENT' AND
652: ppt.person_type_code = pti.person_type_code AND
653: SYSDATE BETWEEN start_date and NVL(end_date,igs_ge_date.igsdate('9999/01/01'));
671: Function Get_Staff_Ind(
672: p_person_id IN NUMBER )
673: RETURN VARCHAR2 AS
674:
675: -- Removed select from igs_pe_person_v (pathipat) Bug:2432563
676:
677: CURSOR pe_typ_cd IS
678: SELECT pti.person_type_code
679: FROM igs_pe_typ_instances pti