DBA Data[Home] [Help]

APPS.IGS_RU_GEN_001 dependencies on IGS_AS_SU_STMPTOUT

Line 1039: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;

1035: p_final_ind IN VARCHAR2)
1036: RETURN VARCHAR2 IS
1037: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1038: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
1039: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
1040: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1041: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1042: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1043: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;

Line 1043: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;

1039: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
1040: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1041: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1042: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1043: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
1044: v_original_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1045: v_result VARCHAR2(30);
1046: BEGIN
1047: SELECT unit_attempt_status,

Line 4188: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;

4184:
4185: --
4186: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
4187: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
4188: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
4189: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
4190: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
4191: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
4192: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;

Line 4192: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;

4188: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
4189: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
4190: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
4191: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
4192: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
4193: v_original_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
4194: v_result VARCHAR2(30);
4195: l_progression_period NUMBER ;
4196: l_failed_cp NUMBER := 0;

Line 4730: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;

4726: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4727: l_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
4728:
4729: --OUT varibales to be passed to igs_as_gen_003.assp_get_sua_outcomes Function
4730: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
4731: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
4732: l_version_number igs_as_grd_sch_grade.version_number%TYPE;
4733: l_grade igs_as_grd_sch_grade.grade%TYPE;
4734: l_mark igs_as_su_stmptout.mark%TYPE;

Line 4734: l_mark igs_as_su_stmptout.mark%TYPE;

4730: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
4731: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
4732: l_version_number igs_as_grd_sch_grade.version_number%TYPE;
4733: l_grade igs_as_grd_sch_grade.grade%TYPE;
4734: l_mark igs_as_su_stmptout.mark%TYPE;
4735: l_origin_course_cd igs_en_su_attempt.course_cd%TYPE;
4736:
4737: l_total_attempted_cp NUMBER := 0; -- Replaced Default by :=
4738: l_total_attempted_units NUMBER := 0; -- Replaced Default by :=