APPS.IGS_PS_RSV_USEC_PRF_PKG dependencies on IGS_PS_RSV_USEC_PRI

Line 113: from IGS_PS_RSV_USEC_PRI PRI

109: cur_rec_hz_exists c_check_hz_exists%ROWTYPE;
110:
111: CURSOR c_priority is
112: Select priority_value
113: from IGS_PS_RSV_USEC_PRI PRI
114: Where PRI.RSV_USEC_PRI_ID = new_references.rsv_usec_pri_id;
115: priority_value1 VARCHAR2(30);
116: /*
117: || Created By : apelleti

Line 133: ELSIF NOT igs_ps_rsv_usec_pri_pkg.get_pk_for_validation (

129:
130: IF (((old_references.rsv_usec_pri_id = new_references.rsv_usec_pri_id)) OR
131: ((new_references.rsv_usec_pri_id IS NULL))) THEN
132: NULL;
133: ELSIF NOT igs_ps_rsv_usec_pri_pkg.get_pk_for_validation (
134: new_references.rsv_usec_pri_id
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;

Line 277: PROCEDURE get_fk_igs_ps_rsv_usec_pri (

273:
274: END get_uk_for_validation ;
275:
276:
277: PROCEDURE get_fk_igs_ps_rsv_usec_pri (
278: x_rsv_usec_pri_id IN NUMBER
279: ) AS
280: /*
281: || Created By : apelleti

Line 309: END get_fk_igs_ps_rsv_usec_pri;

305: RETURN;
306: END IF;
307: CLOSE cur_rowid;
308:
309: END get_fk_igs_ps_rsv_usec_pri;
310:
311: PROCEDURE get_fk_igs_ps_ver_all (
312: x_preference_code IN VARCHAR2,
313: x_preference_version IN NUMBER