eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_AS_GRD_SCH_GRADE

Line 803: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;

799: v_s_progression_outcome_type VARCHAR2 (30);
800: v_upld_person_no_exist VARCHAR2 (1);
801: v_upld_crs_not_enrolled VARCHAR2 (1);
802: v_dummy VARCHAR2 (1);
803: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
804: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
805: --
806: -- Get Grading Entry Configuration
807: --

Line 804: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;

800: v_upld_person_no_exist VARCHAR2 (1);
801: v_upld_crs_not_enrolled VARCHAR2 (1);
802: v_dummy VARCHAR2 (1);
803: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
804: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
805: --
806: -- Get Grading Entry Configuration
807: --
808: CURSOR c_ec IS

Line 993: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

989: --
990: -- Cursor to check if the grade entered in part of the grading schema
991: --
992: CURSOR cur_grade_exists (
993: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
994: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
995: cp_grade igs_as_grd_sch_grade.grade%TYPE
996: ) IS
997: SELECT 'Y' grade_found

Line 994: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,

990: -- Cursor to check if the grade entered in part of the grading schema
991: --
992: CURSOR cur_grade_exists (
993: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
994: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
995: cp_grade igs_as_grd_sch_grade.grade%TYPE
996: ) IS
997: SELECT 'Y' grade_found
998: FROM igs_as_grd_sch_grade gsg

Line 995: cp_grade igs_as_grd_sch_grade.grade%TYPE

991: --
992: CURSOR cur_grade_exists (
993: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
994: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
995: cp_grade igs_as_grd_sch_grade.grade%TYPE
996: ) IS
997: SELECT 'Y' grade_found
998: FROM igs_as_grd_sch_grade gsg
999: WHERE gsg.grading_schema_cd = cp_grading_schema_cd

Line 998: FROM igs_as_grd_sch_grade gsg

994: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
995: cp_grade igs_as_grd_sch_grade.grade%TYPE
996: ) IS
997: SELECT 'Y' grade_found
998: FROM igs_as_grd_sch_grade gsg
999: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
1000: AND gsg.version_number = cp_gs_version_number
1001: AND gsg.grade = cp_grade;
1002: --

Line 1008: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

1004: --
1005: --
1006: --
1007: CURSOR c_calc_grade (
1008: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
1009: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
1010: cp_marks igs_as_grd_sch_grade.lower_mark_range%TYPE
1011: ) IS
1012: SELECT grade

Line 1009: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,

1005: --
1006: --
1007: CURSOR c_calc_grade (
1008: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
1009: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
1010: cp_marks igs_as_grd_sch_grade.lower_mark_range%TYPE
1011: ) IS
1012: SELECT grade
1013: FROM igs_as_grd_sch_grade gsg

Line 1010: cp_marks igs_as_grd_sch_grade.lower_mark_range%TYPE

1006: --
1007: CURSOR c_calc_grade (
1008: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
1009: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
1010: cp_marks igs_as_grd_sch_grade.lower_mark_range%TYPE
1011: ) IS
1012: SELECT grade
1013: FROM igs_as_grd_sch_grade gsg
1014: WHERE gsg.grading_schema_cd = cp_grading_schema_cd

Line 1013: FROM igs_as_grd_sch_grade gsg

1009: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
1010: cp_marks igs_as_grd_sch_grade.lower_mark_range%TYPE
1011: ) IS
1012: SELECT grade
1013: FROM igs_as_grd_sch_grade gsg
1014: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
1015: AND gsg.version_number = cp_gs_version_number
1016: AND system_only_ind = 'N'
1017: AND cp_marks BETWEEN gsg.lower_mark_range AND gsg.upper_mark_range;

Line 1024: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

1020: --
1021: -- Cursor to fix the issue progression outcome uploading incorrect marks and grades
1022: --
1023: CURSOR c_gsg_min_max (
1024: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
1025: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
1026: ) IS
1027: SELECT MIN (gsg.lower_mark_range) min_lower_mark_range,
1028: MAX (gsg.upper_mark_range) max_upper_mark_range

Line 1025: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE

1021: -- Cursor to fix the issue progression outcome uploading incorrect marks and grades
1022: --
1023: CURSOR c_gsg_min_max (
1024: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
1025: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
1026: ) IS
1027: SELECT MIN (gsg.lower_mark_range) min_lower_mark_range,
1028: MAX (gsg.upper_mark_range) max_upper_mark_range
1029: FROM igs_as_grd_sch_grade gsg

Line 1029: FROM igs_as_grd_sch_grade gsg

1025: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
1026: ) IS
1027: SELECT MIN (gsg.lower_mark_range) min_lower_mark_range,
1028: MAX (gsg.upper_mark_range) max_upper_mark_range
1029: FROM igs_as_grd_sch_grade gsg
1030: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
1031: AND gsg.version_number = cp_gs_version_number;
1032: rec_gsg_min_max c_gsg_min_max%ROWTYPE;
1033: --