APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_USEC_GRD_SCHM_PKG

Line 5795: IF igs_ps_usec_grd_schm_pkg.get_uk_for_validation ( x_grading_schema_code => p_usec_gs_rec.grading_schema_code,

5791: PROCEDURE validate_db_cons ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type,p_insert_update VARCHAR2 ) AS
5792: BEGIN
5793: IF (p_insert_update = 'I') THEN
5794: /* Unique Key Validation */
5795: IF igs_ps_usec_grd_schm_pkg.get_uk_for_validation ( x_grading_schema_code => p_usec_gs_rec.grading_schema_code,
5796: x_grd_schm_version_number => p_usec_gs_rec.grd_schm_version_number,
5797: x_uoo_id => l_n_uoo_id ) THEN
5798: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_GRADING_SCHM', 'LEGACY_TOKENS', FALSE);
5799: p_usec_gs_rec.status := 'W';

Line 5806: igs_ps_usec_grd_schm_pkg.check_constraints ( 'DEFAULT_FLAG', p_usec_gs_rec.default_flag );

5802: END IF;
5803:
5804: /* Validate Check Constraints */
5805: BEGIN
5806: igs_ps_usec_grd_schm_pkg.check_constraints ( 'DEFAULT_FLAG', p_usec_gs_rec.default_flag );
5807: EXCEPTION
5808: WHEN OTHERS THEN
5809: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'DEFAULT_FLAG', 'LEGACY_TOKENS', TRUE);
5810: p_usec_gs_rec.status := 'E';