APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_GRD_SCHM

Line 2134: IF igs_ps_unit_grd_schm_pkg.get_uk_for_validation (

2130: PROCEDURE validate_db_cons ( p_grd_sch_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type ) AS
2131: BEGIN
2132:
2133: /* Unique Key Validation */
2134: IF igs_ps_unit_grd_schm_pkg.get_uk_for_validation (
2135: x_unit_version_number => p_grd_sch_rec.version_number,
2136: x_grading_schema_code => p_grd_sch_rec.grading_schema_code,
2137: x_grd_schm_version_number => p_grd_sch_rec.grd_schm_version_number,
2138: x_unit_code => p_grd_sch_rec.unit_cd ) THEN

Line 2146: igs_ps_unit_grd_schm_pkg.check_constraints ( 'DEFAULT_FLAG', p_grd_sch_rec.default_flag );

2142: END IF;
2143:
2144: /* Validate Check Constraints */
2145: BEGIN
2146: igs_ps_unit_grd_schm_pkg.check_constraints ( 'DEFAULT_FLAG', p_grd_sch_rec.default_flag );
2147: EXCEPTION
2148: WHEN OTHERS THEN
2149: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'DEFAULT_FLAG', 'LEGACY_TOKENS', TRUE);
2150: p_grd_sch_rec.status := 'E';

Line 2215: INSERT INTO igs_ps_unit_grd_schm

2211: END IF;
2212:
2213: IF p_tab_grd_sch(I).status = 'S' THEN
2214: /* Insert Record */
2215: INSERT INTO igs_ps_unit_grd_schm
2216: (unit_grading_schema_id,
2217: unit_code,
2218: unit_version_number,
2219: grading_schema_code,

Line 2229: (igs_ps_unit_grd_schm_s.NEXTVAL,

2225: last_update_date,
2226: last_update_login
2227: )
2228: VALUES
2229: (igs_ps_unit_grd_schm_s.NEXTVAL,
2230: p_tab_grd_sch(I).unit_cd,
2231: p_tab_grd_sch(I).version_number,
2232: p_tab_grd_sch(I).grading_schema_code,
2233: p_tab_grd_sch(I).grd_schm_version_number,

Line 3322: FROM igs_ps_unit_grd_schm

3318:
3319: CURSOR c_grd_sch ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
3320: cp_version_number igs_ps_unit_ver_all.version_number%TYPE )IS
3321: SELECT grading_schema_code, grd_schm_version_number
3322: FROM igs_ps_unit_grd_schm
3323: WHERE unit_code = cp_unit_cd
3324: AND unit_version_number = cp_version_number
3325: AND default_flag = 'Y';
3326: