DBA Data[Home] [Help]

APPS.IGS_PR_GEN_002 dependencies on IGS_AS_SU_STMPTOUT

Line 94: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;

90: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
91: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
92: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
93: v_finalised_ind VARCHAR2(1);
94: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%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;

Line 98: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;

94: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%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

Line 462: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;

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;
465: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
466: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;

Line 466: v_mark IGS_AS_SU_STMPTOUT.mark%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;
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;

Line 729: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;

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;
732: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
733: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;

Line 733: v_mark IGS_AS_SU_STMPTOUT.mark%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;
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;