APPS.IGS_AS_GEN_001 dependencies on IGS_AS_GRD_SCH_GRADE

Line 648: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;

644: -- documentation such as the Academic Transcripts. It determines if failed
645: -- grades are to be displayed and also if grades/IGS_PS_UNIT attempt status are to
646: -- be displayed.
647: DECLARE
648: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
649: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
650: v_grade igs_as_grd_sch_grade.grade%TYPE;
651: v_dummy VARCHAR2 (1);
652: v_result_type igs_as_grd_sch_grade.s_result_type%TYPE;

Line 649: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;

645: -- grades are to be displayed and also if grades/IGS_PS_UNIT attempt status are to
646: -- be displayed.
647: DECLARE
648: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
649: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
650: v_grade igs_as_grd_sch_grade.grade%TYPE;
651: v_dummy VARCHAR2 (1);
652: v_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
653: v_acad_cal_type igs_ca_inst.cal_type%TYPE;

Line 650: v_grade igs_as_grd_sch_grade.grade%TYPE;

646: -- be displayed.
647: DECLARE
648: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
649: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
650: v_grade igs_as_grd_sch_grade.grade%TYPE;
651: v_dummy VARCHAR2 (1);
652: v_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
653: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
654: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 652: v_result_type igs_as_grd_sch_grade.s_result_type%TYPE;

648: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
649: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
650: v_grade igs_as_grd_sch_grade.grade%TYPE;
651: v_dummy VARCHAR2 (1);
652: v_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
653: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
654: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
655: v_acad_start_dt igs_ca_inst.start_dt%TYPE;
656: v_acad_end_dt igs_ca_inst.end_dt%TYPE;

Line 669: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

665: FROM igs_ad_adm_unit_stat aus
666: WHERE aus.administrative_unit_status = p_administrative_unit_status
667: AND aus.show_on_offic_ntfctn_ind = 'N';
668: CURSOR c_gsg (
669: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
670: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
671: cp_grade igs_as_grd_sch_grade.grade%TYPE
672: ) IS
673: SELECT 'x'

Line 670: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,

666: WHERE aus.administrative_unit_status = p_administrative_unit_status
667: AND aus.show_on_offic_ntfctn_ind = 'N';
668: CURSOR c_gsg (
669: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
670: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
671: cp_grade igs_as_grd_sch_grade.grade%TYPE
672: ) IS
673: SELECT 'x'
674: FROM igs_as_grd_sch_grade gsg

Line 671: cp_grade igs_as_grd_sch_grade.grade%TYPE

667: AND aus.show_on_offic_ntfctn_ind = 'N';
668: CURSOR c_gsg (
669: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
670: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
671: cp_grade igs_as_grd_sch_grade.grade%TYPE
672: ) IS
673: SELECT 'x'
674: FROM igs_as_grd_sch_grade gsg
675: WHERE gsg.grading_schema_cd = cp_grading_schema_cd

Line 674: FROM igs_as_grd_sch_grade gsg

670: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
671: cp_grade igs_as_grd_sch_grade.grade%TYPE
672: ) IS
673: SELECT 'x'
674: FROM igs_as_grd_sch_grade gsg
675: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
676: AND gsg.version_number = cp_version_number
677: AND gsg.grade = cp_grade
678: AND gsg.show_on_official_ntfctn_ind = 'N';