eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_GEN_003 dependencies on IGS_EN_SU_ATTEMPT

Line 97: -- 1. A IGS_EN_SU_ATTEMPT.exam_location_cd value

93: -- Get the applicable examination IGS_AD_LOCATION for a nominated student
94: -- IGS_PS_UNIT attempt record.
95: -- The routine will search for (in order of preference):
96: -- 0. Non-central examination (see below)
97: -- 1. A IGS_EN_SU_ATTEMPT.exam_location_cd value
98: -- 2. A IGS_EN_STDNT_PS_ATT.exam_location_cd value
99: -- 3. The default exam IGS_AD_LOCATION for the enrolled IGS_PS_UNIT attempt
100: -- If the assessment id is passed as a parameter, the routine will determine
101: -- whether the examination is a non-central examination, in which case all

Line 121: FROM IGS_EN_SU_ATTEMPT sua,

117: CURSOR c_sua IS
118: SELECT sua.location_cd,
119: sua.exam_location_cd,
120: um.s_unit_mode
121: FROM IGS_EN_SU_ATTEMPT sua,
122: IGS_AS_UNIT_CLASS ucl,
123: IGS_AS_UNIT_MODE um
124: WHERE sua.person_id = p_person_id AND
125: sua.course_cd = p_course_cd AND

Line 230: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

226: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
227: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
228: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
229: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
230: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
231: v_finalised_ind VARCHAR2(1);
232: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
233: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
234: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 232: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

228: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
229: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
230: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
231: v_finalised_ind VARCHAR2(1);
232: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
233: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
234: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
235: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
236: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

Line 244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

240: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
241: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
242: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
243: CURSOR c_sua (
244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
245: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
246: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
247: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
248: -- anilk, 22-Apr-2003, Bug# 2829262

Line 245: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

241: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
242: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
243: CURSOR c_sua (
244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
245: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
246: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
247: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
248: -- anilk, 22-Apr-2003, Bug# 2829262
249: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

Line 246: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

242: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
243: CURSOR c_sua (
244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
245: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
246: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
247: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
248: -- anilk, 22-Apr-2003, Bug# 2829262
249: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
250: ) IS

Line 247: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

243: CURSOR c_sua (
244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
245: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
246: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
247: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
248: -- anilk, 22-Apr-2003, Bug# 2829262
249: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
250: ) IS
251: SELECT sut.transfer_course_cd

Line 249: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

245: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
246: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
247: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
248: -- anilk, 22-Apr-2003, Bug# 2829262
249: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
250: ) IS
251: SELECT sut.transfer_course_cd
252: FROM IGS_PS_STDNT_UNT_TRN sut,
253: IGS_EN_SU_ATTEMPT sua

Line 253: IGS_EN_SU_ATTEMPT sua

249: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
250: ) IS
251: SELECT sut.transfer_course_cd
252: FROM IGS_PS_STDNT_UNT_TRN sut,
253: IGS_EN_SU_ATTEMPT sua
254: WHERE sut.person_id = cp_person_id AND
255: sua.person_id = sut.person_id AND
256: -- anilk, 22-Apr-2003, Bug# 2829262
257: sut.uoo_id = cp_uoo_id AND

Line 263: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

259: sua.course_cd = sut.transfer_course_cd AND
260: sua.unit_attempt_status IN (cst_completed, cst_discontin)
261: ORDER BY sua.unit_attempt_status;
262: CURSOR c_suao_gsg (
263: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
264: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
265: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
266: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
267: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

Line 264: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

260: sua.unit_attempt_status IN (cst_completed, cst_discontin)
261: ORDER BY sua.unit_attempt_status;
262: CURSOR c_suao_gsg (
263: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
264: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
265: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
266: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
267: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
268: c_v_finalised_ind VARCHAR2,

Line 265: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

261: ORDER BY sua.unit_attempt_status;
262: CURSOR c_suao_gsg (
263: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
264: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
265: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
266: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
267: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
268: c_v_finalised_ind VARCHAR2,
269: -- anilk, 22-Apr-2003, Bug# 2829262

Line 266: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

262: CURSOR c_suao_gsg (
263: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
264: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
265: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
266: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
267: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
268: c_v_finalised_ind VARCHAR2,
269: -- anilk, 22-Apr-2003, Bug# 2829262
270: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

Line 267: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

263: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
264: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
265: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
266: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
267: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
268: c_v_finalised_ind VARCHAR2,
269: -- anilk, 22-Apr-2003, Bug# 2829262
270: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
271: ) IS

Line 270: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

266: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
267: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
268: c_v_finalised_ind VARCHAR2,
269: -- anilk, 22-Apr-2003, Bug# 2829262
270: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
271: ) IS
272: SELECT gsg.grading_schema_cd,
273: gsg.version_number,
274: gsg.grade,

Line 507: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

503: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
504: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
505: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
506: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
507: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
508: v_finalised_ind VARCHAR2(1);
509: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
510: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
511: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

Line 509: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

505: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
506: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
507: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
508: v_finalised_ind VARCHAR2(1);
509: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
510: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
511: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
512: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
513: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

Line 523: l_course_cd igs_en_su_attempt_all.course_cd%TYPE;

519: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
520: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
521: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
522: v_released_date IGS_AS_SU_STMPTOUT.release_date%TYPE;
523: l_course_cd igs_en_su_attempt_all.course_cd%TYPE;
524:
525: -- smaddali modified cursor for bug#4666657
526: CURSOR c_sua (cp_course_cd igs_en_su_attempt_all.course_Cd%TYPE ) IS
527: SELECT sut.transfer_course_cd , sua.unit_attempt_status

Line 526: CURSOR c_sua (cp_course_cd igs_en_su_attempt_all.course_Cd%TYPE ) IS

522: v_released_date IGS_AS_SU_STMPTOUT.release_date%TYPE;
523: l_course_cd igs_en_su_attempt_all.course_cd%TYPE;
524:
525: -- smaddali modified cursor for bug#4666657
526: CURSOR c_sua (cp_course_cd igs_en_su_attempt_all.course_Cd%TYPE ) IS
527: SELECT sut.transfer_course_cd , sua.unit_attempt_status
528: FROM IGS_PS_STDNT_UNT_TRN sut,
529: IGS_EN_SU_ATTEMPT sua
530: WHERE sut.person_id = p_person_id AND

Line 529: IGS_EN_SU_ATTEMPT sua

525: -- smaddali modified cursor for bug#4666657
526: CURSOR c_sua (cp_course_cd igs_en_su_attempt_all.course_Cd%TYPE ) IS
527: SELECT sut.transfer_course_cd , sua.unit_attempt_status
528: FROM IGS_PS_STDNT_UNT_TRN sut,
529: IGS_EN_SU_ATTEMPT sua
530: WHERE sut.person_id = p_person_id AND
531: sua.person_id = sut.person_id AND
532: -- anilk, 22-Apr-2003, Bug# 2829262
533: sut.uoo_id = p_uoo_id AND

Line 540: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

536: sut.course_cd = cp_course_cd;
537: c_sua_rec c_sua%ROWTYPE;
538:
539: CURSOR c_suao_gsg (
540: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
541: cp_finalised_ind VARCHAR2) IS
542: SELECT suao.outcome_dt,
543: suao.mark,
544: gsg.grading_schema_cd,

Line 695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

691: END assp_get_sua_outcome;
692: FUNCTION assp_get_supp_cal(
693: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
694: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

Line 696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,

692: FUNCTION assp_get_supp_cal(
693: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
694: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

Line 697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

693: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
694: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

Line 698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

694: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
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 ,

Line 699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
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 ,

Line 700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
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 ,

Line 701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
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 )

Line 702: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
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

Line 704: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
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

Line 873: FROM igs_en_su_attempt sua,

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
872: SELECT usai.due_dt
873: FROM igs_en_su_attempt sua,
874: igs_ps_unitass_item usai
875: WHERE sua.person_id = p_person_id AND
876: sua.course_cd = p_course_cd AND
877: -- anilk, 22-Apr-2003, Bug# 2829262

Line 892: FROM igs_en_su_attempt sua,

888: -- In this case it picks up the due date of the assessment item whose logical delete date is
889: -- maximum.
890: CURSOR c_sus_del IS
891: SELECT usai.due_dt
892: FROM igs_en_su_attempt sua,
893: igs_ps_unitass_item usai
894: WHERE sua.person_id = p_person_id AND
895: sua.course_cd = p_course_cd AND
896: -- anilk, 22-Apr-2003, Bug# 2829262

Line 911: FROM IGS_EN_SU_ATTEMPT sua,

907: sua.course_cd) = 'TRUE';
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

Line 929: FROM IGS_EN_SU_ATTEMPT sua,

925: sua.course_cd) = 'TRUE';
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

Line 938: FROM IGS_EN_SU_ATTEMPT sua1,

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

Line 1021: FROM igs_en_su_attempt sua,

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
1020: SELECT usai.reference
1021: FROM igs_en_su_attempt sua,
1022: igs_ps_unitass_item usai
1023: WHERE sua.person_id = p_person_id AND
1024: sua.course_cd = p_course_cd AND
1025: -- anilk, 22-Apr-2003, Bug# 2829262

Line 1040: FROM igs_en_su_attempt sua,

1036: -- In this case it picks up the reference of the assessment item whose logical delete date is
1037: -- maximum.
1038: CURSOR c_sus_del IS
1039: SELECT usai.reference
1040: FROM igs_en_su_attempt sua,
1041: igs_ps_unitass_item usai
1042: WHERE sua.person_id = p_person_id AND
1043: sua.course_cd = p_course_cd AND
1044: -- anilk, 22-Apr-2003, Bug# 2829262

Line 1059: FROM IGS_EN_SU_ATTEMPT sua,

1055: sua.course_cd) = 'TRUE';
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

Line 1078: FROM IGS_EN_SU_ATTEMPT sua,

1074:
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

Line 1087: FROM IGS_EN_SU_ATTEMPT sua1,

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

Line 1284: FROM igs_en_su_attempt

1280: */
1281:
1282: CURSOR c_uoo_id IS
1283: SELECT uoo_id, version_number
1284: FROM igs_en_su_attempt
1285: WHERE person_id = p_person_id AND
1286: course_cd = p_course_cd AND
1287: -- anilk, 22-Apr-2003, Bug# 2829262
1288: uoo_id = p_uoo_id;

Line 1289: CURSOR c_us_grad_ver( l_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

1285: WHERE person_id = p_person_id AND
1286: course_cd = p_course_cd AND
1287: -- anilk, 22-Apr-2003, Bug# 2829262
1288: uoo_id = p_uoo_id;
1289: CURSOR c_us_grad_ver( l_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1290: SELECT grading_schema_cd, gs_version_number
1291: FROM igs_ps_unitass_item
1292: WHERE uoo_id = l_uoo_id AND
1293: ass_id = p_ass_id AND

Line 1295: CURSOR c_u_grad_ver ( l_version_number igs_en_su_attempt.version_number%TYPE) IS

1291: FROM igs_ps_unitass_item
1292: WHERE uoo_id = l_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

Line 1304: l_c_uoo_id igs_en_su_attempt.uoo_id%TYPE;

1300: cal_type = p_cal_type AND
1301: ci_sequence_number = p_ci_sequence_number AND
1302: ass_id = p_ass_id AND
1303: logical_delete_dt IS NULL;
1304: l_c_uoo_id igs_en_su_attempt.uoo_id%TYPE;
1305: l_c_version_number igs_en_su_attempt.version_number%TYPE;
1306:
1307: BEGIN
1308:

Line 1305: l_c_version_number igs_en_su_attempt.version_number%TYPE;

1301: ci_sequence_number = p_ci_sequence_number AND
1302: ass_id = p_ass_id AND
1303: logical_delete_dt IS NULL;
1304: l_c_uoo_id igs_en_su_attempt.uoo_id%TYPE;
1305: l_c_version_number igs_en_su_attempt.version_number%TYPE;
1306:
1307: BEGIN
1308:
1309: OPEN c_uoo_id;

Line 1501: FROM igs_en_su_attempt_all sua,

1497: AND spa.person_id = p_person_id
1498: AND spa.course_cd = p_course_cd
1499: AND ( EXISTS (
1500: SELECT 1
1501: FROM igs_en_su_attempt_all sua,
1502: igs_ca_teach_to_load_v ttl
1503: WHERE sua.person_id = spa.person_id
1504: AND sua.course_cd = spa.course_cd
1505: AND sua.cal_type = ttl.teach_cal_type

Line 1549: v_term_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;

1545: p_person_id IN NUMBER,
1546: p_program_cd IN VARCHAR2
1547: ) RETURN VARCHAR2 AS
1548:
1549: v_term_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1550: v_term_sequence_NUMBER IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1551: BEGIN
1552: get_current_term(p_person_id,
1553: p_program_cd,

Line 1550: v_term_sequence_NUMBER IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

1546: p_program_cd IN VARCHAR2
1547: ) RETURN VARCHAR2 AS
1548:
1549: v_term_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1550: v_term_sequence_NUMBER IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1551: BEGIN
1552: get_current_term(p_person_id,
1553: p_program_cd,
1554: v_term_cal_type,

Line 1565: v_term_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;

1561: p_person_id IN NUMBER,
1562: p_program_cd IN VARCHAR2
1563: ) RETURN VARCHAR2 AS
1564:
1565: v_term_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1566: v_term_sequence_NUMBER IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1567: BEGIN
1568:
1569: get_current_term(p_person_id,

Line 1566: v_term_sequence_NUMBER IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

1562: p_program_cd IN VARCHAR2
1563: ) RETURN VARCHAR2 AS
1564:
1565: v_term_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1566: v_term_sequence_NUMBER IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1567: BEGIN
1568:
1569: get_current_term(p_person_id,
1570: p_program_cd,

Line 1582: v_term_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;

1578: FUNCTION get_spat_location_desc(
1579: p_person_id IN NUMBER,
1580: p_program_cd IN VARCHAR2
1581: ) RETURN VARCHAR2 AS
1582: v_term_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1583: v_term_sequence_NUMBER IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1584: BEGIN
1585:
1586: get_current_term(p_person_id,

Line 1583: v_term_sequence_NUMBER IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

1579: p_person_id IN NUMBER,
1580: p_program_cd IN VARCHAR2
1581: ) RETURN VARCHAR2 AS
1582: v_term_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1583: v_term_sequence_NUMBER IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1584: BEGIN
1585:
1586: get_current_term(p_person_id,
1587: p_program_cd,

Line 1622: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

1618: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
1619: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
1620: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
1621: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
1622: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1623: v_finalised_ind VARCHAR2(1);
1624: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1625: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1626: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 1624: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

1620: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
1621: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
1622: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1623: v_finalised_ind VARCHAR2(1);
1624: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1625: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1626: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1627: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1628: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

Line 1636: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1632: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
1633: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1634: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1635: CURSOR c_sua (
1636: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1637: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1638: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1639: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1640: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

Line 1637: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

1633: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1634: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1635: CURSOR c_sua (
1636: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1637: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1638: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1639: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1640: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1641: ) IS

Line 1638: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

1634: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1635: CURSOR c_sua (
1636: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1637: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1638: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1639: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1640: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1641: ) IS
1642: SELECT sut.transfer_course_cd

Line 1639: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

1635: CURSOR c_sua (
1636: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1637: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1638: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1639: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1640: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1641: ) IS
1642: SELECT sut.transfer_course_cd
1643: FROM IGS_PS_STDNT_UNT_TRN sut,

Line 1640: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

1636: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1637: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1638: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1639: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1640: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1641: ) IS
1642: SELECT sut.transfer_course_cd
1643: FROM IGS_PS_STDNT_UNT_TRN sut,
1644: IGS_EN_SU_ATTEMPT sua

Line 1644: IGS_EN_SU_ATTEMPT sua

1640: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1641: ) IS
1642: SELECT sut.transfer_course_cd
1643: FROM IGS_PS_STDNT_UNT_TRN sut,
1644: IGS_EN_SU_ATTEMPT sua
1645: WHERE sut.person_id = cp_person_id AND
1646: sua.person_id = sut.person_id AND
1647: sut.uoo_id = cp_uoo_id AND
1648: sua.uoo_id = sut.uoo_id AND

Line 1653: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1649: sua.course_cd = sut.transfer_course_cd AND
1650: sua.unit_attempt_status IN (cst_completed, cst_discontin)
1651: ORDER BY sua.unit_attempt_status;
1652: CURSOR c_suao_gsg (
1653: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1654: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1655: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1656: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1657: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

Line 1654: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

1650: sua.unit_attempt_status IN (cst_completed, cst_discontin)
1651: ORDER BY sua.unit_attempt_status;
1652: CURSOR c_suao_gsg (
1653: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1654: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1655: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1656: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1657: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1658: c_v_finalised_ind VARCHAR2,

Line 1655: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

1651: ORDER BY sua.unit_attempt_status;
1652: CURSOR c_suao_gsg (
1653: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1654: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1655: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1656: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1657: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1658: c_v_finalised_ind VARCHAR2,
1659: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

Line 1656: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

1652: CURSOR c_suao_gsg (
1653: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1654: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1655: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1656: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1657: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1658: c_v_finalised_ind VARCHAR2,
1659: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1660: ) IS

Line 1657: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

1653: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1654: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1655: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1656: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1657: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1658: c_v_finalised_ind VARCHAR2,
1659: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1660: ) IS
1661: SELECT gsg.grading_schema_cd,

Line 1659: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

1655: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1656: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1657: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1658: c_v_finalised_ind VARCHAR2,
1659: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1660: ) IS
1661: SELECT gsg.grading_schema_cd,
1662: gsg.version_number,
1663: gsg.grade,

Line 1814: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

1810: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
1811: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
1812: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
1813: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
1814: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1815: v_finalised_ind VARCHAR2(1);
1816: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1817: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1818: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 1816: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

1812: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
1813: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
1814: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1815: v_finalised_ind VARCHAR2(1);
1816: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1817: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1818: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1819: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1820: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

Line 1829: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1825: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1826: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1827: v_marks IGS_AS_SU_STMPTOUT.mark%TYPE;
1828: CURSOR c_sua (
1829: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1830: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1831: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1832: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1833: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

Line 1830: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

1826: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1827: v_marks IGS_AS_SU_STMPTOUT.mark%TYPE;
1828: CURSOR c_sua (
1829: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1830: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1831: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1832: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1833: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1834: ) IS

Line 1831: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

1827: v_marks IGS_AS_SU_STMPTOUT.mark%TYPE;
1828: CURSOR c_sua (
1829: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1830: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1831: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1832: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1833: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1834: ) IS
1835: SELECT sut.transfer_course_cd

Line 1832: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

1828: CURSOR c_sua (
1829: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1830: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1831: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1832: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1833: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1834: ) IS
1835: SELECT sut.transfer_course_cd
1836: FROM IGS_PS_STDNT_UNT_TRN sut,

Line 1833: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

1829: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1830: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1831: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1832: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1833: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1834: ) IS
1835: SELECT sut.transfer_course_cd
1836: FROM IGS_PS_STDNT_UNT_TRN sut,
1837: IGS_EN_SU_ATTEMPT sua

Line 1837: IGS_EN_SU_ATTEMPT sua

1833: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1834: ) IS
1835: SELECT sut.transfer_course_cd
1836: FROM IGS_PS_STDNT_UNT_TRN sut,
1837: IGS_EN_SU_ATTEMPT sua
1838: WHERE sut.person_id = cp_person_id AND
1839: sua.person_id = sut.person_id AND
1840: sut.uoo_id = cp_uoo_id AND
1841: sua.uoo_id = sut.uoo_id AND

Line 1846: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1842: sua.course_cd = sut.transfer_course_cd AND
1843: sua.unit_attempt_status IN (cst_completed, cst_discontin)
1844: ORDER BY sua.unit_attempt_status;
1845: CURSOR c_suao_gsg (
1846: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1847: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1848: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1849: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1850: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

Line 1847: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

1843: sua.unit_attempt_status IN (cst_completed, cst_discontin)
1844: ORDER BY sua.unit_attempt_status;
1845: CURSOR c_suao_gsg (
1846: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1847: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1848: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1849: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1850: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1851: c_v_finalised_ind VARCHAR2,

Line 1848: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

1844: ORDER BY sua.unit_attempt_status;
1845: CURSOR c_suao_gsg (
1846: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1847: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1848: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1849: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1850: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1851: c_v_finalised_ind VARCHAR2,
1852: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

Line 1849: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

1845: CURSOR c_suao_gsg (
1846: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1847: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1848: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1849: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1850: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1851: c_v_finalised_ind VARCHAR2,
1852: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1853: ) IS

Line 1850: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

1846: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1847: c_v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1848: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1849: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1850: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1851: c_v_finalised_ind VARCHAR2,
1852: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1853: ) IS
1854: SELECT gsg.grading_schema_cd,

Line 1852: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

1848: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1849: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1850: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1851: c_v_finalised_ind VARCHAR2,
1852: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1853: ) IS
1854: SELECT gsg.grading_schema_cd,
1855: gsg.version_number,
1856: gsg.grade,