1 PACKAGE XDP_MERGE AS
2 /* $Header: XDPPMRGS.pls 120.1 2005/06/09 00:27:13 appldev $ */
3 --
4 -- Start of Comments
5 -- Package name : XDP_MERGE
6 -- Purpose : Merges duplicate parties in SFM tables. The
7 -- SFM tables that need to be considered for
8 -- Party Merge are:
9 -- XDP_ORDER_HEADERS
10 --
11 -- History
12 -- MM-DD-YYYY NAME MODIFICATIONS
13 -- 05-05-2003 spusegao Created.
14 --
15 -- End of comments
16
17 -- API Name: MERGE_CUSTOMER_ID
18 -- Purpose : Merges customer_id in XDP_ORDER_HEADERS table
19 -- Type : Private
20 -- Pre-Req : None.
21 -- Parameters:
22 -- IN - All IN parameters are REQUIRED.
23 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
24 -- p_from_id NUMBER - Id of the record that is being merged
25 -- p_from_fk_id NUMBER - Id of the Old Parent
26 -- p_to_fk_id NUMBER - Id of the New Parent
27 -- p_parent_entity_name VARCHAR2 - Parent entity name
28 -- p_batch_id NUMBER - Id of the Batch
29 -- p_batch_party_id NUMBER - Id of the batch and party record
30 -- OUT:
31 -- x_to_id NUMBER - Id of the record under the new parent
32 -- that its merged to
33 -- x_return_status VARCHAR2 - Return the status of the procedure
34 --
35 -- Version : Current version 1.0
36 --
37 -- End of Comments
38
39 PROCEDURE MERGE_CUSTOMER_ID(
40 p_entity_name IN VARCHAR2,
41 p_from_id IN NUMBER,
42 x_to_id OUT NOCOPY NUMBER,
43 p_from_fk_id IN NUMBER,
44 p_to_fk_id IN NUMBER,
45 p_parent_entity_name IN VARCHAR2,
46 p_batch_id IN NUMBER,
47 p_batch_party_id IN NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2);
49
50 END XDP_MERGE ;