DBA Data[Home] [Help]

APPS.IGS_IN_GEN_001 dependencies on IGS_AS_GRD_SCH_GRADE

Line 1008: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

1004: cst_completed CONSTANT VARCHAR2(12) := 'COMPLETED';
1005: cst_duplicate CONSTANT VARCHAR2(12) := 'DUPLICATE';
1006: cst_pass CONSTANT VARCHAR2(7) := 'PASS';
1007: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
1008: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1009: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1010: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
1011: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1012: v_result_found BOOLEAN DEFAULT FALSE;

Line 1014: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

1010: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
1011: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1012: v_result_found BOOLEAN DEFAULT FALSE;
1013: v_outcome_dt DATE;
1014: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1015: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1016: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1017: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
1018: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;

Line 1015: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

1011: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1012: v_result_found BOOLEAN DEFAULT FALSE;
1013: v_outcome_dt DATE;
1014: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1015: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1016: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1017: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
1018: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;
1019:

Line 1016: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

1012: v_result_found BOOLEAN DEFAULT FALSE;
1013: v_outcome_dt DATE;
1014: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1015: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1016: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1017: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
1018: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;
1019:
1020: CURSOR c_sua(cp_person_id igs_en_su_attempt.person_id%TYPE,