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_ST_GEN_004 dependencies on IGS_AS_GRD_SCH_GRADE

Line 163: v_dummy_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

159: -- DEETYA element 355
160: DECLARE
161: v_ret_val NUMBER(2);
162: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
163: v_dummy_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
164: v_dummy_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
165: v_dummy_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
166: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
167: CURSOR c_get_unit_attempt_status IS

Line 164: v_dummy_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

160: DECLARE
161: v_ret_val NUMBER(2);
162: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
163: v_dummy_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
164: v_dummy_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
165: v_dummy_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
166: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
167: CURSOR c_get_unit_attempt_status IS
168: SELECT unit_attempt_status

Line 165: v_dummy_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

161: v_ret_val NUMBER(2);
162: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
163: v_dummy_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
164: v_dummy_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
165: v_dummy_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
166: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
167: CURSOR c_get_unit_attempt_status IS
168: SELECT unit_attempt_status
169: FROM IGS_EN_SU_ATTEMPT

Line 166: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

162: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
163: v_dummy_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
164: v_dummy_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
165: v_dummy_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
166: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
167: CURSOR c_get_unit_attempt_status IS
168: SELECT unit_attempt_status
169: FROM IGS_EN_SU_ATTEMPT
170: WHERE person_id = p_person_id AND