APPS.IGS_PS_RSV_UOP_PRF_PKG dependencies on HZ_PARTIES

Line 106: SELECT 'x' FROM hz_parties hp,igs_pe_hz_parties pe

102: END check_uniqueness;
103:
104: PROCEDURE check_parent_existance AS
105: CURSOR c_check_hz_exists IS
106: SELECT 'x' FROM hz_parties hp,igs_pe_hz_parties pe
107: WHERE hp.party_id = pe.party_id
108: AND pe.oss_org_unit_cd = new_references.preference_code;
109: cur_rec_hz_exists c_check_hz_exists%ROWTYPE;
110: /*

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

113: || Purpose : Checks for the existance of Parent records.
114: || Known limitations, enhancements or remarks :
115: || Change History :
116: || Who When What
117: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
118: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
119: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
120: || (reverse chronological order - newest change first)
121: */

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

114: || Known limitations, enhancements or remarks :
115: || Change History :
116: || Who When What
117: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
118: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
119: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
120: || (reverse chronological order - newest change first)
121: */
122: CURSOR c_priority is

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

115: || Change History :
116: || Who When What
117: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
118: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
119: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
120: || (reverse chronological order - newest change first)
121: */
122: CURSOR c_priority is
123: Select priority_value

Line 415: PROCEDURE get_fk_hz_parties (

411: CLOSE cur_rowid;
412:
413: END get_fk_igs_en_unit_set_all;
414:
415: PROCEDURE get_fk_hz_parties (
416: x_preference_code IN VARCHAR2
417: ) AS
418: /*
419: || Created By : apelleti

Line 440: fnd_message.set_name ('IGS', 'IGS_PS_RUPF_HZ_PARTIES_FK');

436: OPEN cur_rowid;
437: FETCH cur_rowid INTO lv_rowid;
438: IF (cur_rowid%FOUND) THEN
439: CLOSE cur_rowid;
440: fnd_message.set_name ('IGS', 'IGS_PS_RUPF_HZ_PARTIES_FK');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: RETURN;
444: END IF;

Line 447: END get_fk_hz_parties;

443: RETURN;
444: END IF;
445: CLOSE cur_rowid;
446:
447: END get_fk_hz_parties;
448:
449: PROCEDURE BeforeInsertUpdate(p_inserting BOOLEAN , p_updating BOOLEAN) AS
450: p_message_name VARCHAR2(30);
451: BEGIN