DBA Data[Home] [Help]

APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_AS_GRD_SCH_GRADE

Line 619: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

615: v_index BINARY_INTEGER;
616: v_out_string VARCHAR2(300);
617: v_s_result VARCHAR2(20);
618: v_outcome_dt DATE;
619: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
620: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
621: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
622: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
623: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;

Line 620: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

616: v_out_string VARCHAR2(300);
617: v_s_result VARCHAR2(20);
618: v_outcome_dt DATE;
619: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
620: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
621: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
622: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
623: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
624: cst_trn_sut_ln CONSTANT VARCHAR2(15) := 'TRN_SUT_LN';

Line 621: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

617: v_s_result VARCHAR2(20);
618: v_outcome_dt DATE;
619: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
620: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
621: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
622: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
623: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
624: cst_trn_sut_ln CONSTANT VARCHAR2(15) := 'TRN_SUT_LN';
625: cst_trn_sut_cd CONSTANT VARCHAR2(15) := 'TRN_SUT_CD';

Line 622: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;

618: v_outcome_dt DATE;
619: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
620: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
621: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
622: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
623: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
624: cst_trn_sut_ln CONSTANT VARCHAR2(15) := 'TRN_SUT_LN';
625: cst_trn_sut_cd CONSTANT VARCHAR2(15) := 'TRN_SUT_CD';
626: cst_trn_sut_ul CONSTANT VARCHAR2(15) := 'TRN_SUT_UL';

Line 1204: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

1200: cst_trn_sua_cp CONSTANT VARCHAR2(15) := 'TRN_SUA_CP';
1201: cst_trn_sua_gv CONSTANT VARCHAR2(15) := 'TRN_SUA_GV';
1202: v_index BINARY_INTEGER;
1203: v_outcome_dt DATE;
1204: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1205: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1206: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1207: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
1208: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;

Line 1205: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

1201: cst_trn_sua_gv CONSTANT VARCHAR2(15) := 'TRN_SUA_GV';
1202: v_index BINARY_INTEGER;
1203: v_outcome_dt DATE;
1204: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1205: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1206: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1207: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
1208: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
1209: v_s_result_type VARCHAR2(20);

Line 1206: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

1202: v_index BINARY_INTEGER;
1203: v_outcome_dt DATE;
1204: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1205: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1206: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1207: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
1208: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
1209: v_s_result_type VARCHAR2(20);
1210: v_out_string VARCHAR2(200);

Line 1207: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;

1203: v_outcome_dt DATE;
1204: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1205: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1206: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1207: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
1208: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
1209: v_s_result_type VARCHAR2(20);
1210: v_out_string VARCHAR2(200);
1211: