APPS.PRP_PARTY_MERGE_PVT dependencies on PRP_PROPOSALS

Line 24: -- update PRP_PROPOSALS table and will be called from party merge

20: -- PUBLIC PROCEDURES
21: -- Merge_Proposals
22: -- When in ERP Parties are merged, the foriegn keys to party_id and other
23: -- columns should also be updated in Proposal tables. This procedure will
24: -- update PRP_PROPOSALS table and will be called from party merge
25: -- concurrent program.
26: --
27: -- DESCRIPTION
28: --

Line 58: -- Get all the rows from PRP_PROPOSALS that are to be merged and lock them

54: 'Merge_Proposals';
55: l_api_version CONSTANT NUMBER := 1.0;
56: l_count NUMBER(10) := 0;
57:
58: -- Get all the rows from PRP_PROPOSALS that are to be merged and lock them
59: CURSOR c1 IS SELECT 1 FROM prp_proposals
60: WHERE party_id = p_from_fk_id
61: OR contact_party_id = p_from_fk_id
62: FOR UPDATE NOWAIT;

Line 59: CURSOR c1 IS SELECT 1 FROM prp_proposals

55: l_api_version CONSTANT NUMBER := 1.0;
56: l_count NUMBER(10) := 0;
57:
58: -- Get all the rows from PRP_PROPOSALS that are to be merged and lock them
59: CURSOR c1 IS SELECT 1 FROM prp_proposals
60: WHERE party_id = p_from_fk_id
61: OR contact_party_id = p_from_fk_id
62: FOR UPDATE NOWAIT;
63:

Line 115: arp_message.set_token('TABLE_NAME', 'PRP_PROPOSALS', FALSE);

111: IF p_parent_entity_name = 'HZ_PARTIES' THEN
112:
113: -- Log message
114: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
115: arp_message.set_token('TABLE_NAME', 'PRP_PROPOSALS', FALSE);
116:
117: -- Lock table
118: OPEN C1;
119: CLOSE C1;

Line 123: arp_message.set_token('TABLE_NAME','PRP_PROPOSALS', FALSE);

119: CLOSE C1;
120:
121: -- Log message
122: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
123: arp_message.set_token('TABLE_NAME','PRP_PROPOSALS', FALSE);
124:
125: -- Update table
126: UPDATE prp_proposals SET
127: party_id = DECODE(party_id, p_from_fk_id, p_to_fk_id, party_id),

Line 126: UPDATE prp_proposals SET

122: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
123: arp_message.set_token('TABLE_NAME','PRP_PROPOSALS', FALSE);
124:
125: -- Update table
126: UPDATE prp_proposals SET
127: party_id = DECODE(party_id, p_from_fk_id, p_to_fk_id, party_id),
128: contact_party_id = DECODE(contact_party_id, p_from_fk_id, p_to_fk_id,
129: contact_party_id),
130: last_update_date = hz_utility_pub.last_update_date,