1 PACKAGE JTF_IH_PARTY_MERGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: JTFIHPMS.pls 115.5 2002/11/08 16:48:20 rdday ship $ */
3 -- Start of Comments
4 -- Package name : JTF_IH_PARTY_MERGE_PKG
5 --
6 -- Purpose : Merges duplicate parties in JTF_IH_INTERACTIONS table.
7
8 -- History
9 -- MM-DD-YYYY NAME MODIFICATIONS
10 -- 01-04-2001 James Baldo Jr. Created.
11 --
12 -- End of Comments
13
14 -- *******************************************************
15 -- Start of Comments
16 -- *******************************************************
17 -- API Name: JTF_IH_MERGE_PARTY
18 -- Purpose : Merges parties in JTF_IH_INTERACTIONS table
19 -- Type : Public
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
40 PROCEDURE JTF_IH_MERGE_PARTY(
41 p_entity_name IN VARCHAR2,
42 p_from_id IN NUMBER,
43 x_to_id OUT NOCOPY NUMBER,
44 p_from_fk_id IN NUMBER,
45 p_to_fk_id IN NUMBER,
46 p_parent_entity_name IN VARCHAR2,
47 p_batch_id IN NUMBER,
48 p_batch_party_id IN NUMBER,
49 x_return_status OUT NOCOPY VARCHAR2);
50
51
52
53
54
55 END JTF_IH_PARTY_MERGE_PKG;