[Home] [Help]
186: ) RETURN BOOLEAN IS
187: gv_other_detail VARCHAR2 (255);
188: BEGIN
189: DECLARE
190: cst_enrolled igs_en_su_attempt.unit_attempt_status%TYPE := 'ENROLLED';
191: cst_discontin igs_en_su_attempt.unit_attempt_status%TYPE := 'DISCONTIN';
192: cst_completed igs_en_su_attempt.unit_attempt_status%TYPE := 'COMPLETED';
193: cst_yes VARCHAR2 (1) := 'Y';
194: cst_no VARCHAR2 (1) := 'N';
187: gv_other_detail VARCHAR2 (255);
188: BEGIN
189: DECLARE
190: cst_enrolled igs_en_su_attempt.unit_attempt_status%TYPE := 'ENROLLED';
191: cst_discontin igs_en_su_attempt.unit_attempt_status%TYPE := 'DISCONTIN';
192: cst_completed igs_en_su_attempt.unit_attempt_status%TYPE := 'COMPLETED';
193: cst_yes VARCHAR2 (1) := 'Y';
194: cst_no VARCHAR2 (1) := 'N';
195: cst_id VARCHAR2 (10) := 'ID';
188: BEGIN
189: DECLARE
190: cst_enrolled igs_en_su_attempt.unit_attempt_status%TYPE := 'ENROLLED';
191: cst_discontin igs_en_su_attempt.unit_attempt_status%TYPE := 'DISCONTIN';
192: cst_completed igs_en_su_attempt.unit_attempt_status%TYPE := 'COMPLETED';
193: cst_yes VARCHAR2 (1) := 'Y';
194: cst_no VARCHAR2 (1) := 'N';
195: cst_id VARCHAR2 (10) := 'ID';
196: cst_surname VARCHAR2 (10) := 'SURNAME';
242: NULL n4,
243: 'N'
244: FROM igs_as_msht_su_atmpt mssua,
245: hz_parties pe,
246: igs_en_su_attempt sua
247: WHERE mssua.sheet_number = p_sheet_number
248: AND pe.party_id = mssua.person_id
249: AND sua.person_id(+) = mssua.person_id
250: AND sua.course_cd(+) = mssua.course_cd
354: pe.person_last_name surname,
355: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
356: sua.version_number
357: FROM igs_ps_unit_ofr_opt uoo,
358: igs_en_su_attempt sua,
359: hz_parties pe,
360: igs_as_unit_class ucl
361: WHERE uoo.unit_cd = p_unit_cd
362: AND uoo.cal_type = p_cal_type
382: pe.person_last_name surname,
383: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
384: sua.version_number
385: FROM igs_ps_unit_ofr_opt uoo,
386: igs_en_su_attempt sua,
387: hz_parties pe,
388: igs_as_unit_class ucl
389: WHERE uoo.unit_cd = p_unit_cd
390: AND uoo.cal_type = p_cal_type
417: pe.person_last_name surname,
418: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
419: sua.version_number
420: FROM igs_ps_unit_ofr_opt uoo,
421: igs_en_su_attempt sua,
422: hz_parties pe,
423: igs_as_unit_class ucl
424: WHERE uoo.unit_cd = cp_unit_cd
425: AND uoo.cal_type = cp_cal_type
450: pe.person_last_name surname,
451: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
452: sua.version_number
453: FROM igs_ps_unit_ofr_opt uoo,
454: igs_en_su_attempt sua,
455: hz_parties pe,
456: igs_as_unit_class ucl
457: WHERE uoo.unit_cd = cp_unit_cd
458: AND uoo.cal_type = cp_cal_type
470: l_location_cd VARCHAR2 (10);
471: l_unit_class VARCHAR2 (10);
472: l_person_id NUMBER;
473: l_course_cd VARCHAR2 (10);
474: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
475: l_name VARCHAR2 (30);
476: l_initials VARCHAR2 (10);
477: l_version_number NUMBER;
478: l_rowid VARCHAR2 (25);
842: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
843: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
844: cp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
845: cp_unit_mode IN igs_as_unit_class.unit_mode%TYPE,
846: cp_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
847: ) IS
848: SELECT sua.person_id,
849: sua.course_cd,
850: sua.unit_cd,
853: sua.location_cd,
854: ucl.unit_mode,
855: sua.unit_class,
856: unit_attempt_status
857: FROM igs_en_su_attempt sua,
858: igs_as_unit_class ucl
859: WHERE ucl.unit_class = sua.unit_class
860: AND sua.uoo_id = cp_uoo_id
861: AND sua.location_cd = cp_location_cd
907: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
908: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
909: cp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
910: cp_unit_mode IN igs_as_unit_class.unit_mode%TYPE,
911: cp_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
912: ) IS
913: SELECT pe.person_last_name surname,
914: sua.person_id,
915: sua.course_cd,
919: sua.location_cd,
920: ucl.unit_mode,
921: sua.unit_class,
922: unit_attempt_status
923: FROM igs_en_su_attempt sua,
924: igs_as_unit_class ucl,
925: hz_parties pe
926: WHERE sua.person_id = pe.party_id
927: AND ucl.unit_class = sua.unit_class
1443: -- rec_uoo_id cur_uoo_id%ROWTYPE;
1444: --
1445: -- For checking the unit status i.e., it should be ENROLLED.
1446: --
1447: CURSOR c_sua_status (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1448: SELECT 'X'
1449: FROM igs_en_su_attempt sua
1450: WHERE sua.person_id = p_person_id
1451: AND sua.course_cd = p_course_cd
1445: -- For checking the unit status i.e., it should be ENROLLED.
1446: --
1447: CURSOR c_sua_status (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1448: SELECT 'X'
1449: FROM igs_en_su_attempt sua
1450: WHERE sua.person_id = p_person_id
1451: AND sua.course_cd = p_course_cd
1452: AND sua.uoo_id = cp_uoo_id
1453: AND sua.unit_attempt_status = cst_enrolled;
1455: sua_status_rec c_sua_status%ROWTYPE;
1456: --
1457: -- For checking if the unit assessment item is MANUALLY delete or not.
1458: --
1459: CURSOR c_suaai_deleted (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1460: SELECT 'x'
1461: FROM igs_as_su_atmpt_itm suaai
1462: WHERE suaai.person_id = p_person_id
1463: AND suaai.course_cd = p_course_cd
1483: AND sca.version_number = crv.version_number;
1484: --
1485: --
1486: --
1487: CURSOR c_suaai_an (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1488: SELECT NVL (MAX (suaai.attempt_number), 0) + 1
1489: FROM igs_as_su_atmpt_itm suaai
1490: WHERE suaai.person_id = p_person_id
1491: AND suaai.course_cd = p_course_cd
1497: -- This cursor is declared to fetch the Assessment Items which are are attached to the
1498: -- Assessment Pattern , but already logically deleted. This would enable the logical deleted
1499: -- record to be back in the system.
1500: --
1501: CURSOR c_suaai_upd (cp_ass_id igs_ps_unitass_item.ass_id%TYPE, cp_uoo_id igs_en_su_attempt.uoo_id%TYPE , cp_ass_item_id igs_as_su_atmpt_itm.unit_section_ass_item_id%TYPE ) IS
1502: SELECT suaai.ROWID,
1503: suaai.*,
1504: sag.unit_ass_item_group_id,
1505: sag.us_ass_item_group_id