[Home] [Help]
4: --Change History:
5: --Who When What
6: --smadathi 24-AUG-2001 Bug No. 1956374 .The function genp_val_staff_prsn removed
7: --msrinivi 24-AUG-2001 Bug No. 1956374 .The function genp_val_prsn_id removed
8: -- To validate the advanced standing basis IGS_OR_INSTITUTION code.
9: --
10: -- skoppula 15-SEP-2001 Enhancement Bug for Academic Records Maintenance DLD
11: -- To change the credit_percentage logic to include advance standing credit points
12: --
58: BEGIN
59: -- Validate that exemption_institution_cd (IGS_AV_STND_UNIT or IGS_AV_STND_UNIT_LVL
60: -- ) is valid.
61: -- The status is not considered, as it is allowable to select an inactive
62: -- IGS_OR_INSTITUTION for advanced standing basis details.
63:
64: p_message_name := NULL;
65:
66: -- Validate input parameters.
67: IF (p_exempt_inst IS NULL) THEN
68: RETURN TRUE;
69: END IF;
70:
71: -- Validate that exemption IGS_OR_INSTITUTION is valid.
72: FOR v_adv_stnd_exempt_inst_rec IN c_adv_stnd_exempt_inst_v (p_exempt_inst) LOOP
73: RETURN TRUE;
74: END LOOP;
75:
534: FROM igs_ps_ver cv
535: WHERE cv.course_cd = cp_course_cd
536: AND cv.version_number = cp_version_number;
537:
538: CURSOR c_local_inst_ind (cp_ins_cd igs_or_institution.institution_cd%TYPE) IS
539: SELECT ins.local_institution_ind
540: FROM igs_or_institution ins
541: WHERE ins.institution_cd = cp_ins_cd;
542:
536: AND cv.version_number = cp_version_number;
537:
538: CURSOR c_local_inst_ind (cp_ins_cd igs_or_institution.institution_cd%TYPE) IS
539: SELECT ins.local_institution_ind
540: FROM igs_or_institution ins
541: WHERE ins.institution_cd = cp_ins_cd;
542:
543: CURSOR c_adv_stnd_unit_details (
544: cp_person_id igs_av_stnd_unit.person_id%TYPE,
581: v_adv_stnd_granting_status igs_av_stnd_unit.s_adv_stnd_granting_status%TYPE;
582: v_ext_adv_stnd_limit igs_ps_ver.external_adv_stnd_limit%TYPE;
583: v_int_adv_stnd_limit igs_ps_ver.internal_adv_stnd_limit%TYPE;
584: v_credit_points_reqd igs_ps_ver.credit_points_required%TYPE;
585: v_local_inst_ind igs_or_institution.institution_cd%TYPE;
586: v_external_adv_stnd_total NUMBER;
587: v_internal_adv_stnd_total NUMBER;
588: -- 16-Oct-2002; kdande; Bug# 2627933
589: -- Changed the data type to column%TYPE to avoid value error.
751: ) THEN
752: -- add to external totals
753: v_external_adv_stnd_total := v_external_adv_stnd_total + v_credits;
754: ELSE
755: -- selecting the IGS_OR_INSTITUTION.local_institution_cd
756: OPEN c_local_inst_ind (v_adv_stnd.exemption_institution_cd);
757: FETCH c_local_inst_ind INTO v_local_inst_ind;
758:
759: -- not in IGS_OR_INSTITUTION table, so add to external totals
755: -- selecting the IGS_OR_INSTITUTION.local_institution_cd
756: OPEN c_local_inst_ind (v_adv_stnd.exemption_institution_cd);
757: FETCH c_local_inst_ind INTO v_local_inst_ind;
758:
759: -- not in IGS_OR_INSTITUTION table, so add to external totals
760: IF (c_local_inst_ind%NOTFOUND) THEN
761: v_external_adv_stnd_total :=
762: v_external_adv_stnd_total + v_credits;
763: CLOSE c_local_inst_ind;
847: -- add to the external totals
848: v_external_adv_stnd_total :=
849: v_external_adv_stnd_total + v_unit_level.credit_points;
850: ELSE
851: -- selecting the IGS_OR_INSTITUTION.local_institution_cd
852: OPEN c_local_inst_ind (v_unit_level.exemption_institution_cd);
853: FETCH c_local_inst_ind INTO v_local_inst_ind;
854:
855: -- not in IGS_OR_INSTITUTION table, so add to external totals
851: -- selecting the IGS_OR_INSTITUTION.local_institution_cd
852: OPEN c_local_inst_ind (v_unit_level.exemption_institution_cd);
853: FETCH c_local_inst_ind INTO v_local_inst_ind;
854:
855: -- not in IGS_OR_INSTITUTION table, so add to external totals
856: IF (c_local_inst_ind%NOTFOUND) THEN
857: v_external_adv_stnd_total :=
858: v_external_adv_stnd_total + v_unit_level.credit_points;
859: CLOSE c_local_inst_ind;