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.

[Home] [Help]

APPS.IGS_PR_GEN_002 dependencies on IGS_EN_SU_ATTEMPT_ALL

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 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 ,