APPS.IGS_PS_RSV_UOP_PRF_PKG dependencies on IGS_PS_RSV_UOP_PRI

Line 124: from IGS_PS_RSV_UOP_PRI PRI

120: || (reverse chronological order - newest change first)
121: */
122: CURSOR c_priority is
123: Select priority_value
124: from IGS_PS_RSV_UOP_PRI PRI
125: Where PRI.RSV_UOP_PRI_ID = new_references.rsv_uop_pri_id;
126: priority_value1 VARCHAR2(30);
127: BEGIN
128:

Line 132: ELSIF NOT igs_ps_rsv_uop_pri_pkg.get_pk_for_validation (

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

Line 277: PROCEDURE get_fk_igs_ps_rsv_uop_pri (

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

Line 309: END get_fk_igs_ps_rsv_uop_pri;

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