APPS.IGS_EN_ELGB_OVR_UOO_PKG dependencies on IGS_PS_UNIT_VER

Line 120: FROM igs_ps_unit_ver uv ,igs_ps_unit_ofr_opt uoo,igs_ps_usec_cps cps

116: ******************************************************************/
117:
118: CURSOR cur_unit_ver(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)IS
119: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)
120: FROM igs_ps_unit_ver uv ,igs_ps_unit_ofr_opt uoo,igs_ps_usec_cps cps
121: WHERE uoo.uoo_id = cps.uoo_id(+) AND
122: uoo.unit_cd = uv.unit_cd AND
123: uoo.version_number = uv.version_number AND
124: uoo.uoo_id = cp_uoo_id;

Line 238: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;

234: --dummy variable to pick up audit, billing, enrolled credit points
235: --due to signature change by EN308 Billing credit hours #3782329
236: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
237: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
238: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
239:
240: BEGIN
241:
242: --

Line 1009: ELSIF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (

1005: (old_references.version_number = new_references.version_number)) OR
1006: ((new_references.unit_cd IS NULL) OR
1007: (new_references.version_number IS NULL))) THEN
1008: NULL;
1009: ELSIF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (
1010: new_references.unit_cd,
1011: new_references.version_number
1012: ) THEN
1013: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line 1093: PROCEDURE get_fk_igs_ps_unit_ver (

1089:
1090: END get_ufk_igs_ps_unit_ofr_opt;
1091:
1092:
1093: PROCEDURE get_fk_igs_ps_unit_ver (
1094: x_unit_cd IN VARCHAR2,
1095: x_version_number IN NUMBER
1096: ) AS
1097: /*

Line 1128: END get_fk_igs_ps_unit_ver;

1124: RETURN;
1125: END IF;
1126: CLOSE cur_rowid;
1127:
1128: END get_fk_igs_ps_unit_ver;
1129:
1130:
1131: FUNCTION get_pk_for_validation (
1132: x_elgb_ovr_step_uoo_id IN NUMBER