eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PRP_PARTY_MERGE_PVT dependencies on PRP_EMAIL_RECIPIENTS

Line 173: -- update PRP_EMAIL_RECIPIENTS table and will be called from party merge

169: -- PUBLIC PROCEDURES
170: -- Merge_Email_Recipients
171: -- When in ERP Parties are merged, the foriegn keys to party_id and other
172: -- columns should also be updated in Proposal tables. This procedure will
173: -- update PRP_EMAIL_RECIPIENTS table and will be called from party merge
174: -- concurrent program.
175: --
176: -- DESCRIPTION
177: --

Line 207: -- Get all the rows from PRP_EMAIL_RECIPIENTS that are to be merged

203: 'Merge_Email_Recipients';
204: l_api_version CONSTANT NUMBER := 1.0;
205: l_count NUMBER(10) := 0;
206:
207: -- Get all the rows from PRP_EMAIL_RECIPIENTS that are to be merged
208: -- and lock them
209: CURSOR c1 IS SELECT 1 FROM prp_email_recipients
210: WHERE party_id = p_from_fk_id
211: FOR UPDATE NOWAIT;

Line 209: CURSOR c1 IS SELECT 1 FROM prp_email_recipients

205: l_count NUMBER(10) := 0;
206:
207: -- Get all the rows from PRP_EMAIL_RECIPIENTS that are to be merged
208: -- and lock them
209: CURSOR c1 IS SELECT 1 FROM prp_email_recipients
210: WHERE party_id = p_from_fk_id
211: FOR UPDATE NOWAIT;
212:
213: BEGIN

Line 264: arp_message.set_token('TABLE_NAME', 'PRP_EMAIL_RECIPIENTS', FALSE);

260: IF p_parent_entity_name = 'HZ_PARTIES' THEN
261:
262: -- Log message
263: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
264: arp_message.set_token('TABLE_NAME', 'PRP_EMAIL_RECIPIENTS', FALSE);
265:
266: -- Lock table
267: OPEN C1;
268: CLOSE C1;

Line 272: arp_message.set_token('TABLE_NAME','PRP_EMAIL_RECIPIENTS', FALSE);

268: CLOSE C1;
269:
270: -- Log message
271: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
272: arp_message.set_token('TABLE_NAME','PRP_EMAIL_RECIPIENTS', FALSE);
273:
274: -- Update table
275: UPDATE prp_email_recipients SET
276: party_id = p_to_fk_id,

Line 275: UPDATE prp_email_recipients SET

271: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
272: arp_message.set_token('TABLE_NAME','PRP_EMAIL_RECIPIENTS', FALSE);
273:
274: -- Update table
275: UPDATE prp_email_recipients SET
276: party_id = p_to_fk_id,
277: last_update_date = hz_utility_pub.last_update_date,
278: last_updated_by = hz_utility_pub.user_id,
279: last_update_login = hz_utility_pub.last_update_login,