[Home] [Help]
701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
702: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
703: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
704: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
705: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
706: RETURN VARCHAR2 IS
707: gv_other_detail VARCHAR2(1000);
708: -- anilk, 22-Apr-2003, Bug# 2829262
709: CURSOR cur_uoo_id IS
717: AND unit_class = p_unit_class;
718:
719: CURSOR c_ci IS
720: SELECT uai.cal_type
721: FROM IGS_AS_UNITASS_ITEM UAI,
722: IGS_AS_ASSESSMNT_ITM AI,
723: IGS_AS_ASSESSMNT_TYP ATP,
724: IGS_CA_INST CI,
725: IGS_CA_TYPE CAT,
863: -- This function is modified by Nishikant - 08JAN2001 - Enh Bug#2162831.
864: -- Its modified to return the due date for the assessment item if available at
865: -- Unit section level first. If it does not find then it checks at unit offering level.
866: DECLARE
867: v_uai_due_dt IGS_AS_UNITASS_ITEM.due_dt%TYPE;
868:
869: -- This cursor selects the due date of the assessment item at unit section level for
870: -- the student where logical date is null.
871: CURSOR c_sus IS
908:
909: CURSOR c_suv IS
910: SELECT uai.due_dt
911: FROM IGS_EN_SU_ATTEMPT sua,
912: IGS_AS_UNITASS_ITEM uai
913: WHERE sua.person_id = p_person_id AND
914: sua.course_cd = p_course_cd AND
915: -- anilk, 22-Apr-2003, Bug# 2829262
916: sua.uoo_id = p_uoo_id AND
926:
927: CURSOR c_suv_del IS
928: SELECT uai.due_dt
929: FROM IGS_EN_SU_ATTEMPT sua,
930: IGS_AS_UNITASS_ITEM uai
931: WHERE sua.person_id = p_person_id AND
932: sua.course_cd = p_course_cd AND
933: -- anilk, 22-Apr-2003, Bug# 2829262
934: sua.uoo_id = p_uoo_id AND
935: uai.ass_id = p_ass_id AND
936: uai.logical_delete_dt = (
937: SELECT MAX(uai1.logical_delete_dt)
938: FROM IGS_EN_SU_ATTEMPT sua1,
939: IGS_AS_UNITASS_ITEM uai1
940: WHERE sua1.person_id = sua.person_id AND
941: sua1.course_cd = sua.course_cd AND
942: -- anilk, 22-Apr-2003, Bug# 2829262
943: sua1.uoo_id = sua.uoo_id AND
1011: -- This function is modified by Nishikant - 08JAN2001 - Enh Bug#2162831.
1012: -- Its modified to return the reference of the assessment item if available at
1013: -- Unit section level first. If it does not find then it checks at unit offering level.
1014: DECLARE
1015: v_uai_reference IGS_AS_UNITASS_ITEM.reference%TYPE;
1016:
1017: -- This cursor selects the reference of the assessment item at unit section level for
1018: -- the student where logical date is null.
1019: CURSOR c_sus IS
1056:
1057: CURSOR c_suv IS
1058: SELECT uai.reference
1059: FROM IGS_EN_SU_ATTEMPT sua,
1060: IGS_AS_UNITASS_ITEM uai
1061: WHERE sua.person_id = p_person_id AND
1062: sua.course_cd = p_course_cd AND
1063: -- anilk, 22-Apr-2003, Bug# 2829262
1064: sua.uoo_id = p_uoo_id AND
1075:
1076: CURSOR c_suv_del IS
1077: SELECT uai.reference
1078: FROM IGS_EN_SU_ATTEMPT sua,
1079: IGS_AS_UNITASS_ITEM uai
1080: WHERE sua.person_id = p_person_id AND
1081: sua.course_cd = p_course_cd AND
1082: -- anilk, 22-Apr-2003, Bug# 2829262
1083: sua.uoo_id = p_uoo_id AND
1084: uai.ass_id = p_ass_id AND
1085: uai.logical_delete_dt = (
1086: SELECT MAX(uai1.logical_delete_dt)
1087: FROM IGS_EN_SU_ATTEMPT sua1,
1088: IGS_AS_UNITASS_ITEM uai1
1089: WHERE sua1.person_id = sua.person_id AND
1090: sua1.course_cd = sua.course_cd AND
1091: -- anilk, 22-Apr-2003, Bug# 2829262
1092: sua1.uoo_id = sua.uoo_id AND
1293: ass_id = p_ass_id AND
1294: logical_delete_dt IS NULL;
1295: CURSOR c_u_grad_ver ( l_version_number igs_en_su_attempt.version_number%TYPE) IS
1296: SELECT grading_schema_cd, gs_version_number
1297: FROM igs_as_unitass_item
1298: WHERE unit_cd = p_unit_cd AND
1299: version_number = l_version_number AND
1300: cal_type = p_cal_type AND
1301: ci_sequence_number = p_ci_sequence_number AND
1945: END assp_get_sua_rel_marks;
1946:
1947: FUNCTION assp_get_ai_ref(
1948: usaii in igs_ps_unitass_item.unit_section_ass_item_id%type,
1949: uaii in igs_as_unitass_item.unit_ass_item_id%type
1950: )
1951: RETURN VARCHAR2 IS
1952: BEGIN
1953: DECLARE
1954: CURSOR c_ref_ps (usaid igs_ps_unitass_item.unit_section_ass_item_id%TYPE)IS
1955: SELECT reference, release_date
1956: FROM igs_ps_unitass_item
1957: WHERE unit_section_ass_item_id = usaid;
1958: CURSOR c_ref_as (uaid igs_as_unitass_item.unit_ass_item_id%TYPE)IS
1959: SELECT reference, release_date
1960: FROM igs_as_unitass_item
1961: WHERE unit_ass_item_id = uaid;
1962: v_ref c_ref_as%ROWTYPE;
1956: FROM igs_ps_unitass_item
1957: WHERE unit_section_ass_item_id = usaid;
1958: CURSOR c_ref_as (uaid igs_as_unitass_item.unit_ass_item_id%TYPE)IS
1959: SELECT reference, release_date
1960: FROM igs_as_unitass_item
1961: WHERE unit_ass_item_id = uaid;
1962: v_ref c_ref_as%ROWTYPE;
1963:
1964: BEGIN
1979: END assp_get_ai_ref;
1980:
1981: FUNCTION assp_get_ai_reldate(
1982: usaii in igs_ps_unitass_item.unit_section_ass_item_id%type,
1983: uaii in igs_as_unitass_item.unit_ass_item_id%type
1984: )
1985: RETURN DATE IS
1986: BEGIN
1987: DECLARE
1988: CURSOR c_ref_ps (usaid igs_ps_unitass_item.unit_section_ass_item_id%TYPE)IS
1989: SELECT reference, release_date
1990: FROM igs_ps_unitass_item
1991: WHERE unit_section_ass_item_id = usaid;
1992: CURSOR c_ref_as (uaid igs_as_unitass_item.unit_ass_item_id%TYPE)IS
1993: SELECT reference, release_date
1994: FROM igs_as_unitass_item
1995: WHERE unit_ass_item_id = uaid;
1996: v_ref c_ref_as%ROWTYPE;
1990: FROM igs_ps_unitass_item
1991: WHERE unit_section_ass_item_id = usaid;
1992: CURSOR c_ref_as (uaid igs_as_unitass_item.unit_ass_item_id%TYPE)IS
1993: SELECT reference, release_date
1994: FROM igs_as_unitass_item
1995: WHERE unit_ass_item_id = uaid;
1996: v_ref c_ref_as%ROWTYPE;
1997:
1998: BEGIN