APPS.IGS_PS_RSV_ORGUN_PRF_PKG dependencies on HZ_PARTIES

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

115:
116:
117: PROCEDURE check_parent_existance AS
118: CURSOR c_check_hz_exists IS
119: SELECT 'x' FROM hz_parties hp,igs_pe_hz_parties pe
120: WHERE hp.party_id = pe.party_id
121: AND pe.oss_org_unit_cd = new_references.preference_code;
122: cur_rec_hz_exists c_check_hz_exists%ROWTYPE;
123:

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

133: || Purpose : Checks for the existance of Parent records.
134: || Known limitations, enhancements or remarks :
135: || Change History :
136: || Who When What
137: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
138: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
139: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
140: || (reverse chronological order - newest change first)
141: */

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

134: || Known limitations, enhancements or remarks :
135: || Change History :
136: || Who When What
137: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
138: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
139: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
140: || (reverse chronological order - newest change first)
141: */
142: BEGIN

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

135: || Change History :
136: || Who When What
137: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
138: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
139: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
140: || (reverse chronological order - newest change first)
141: */
142: BEGIN
143:

Line 429: PROCEDURE get_fk_hz_parties (

425: CLOSE cur_rowid;
426:
427: END get_fk_igs_en_unit_set_all;
428:
429: PROCEDURE get_fk_hz_parties (
430: x_preference_code IN VARCHAR2
431: ) AS
432: /*
433: || Created By : apelleti

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

450: OPEN cur_rowid;
451: FETCH cur_rowid INTO lv_rowid;
452: IF (cur_rowid%FOUND) THEN
453: CLOSE cur_rowid;
454: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_HZ_PARTIES_FK');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: RETURN;
458: END IF;

Line 461: END get_fk_hz_parties;

457: RETURN;
458: END IF;
459: CLOSE cur_rowid;
460:
461: END get_fk_hz_parties;
462:
463:
464:
465: PROCEDURE before_dml (