APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_USEC_GRD_SCHM

Line 5730: FROM igs_ps_usec_grd_schm

5726: -- Check for Update
5727: FUNCTION check_insert_update ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) RETURN VARCHAR2 IS
5728: CURSOR c_usec_gs(p_grading_schema_code IN VARCHAR2,p_grd_schm_version_number NUMBER ,p_n_uoo_id NUMBER) IS
5729: SELECT 'X'
5730: FROM igs_ps_usec_grd_schm
5731: WHERE grading_schema_code =p_grading_schema_code
5732: AND grd_schm_version_number = p_grd_schm_version_number
5733: AND uoo_id = p_n_uoo_id;
5734:

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';

Line 5947: INSERT INTO igs_ps_usec_grd_schm

5943:
5944: IF p_tab_usec_gs(I).status = 'S' THEN
5945: IF l_insert_update = 'I' THEN
5946: /* Insert Record */
5947: INSERT INTO igs_ps_usec_grd_schm
5948: (unit_section_grading_schema_id,
5949: uoo_id,
5950: grading_schema_code,
5951: grd_schm_version_number,

Line 5960: (igs_ps_usec_grd_schm_s.NEXTVAL,

5956: last_update_date,
5957: last_update_login
5958: )
5959: VALUES
5960: (igs_ps_usec_grd_schm_s.NEXTVAL,
5961: l_n_uoo_id,
5962: p_tab_usec_gs(I).grading_schema_code,
5963: p_tab_usec_gs(I).grd_schm_version_number,
5964: p_tab_usec_gs(I).default_flag,

Line 5983: UPDATE igs_ps_usec_grd_schm

5979:
5980:
5981: ELSE
5982: /*Update record*/
5983: UPDATE igs_ps_usec_grd_schm
5984: SET default_flag = p_tab_usec_gs(I).default_flag,
5985: last_updated_by = g_n_user_id,
5986: last_update_date = SYSDATE,
5987: last_update_login = g_n_login_id