APPS.IGS_UC_QUAL_DETS_IMP_PKG dependencies on IGS_AS_GRD_SCH_GRADE

Line 395: AND NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (

391:
392: IF cur_qual_dets_val.grading_schema_cd IS NOT NULL
393: AND cur_qual_dets_val.version_number IS NOT NULL
394: AND j.ebl_result IS NOT NULL
395: AND NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (
396: UPPER(TRIM(c_grad_sch_rec.grading_schema_cd)),
397: c_grad_sch_rec.gs_version_number,
398: UPPER(TRIM(j.claimed_result)) ) THEN
399:

Line 473: AND NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (

469: -- Check whether the Grading Scema and Grade Combination exist in the Parent Table
470: IF c_grad_sch_rec.grading_schema_cd IS NOT NULL
471: AND c_grad_sch_rec.gs_version_number IS NOT NULL
472: AND j.ebl_result IS NOT NULL
473: AND NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (
474: UPPER(TRIM(c_grad_sch_rec.grading_schema_cd)),
475: c_grad_sch_rec.gs_version_number,
476: UPPER(TRIM(j.ebl_result)) ) THEN
477:

Line 488: AND NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (

484:
485: ELSIF c_grad_sch_rec.grading_schema_cd IS NOT NULL
486: AND c_grad_sch_rec.gs_version_number IS NOT NULL
487: AND j.claimed_result IS NOT NULL
488: AND NOT igs_as_grd_sch_grade_pkg.get_pk_for_validation (
489: UPPER(TRIM(c_grad_sch_rec.grading_schema_cd)),
490: c_grad_sch_rec.gs_version_number,
491: UPPER(TRIM(j.claimed_result)) ) THEN
492:

Line 677: CURSOR cur_grd_sch (cp_grd_sch igs_as_grd_sch_grade.grading_schema_cd%TYPE,

673: -- else import the grading schema details.
674: -- However, when user has not provided any grading schema details then
675: -- the grading schema derived from the Exam level is to be used for all
676: -- validations.
677: CURSOR cur_grd_sch (cp_grd_sch igs_as_grd_sch_grade.grading_schema_cd%TYPE,
678: cp_grd_ver igs_as_grd_sch_grade.version_number%TYPE,
679: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
680: SELECT 'X'
681: FROM igs_as_grd_sch_grade gsch,

Line 678: cp_grd_ver igs_as_grd_sch_grade.version_number%TYPE,

674: -- However, when user has not provided any grading schema details then
675: -- the grading schema derived from the Exam level is to be used for all
676: -- validations.
677: CURSOR cur_grd_sch (cp_grd_sch igs_as_grd_sch_grade.grading_schema_cd%TYPE,
678: cp_grd_ver igs_as_grd_sch_grade.version_number%TYPE,
679: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
680: SELECT 'X'
681: FROM igs_as_grd_sch_grade gsch,
682: igs_as_grd_schema ags

Line 679: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS

675: -- the grading schema derived from the Exam level is to be used for all
676: -- validations.
677: CURSOR cur_grd_sch (cp_grd_sch igs_as_grd_sch_grade.grading_schema_cd%TYPE,
678: cp_grd_ver igs_as_grd_sch_grade.version_number%TYPE,
679: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
680: SELECT 'X'
681: FROM igs_as_grd_sch_grade gsch,
682: igs_as_grd_schema ags
683: WHERE gsch.grading_schema_cd = ags.grading_schema_cd

Line 681: FROM igs_as_grd_sch_grade gsch,

677: CURSOR cur_grd_sch (cp_grd_sch igs_as_grd_sch_grade.grading_schema_cd%TYPE,
678: cp_grd_ver igs_as_grd_sch_grade.version_number%TYPE,
679: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
680: SELECT 'X'
681: FROM igs_as_grd_sch_grade gsch,
682: igs_as_grd_schema ags
683: WHERE gsch.grading_schema_cd = ags.grading_schema_cd
684: AND gsch.version_number = ags.version_number
685: AND gsch.grading_schema_cd = cp_grd_sch

Line 692: l_grading_schema igs_as_grd_sch_grade.grading_schema_cd%TYPE;

688: AND gsch.grade = NVL(cp_grade, gsch.grade);
689:
690: l_grd_sch_rec cur_grd_sch%ROWTYPE;
691: lv_found VARCHAR2(1) := 'N';
692: l_grading_schema igs_as_grd_sch_grade.grading_schema_cd%TYPE;
693: l_version_number igs_as_grd_sch_grade.version_number%TYPE;
694:
695: BEGIN
696:

Line 693: l_version_number igs_as_grd_sch_grade.version_number%TYPE;

689:
690: l_grd_sch_rec cur_grd_sch%ROWTYPE;
691: lv_found VARCHAR2(1) := 'N';
692: l_grading_schema igs_as_grd_sch_grade.grading_schema_cd%TYPE;
693: l_version_number igs_as_grd_sch_grade.version_number%TYPE;
694:
695: BEGIN
696:
697: -- Exam Level/Qualification Validation