[Home] [Help]
4222: sua_rec.uoo_id
4223: );
4224: END IF;
4225: IF (l_flag = 'Y') THEN
4226: igs_pr_cp_gpa.get_sua_cp (
4227: p_person_id => p_person_id,
4228: p_course_cd => p_course_cd,
4229: p_unit_cd => sua_rec.unit_cd,
4230: p_unit_version_number => sua_rec.version_number,
4342: FETCH c_cir INTO rec_cir;
4343: CLOSE c_cir;
4344: --
4345: -- End of new code added to fix Bug# 3103892; nalkumar; 20-Aug-2003
4346: igs_pr_cp_gpa.get_gpa_stats (
4347: p_person_id => p_person_id, -- Person ID passed as the parameter for rulp_val_senna,
4348: p_course_cd => p_course_cd, -- Course code passed as the parameter for rulp_val_senna,
4349: p_stat_type => p_statistic_type, -- Statistic type defined in the rule.
4350: p_load_cal_type => rec_cir.cal_type, -- Load Calendar drived by the above cursor
4406: FETCH c_cir INTO rec_cir;
4407: CLOSE c_cir;
4408: --
4409: -- End of new code added to fix Bug# 3103892; nalkumar; 20-Aug-2003
4410: igs_pr_cp_gpa.get_cp_stats (
4411: p_person_id => p_person_id, -- Person ID passed as the parameter for rulp_val_senna,
4412: p_course_cd => p_course_cd, -- Course code passed as the parameter for rulp_val_senna,
4413: p_stat_type => p_statistic_type, -- Statistic type defined in the rule.
4414: p_load_cal_type => rec_cir.cal_type, -- Load Calendar drived by the above cursor
4746: 'ALL_PERD_PM_ST', 'ALL_PERD_PL_ST', 'ALL_PERDM_ST', 'ALL_PERDL_ST') THEN
4747: -- All Period Rules (Cumulative Rules)
4748: FOR l_sua_all_prd_rec IN cur_sua_all_prd LOOP
4749: -- To get the Earned and Attempted CP values for the Student Unit Attempt
4750: igs_pr_cp_gpa.get_sua_cp (
4751: p_person_id => p_person_id,
4752: p_course_cd => p_course_cd,
4753: p_unit_cd => l_sua_all_prd_rec.unit_cd,
4754: p_unit_version_number => l_sua_all_prd_rec.version_number,
4795: 'CUR_PERD_PM_ST', 'CUR_PERD_PL_ST', 'CUR_PERDM_ST', 'CUR_PERDL_ST') THEN
4796: -- Current Period Rules
4797: FOR l_sua_curr_prd_rec IN cur_sua_curr_prd LOOP
4798: -- To get the Earned and Attempted CP values for the Student Unit Attempt.
4799: igs_pr_cp_gpa.get_sua_cp (
4800: p_person_id => p_person_id,
4801: p_course_cd => p_course_cd,
4802: p_unit_cd => l_sua_curr_prd_rec.unit_cd,
4803: p_unit_version_number => l_sua_curr_prd_rec.version_number,
5007: -- end date on or before the end date of the current progression period.
5008:
5009: IF p_rule_type = 'ACCP' OR p_rule_type = 'ECCP' THEN
5010: FOR l_sua_rec IN c_sua_accp LOOP
5011: Igs_Pr_Cp_Gpa.Get_Sua_Cp(
5012: p_person_id => p_person_id,
5013: p_course_cd => p_course_cd,
5014: p_unit_cd => l_sua_rec.unit_cd,
5015: p_unit_version_number => l_sua_rec.version_number,
5041: -- attempts where the teaching period is related to the current
5042: -- progression period.
5043: ELSIF p_rule_type = 'APCP' OR p_rule_type = 'EPCP' THEN
5044: FOR l_sua_rec IN c_sua_apcp LOOP
5045: Igs_Pr_Cp_Gpa.Get_Sua_Cp(
5046: p_person_id => p_person_id,
5047: p_course_cd => p_course_cd,
5048: p_unit_cd => l_sua_rec.unit_cd,
5049: p_unit_version_number => l_sua_rec.version_number,
5431: -- unit placement set evaluation, program stage set evaluation, person id group set evaluation added .
5432: --nalkumar 18-JUN-2001 This function has been modified as per the requirement of Enrolment eligibility and Validations DLD(Bug# 1830175).
5433: -- The turin functions for pct_mx_ald added.
5434: --svanukur 30-jul-2003 replaced the function IGS_PR_GEN_002.PRGP_GET_SUA_GPA_VAL that calculates the gpa with the new function
5435: -- igs_pr_cp_gpa.get_sua_all as per bug 3031749
5436: --svanukur 08-aug-2003 removed the cursor to get the unit version number since it is already available in gv_member(p_tds.member_index).f2
5437: --svanukur 18-AUG-2003 Modified the '_ER' case to pop the parameters into a PL/SQL table,t_params declared in the main function rulp_val_senna.
5438: -- Also modified the cases , p_param_1 and p_param_2 to push these into the stack. BUG# 3049903
5439: --rvangala 06-Apr-2004 Modified the '_ER' case to remove code which pushes parameters into PL/SQL table (t_params)
5900: l_gpa_value := NULL;
5901: l_best_worst := pop;
5902: l_recommended := pop;
5903:
5904: igs_pr_cp_gpa.get_sua_all (
5905: p_person_id => p_person_id,
5906: p_course_cd => p_course_cd,
5907: p_unit_cd => gv_member(p_tds.member_index).f1,
5908: p_unit_version_number => gv_member(p_tds.member_index).f2,