[Home] [Help]
72:
73: -- cursor for getting the date aliases that are defined
74: -- at the person type level for the logged on person
75: --modified cursor for bug 3696257
76: CURSOR cur_pe_usr_adisc (cp_person_type igs_pe_person_types.person_type_code%TYPE)
77: IS
78: SELECT nvl(daiv.absolute_val,
79: IGS_CA_GEN_001.calp_set_alias_value(daiv.absolute_val,
80: IGS_CA_GEN_002.cals_clc_dt_from_dai(daiv.ci_sequence_number,
114: l_cur_pe_usr_adisc cur_pe_usr_adisc%ROWTYPE;
115: l_cur_usec_disc_dl cur_usec_disc_dl%ROWTYPE;
116: l_cur_unit_disc_crt cur_unit_disc_crt%ROWTYPE;
117:
118: l_v_person_type igs_pe_person_types.person_type_code%TYPE;
119:
120: -- constant return variables
121: cst_yes CONSTANT VARCHAR2(1) := 'Y';
122: cst_no CONSTANT VARCHAR2(1) := 'N';
636: cous.course_cd(+) = p_course_cd AND
637: cous.crv_version_number(+) = p_version_number AND
638: cous.cal_type(+) = p_cal_type;
639: BEGIN
640: -- If the IGS_PE_PERSON details are set then query for a IGS_PE_PERSON based title
641: IF (p_person_id IS NOT NULL AND
642: p_sequence_number IS NOT NULL) THEN
643: OPEN c_susa;
644: FETCH c_susa INTO v_override_title;
733: AND dt_alias = cp_dt_alias
734: ORDER BY alias_val DESC;
735:
736: -- Cursor to check if an override has been setup for the 'Variation Cutoff' Step at the Person Type level.
737: CURSOR c_get_ovr (p_person_type igs_pe_person.party_type%TYPE ) IS
738: SELECT 'x'
739: FROM IGS_PE_USR_AVAL
740: WHERE person_type = p_person_type AND
741: validation = 'OVR_VAR_CUT_OFF' AND
744: -- ROWTYPE Variables
745: l_cur_en_nstd_usec_dl cur_en_nstd_usec_dl%ROWTYPE;
746: l_cur_s_enr_cal_conf cur_s_enr_cal_conf%ROWTYPE;
747: l_cur_dai_v cur_dai_v%ROWTYPE;
748: l_person_type igs_pe_person.party_type%TYPE := NULL ;
749: l_dummy VARCHAR2(10);
750: l_effective_dt l_cur_dai_v.alias_val%TYPE ;
751: BEGIN
752: --
1129: -- student's enrolled IGS_PS_COURSE offering option on which to match. All of these
1130: -- can be %
1131: -- p_student_comm_type; the commencement type of students to process, being
1132: -- ?NEW? or ?RETURN?. No ALL option is permitted.
1133: -- p_person_id_group (optional); a IGS_PE_PERSON id group from which to limit the
1134: -- students processed. This will allow the pre-enrolments to be confined to
1135: -- any nominated group of specific students.
1136: -- p_dflt_enrolment_cat (optional); indicates the default enrolment cat. This
1137: -- value will only be used if the student has not had one specified (via the
1611: END IF;
1612: END IF;
1613:
1614: IF vl_process THEN
1615: -- Call the pre-enrolment routine for the single IGS_PE_PERSON
1616: IF IGS_EN_GEN_010.ENRP_INS_SNEW_PRENRL(
1617: v_acaiv_rec.person_id,
1618: v_acaiv_rec.course_cd,
1619: p_dflt_enrolment_cat,
2132: CURSOR cur_person_type( cp_person_id igs_pe_typ_instances.person_id%TYPE)
2133: IS
2134: SELECT pti.person_type_code
2135: FROM igs_pe_typ_instances pti,
2136: igs_pe_person_types pt
2137: WHERE pti.person_id = cp_person_id AND
2138: pti.person_type_code = pt.person_type_code AND
2139: pt.system_type = 'SS_ENROLL_STAFF' AND
2140: TRUNC(SYSDATE) BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE)
2149: WHERE person_id = cp_person_id AND
2150: course_cd = NVL(p_course_cd,course_cd) AND
2151: end_date IS NULL AND
2152: person_type_code IN ( SELECT person_type_code
2153: FROM igs_pe_person_types
2154: WHERE system_type = 'STUDENT');
2155: --
2156: -- Cursor to select the Function name of home page attached to the given responsibility.
2157: --
2271: AND unit_version_number = cp_version_number;
2272:
2273: -- Cursor for getting different grading schema's defined for the logged on person type
2274: -- Modiified cursor for performance bug 3696153
2275: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE)
2276: IS
2277: SELECT nvl(dai.absolute_val,
2278: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,
2279: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,
2316: l_cur_en_nstd_usec cur_en_nstd_usec%ROWTYPE;
2317: l_cur_en_cal_conf cur_en_cal_conf%ROWTYPE;
2318:
2319: -- Variables
2320: l_v_person_type igs_pe_person_types.person_type_code%TYPE;
2321: l_b_grade_schema BOOLEAN ;
2322:
2323: BEGIN
2324:
2504: AND version_number = p_unit_ver_num;
2505:
2506: --Check if there exist any user level deadline
2507: --Modified the cursor for performance bug 3696257
2508: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE)
2509: IS
2510: SELECT nvl(dai.absolute_val,
2511: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,
2512: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,
2542: -- Cursor to get the System Type corresponding to the Person Type Code
2543: -- Added as per the bug# 2364461.
2544: CURSOR cur_sys_per_typ(cp_person_type VARCHAR2) IS
2545: SELECT system_type
2546: FROM igs_pe_person_types
2547: WHERE person_type_code = cp_person_type;
2548: l_cur_sys_per_typ cur_sys_per_typ%ROWTYPE;
2549:
2550: -- Cursor to check for audit attempts
2568: l_cur_chk_cp_chg_val cur_chk_cp_chg_val%ROWTYPE;
2569: l_cur_ps_unit_ofr cur_ps_unit_ofr%ROWTYPE;
2570:
2571: -- Variables
2572: l_v_person_type igs_pe_person_types.person_type_code%TYPE;
2573: l_cp_out NUMBER;
2574:
2575: BEGIN
2576: