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:
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:
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: