APPS.IGS_PS_RSV_OGPRI_PKG dependencies on HZ_PARTIES

Line 108: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in

104: || Purpose : Checks for the existance of Parent records.
105: || Known limitations, enhancements or remarks :
106: || Change History :
107: || Who When What
108: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
109: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
110: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
111: || (reverse chronological order - newest change first)
112: */

Line 109: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES

105: || Known limitations, enhancements or remarks :
106: || Change History :
107: || Who When What
108: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
109: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
110: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
111: || (reverse chronological order - newest change first)
112: */
113: CURSOR c_check_hz_exists

Line 110: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.

106: || Change History :
107: || Who When What
108: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
109: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
110: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
111: || (reverse chronological order - newest change first)
112: */
113: CURSOR c_check_hz_exists
114: is

Line 118: hz_parties hp,igs_pe_hz_parties pe

114: is
115: SELECT
116: 'x'
117: FROM
118: hz_parties hp,igs_pe_hz_parties pe
119: WHERE
120: hp.party_id = pe.party_id
121: AND pe.oss_org_unit_cd =new_references.org_unit_cd;
122: cur_rec_hz_exists c_check_hz_exists%ROWTYPE;

Line 236: PROCEDURE get_ufk_hz_parties (

232:
233: END get_uk_for_validation ;
234:
235:
236: PROCEDURE get_ufk_hz_parties (
237: x_party_number IN VARCHAR2
238: ) AS
239: /*
240: || Created By : apelleti

Line 261: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_HZ_PARTIES_FK');

257: OPEN cur_rowid;
258: FETCH cur_rowid INTO lv_rowid;
259: IF (cur_rowid%FOUND) THEN
260: CLOSE cur_rowid;
261: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_HZ_PARTIES_FK');
262: igs_ge_msg_stack.add;
263: app_exception.raise_exception;
264: RETURN;
265: END IF;

Line 268: END get_ufk_hz_parties;

264: RETURN;
265: END IF;
266: CLOSE cur_rowid;
267:
268: END get_ufk_hz_parties;
269:
270:
271: PROCEDURE before_dml (
272: p_action IN VARCHAR2,