1 PACKAGE FTE_PARTY_MERGE AUTHID CURRENT_USER as
2 /* $Header: FTEPAMRS.pls 115.0 2003/07/21 19:38:35 arguha noship $ */
3
4 G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'FTE_PARTY_MERGE';
5
6 --***************************************************************************--
7
8 --========================================================================
9 -- PROCEDURE : merge_facility_contacts Called by HZ Party merge routine
10 -- Should not be called by any other application
11 --
12 -- PARAMETERS: p_entity_name HZ entity name being merged
13 -- p_from_id Input Facility Id to change
14 -- p_to_id Changed Facility Id
15 -- p_from_fk_id Party id before merge
16 -- p_to_fk_id Party id after merge
17 -- p_parent_entity_name
18 -- p_batch_id
19 -- p_batch_party_id
20 -- x_return_status Return status
21 -- COMMENT : This procedure is used to perform for following actions
22 -- When the relationship party merges
23 -- the corresponding facility_contact_id needs to be merged
24 --========================================================================
25
26 PROCEDURE merge_facility_contacts(
27 p_entity_name IN VARCHAR2,
28 p_from_id IN NUMBER,
29 p_to_id IN OUT NOCOPY NUMBER,
30 p_from_fk_id IN NUMBER,
31 p_to_fk_id IN NUMBER,
32 p_parent_entity_name IN VARCHAR2,
33 p_batch_id IN NUMBER,
34 p_batch_party_id IN NUMBER,
35 x_return_status IN OUT NOCOPY VARCHAR2);
36
37 END FTE_PARTY_MERGE;