APPS.IGS_PS_RSV_USEC_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 123: || sommukhe 12-AUG-2005 Bug#4377818,changed the c_check_hz_exists, included table igs_pe_hz_parties in

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

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

120: || Known limitations, enhancements or remarks :
121: || Change History :
122: || Who When What
123: || sommukhe 12-AUG-2005 Bug#4377818,changed the c_check_hz_exists, included table igs_pe_hz_parties in
124: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
125: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
126: || (reverse chronological order - newest change first)
127: */
128: BEGIN

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

121: || Change History :
122: || Who When What
123: || sommukhe 12-AUG-2005 Bug#4377818,changed the c_check_hz_exists, included table igs_pe_hz_parties in
124: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
125: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
126: || (reverse chronological order - newest change first)
127: */
128: BEGIN
129:

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_USPF_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_USPF_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