DBA Data[Home] [Help]

APPS.IGS_UC_QUAL_DETS_IMP_PKG dependencies on IGS_AS_GRD_SCH_GRADE_PKG

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: