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_PR_GEN_002 dependencies on IGS_EN_SU_ATTEMPT

Line 72: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

68: -- kdande; 22-Apr-2003; Bug# 2829262
69: -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_gpa_val
70: --
71: FUNCTION prgp_get_sua_gpa_val(
72: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
73: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
74: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
75: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
76: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

Line 73: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,

69: -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_gpa_val
70: --
71: FUNCTION prgp_get_sua_gpa_val(
72: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
73: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
74: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
75: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
76: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
77: p_best_worst IN VARCHAR2 ,

Line 74: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

70: --
71: FUNCTION prgp_get_sua_gpa_val(
72: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
73: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
74: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
75: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
76: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
77: p_best_worst IN VARCHAR2 ,
78: p_recommended_ind IN VARCHAR2,

Line 99: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

95: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
96: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
97: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
98: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
99: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
100: v_gpa_val IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE DEFAULT NULL;
101: --
102: -- kdande; 22-Apr-2003; Bug# 2829262
103: -- Added uoo_id field to the WHERE clause of cursor c_sua.

Line 110: FROM IGS_EN_SU_ATTEMPT sua

106: SELECT version_number,
107: location_cd,
108: unit_class,
109: unit_attempt_status
110: FROM IGS_EN_SU_ATTEMPT sua
111: WHERE sua.person_id = p_person_id AND
112: sua.course_cd = p_course_cd AND
113: sua.uoo_id = p_uoo_id;
114: v_sua_rec c_sua%ROWTYPE;

Line 125: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE,

121: WHERE gsg.grading_schema_cd = cp_grading_schema_cd AND
122: gsg.version_number = cp_version_number AND
123: gsg.grade = cp_grade;
124: FUNCTION prgp_get_best_worst (
125: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE,
126: p_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE,
127: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE,
128: p_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE,
129: p_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE,

Line 126: p_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE,

122: gsg.version_number = cp_version_number AND
123: gsg.grade = cp_grade;
124: FUNCTION prgp_get_best_worst (
125: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE,
126: p_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE,
127: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE,
128: p_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE,
129: p_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE,
130: p_ci_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE,

Line 127: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE,

123: gsg.grade = cp_grade;
124: FUNCTION prgp_get_best_worst (
125: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE,
126: p_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE,
127: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE,
128: p_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE,
129: p_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE,
130: p_ci_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE,
131: p_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE,

Line 128: p_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE,

124: FUNCTION prgp_get_best_worst (
125: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE,
126: p_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE,
127: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE,
128: p_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE,
129: p_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE,
130: p_ci_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE,
131: p_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE,
132: p_unit_class IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE,

Line 129: p_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE,

125: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE,
126: p_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE,
127: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE,
128: p_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE,
129: p_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE,
130: p_ci_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE,
131: p_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE,
132: p_unit_class IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE,
133: p_best_worst VARCHAR2)

Line 130: p_ci_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE,

126: p_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE,
127: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE,
128: p_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE,
129: p_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE,
130: p_ci_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE,
131: p_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE,
132: p_unit_class IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE,
133: p_best_worst VARCHAR2)
134: RETURN NUMBER

Line 131: p_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE,

127: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE,
128: p_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE,
129: p_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE,
130: p_ci_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE,
131: p_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE,
132: p_unit_class IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE,
133: p_best_worst VARCHAR2)
134: RETURN NUMBER
135: AS

Line 132: p_unit_class IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE,

128: p_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE,
129: p_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE,
130: p_ci_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE,
131: p_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE,
132: p_unit_class IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE,
133: p_best_worst VARCHAR2)
134: RETURN NUMBER
135: AS
136: gv_other_detail VARCHAR2(255);

Line 434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

430: --
431: FUNCTION prgp_get_sua_prg_prd(
432: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
438: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

Line 435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,

431: FUNCTION prgp_get_sua_prg_prd(
432: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
438: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
439: p_details_ind IN VARCHAR2 ,

Line 436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

432: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
438: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
439: p_details_ind IN VARCHAR2 ,
440: p_unit_attempt_status IN VARCHAR2 ,

Line 459: v_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;

455: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
456: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
457: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
458: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
459: v_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
460: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
461: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
462: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
463: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

Line 460: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

456: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
457: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
458: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
459: v_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
460: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
461: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
462: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
463: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
464: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 467: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

463: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
464: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
465: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
466: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
467: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
468: v_prev_prg_cal_type IGS_CA_INST.cal_type%TYPE;
469: v_prev_prg_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
470: v_previous_cutoff_dt IGS_CA_DA_INST.absolute_val%TYPE;
471: v_cutoff_dt IGS_CA_DA_INST.absolute_val%TYPE;

Line 488: FROM IGS_EN_SU_ATTEMPT sua

484: --
485: CURSOR c_sua IS
486: SELECT sua.discontinued_dt,
487: sua.unit_attempt_status
488: FROM IGS_EN_SU_ATTEMPT sua
489: WHERE sua.person_id = p_person_id AND
490: sua.course_cd = p_course_cd AND
491: sua.uoo_id = p_uoo_id;
492: CURSOR c_sca IS

Line 727: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

723: DECLARE
724: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
725: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
726: cst_abort_WAM CONSTANT NUMBER := -1000000;
727: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
728: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
729: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
730: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
731: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 734: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

730: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
731: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
732: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
733: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
734: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
735: v_finalised_ind VARCHAR2(1);
736: v_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
737: v_effective_progression_ind IGS_AD_ADM_UNIT_STAT.effective_progression_ind%TYPE;
738:

Line 736: v_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;

732: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
733: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
734: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
735: v_finalised_ind VARCHAR2(1);
736: v_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
737: v_effective_progression_ind IGS_AD_ADM_UNIT_STAT.effective_progression_ind%TYPE;
738:
739: --
740: -- kdande; 22-Apr-2003; Bug# 2829262

Line 745: FROM IGS_EN_SU_ATTEMPT sua

741: -- Added uoo_id field to the SELECT clause of cursor c_sua.
742: --
743: CURSOR c_sua IS
744: SELECT sua.unit_attempt_status,sua.administrative_unit_status
745: FROM IGS_EN_SU_ATTEMPT sua
746: WHERE sua.person_id = p_person_id AND
747: sua.course_cd = p_course_cd AND
748: sua.uoo_id = p_uoo_id;
749: CURSOR c_aus (

Line 750: cp_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS

746: WHERE sua.person_id = p_person_id AND
747: sua.course_cd = p_course_cd AND
748: sua.uoo_id = p_uoo_id;
749: CURSOR c_aus (
750: cp_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS
751: SELECT effective_progression_ind
752: FROM IGS_AD_ADM_UNIT_STAT
753: WHERE administrative_unit_status=cp_administrative_unit_status;
754: BEGIN