1 PACKAGE INL_TCAMERGE_GRP AUTHID CURRENT_USER AS
2 /* $Header: INLGMRGS.pls 120.2 2011/01/18 16:54:20 acferrei noship $ */
3 G_MODULE_NAME CONSTANT VARCHAR2(200) := 'INL.PLSQL.INL_TCAMERGE_GRP.';
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INL_TCAMERGE_GRP';
5
6 --========================================================================
7 -- PROCEDURE :Merge_VendorParties
8 -- PARAMETERS:
9 -- p_from_vendor_id Merge from vendor ID
10 -- p_to_vendor_id Merge to vendor ID
11 -- p_from_party_id Merge from party ID
12 -- p_to_party_id Merge to party ID
13 -- p_from_vendor_site_id Merge from vendor site ID
14 -- p_to_vendor_site_id Merge to vendor site ID
15 -- p_from_party_site_id Merge from party site ID
16 -- p_to_party_site_id Merge to party site ID
17 -- p_calling_mode Mode in which AP calls us
18 -- 'INVOICE' or 'PO'
19 -- x_return_status Return status
20 -- x_msg_count Return count message
21 -- x_msg_data Return message data
22 --
23 -- COMMENTS
24 -- This is the API that is called by APXINUPD.rdf. This in turn
25 -- will call the core Merge_Vendors() procedure to
26 -- perform all the necessary updates to LCM data.
27 --
28 --========================================================================
29
30 PROCEDURE Merge_VendorParties
31 (
32 p_from_vendor_id IN NUMBER,
33 p_to_vendor_id IN NUMBER,
34 p_from_party_id IN NUMBER,
35 p_to_party_id IN NUMBER,
36 p_from_vendor_site_id IN NUMBER,
37 p_to_vendor_site_id IN NUMBER,
38 p_from_party_site_id IN NUMBER,
39 p_to_party_site_id IN NUMBER,
40 p_calling_mode IN VARCHAR2 DEFAULT 'INVOICE',
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2
44 );
45
46 --========================================================================
47 -- PROCEDURE :Merge_Parties
48 -- PARAMETERS:
49 -- p_entity_name Name of Entity Being Merged
50 -- p_from_id Primary Key Id of the entity that is being merged
51 -- p_to_id The record under the 'To Parent' that is being merged
52 -- p_from_fk_id Foreign Key id of the Old Parent Record
53 -- p_to_fk_id Foreign Key id of the New Parent Record
54 -- p_parent_entity_name Name of Parent Entity
55 -- p_batch_id Id of the Batch
56 -- p_batch_party_id Id uniquely identifies the batch and party record that is being merged
57 -- x_return_status Returns the status of call
58 --
59 -- COMMENT :
60 --
61 --========================================================================
62
63 PROCEDURE Merge_Parties
64 (
65 p_entity_name IN VARCHAR2,
66 p_from_id IN NUMBER,
67 p_to_id IN OUT NOCOPY NUMBER,
68 p_from_fk_id IN NUMBER,
69 p_to_fk_id IN NUMBER,
70 p_parent_entity_name IN VARCHAR2,
71 p_batch_id IN NUMBER,
72 p_batch_party_id IN NUMBER,
73 x_return_status IN OUT NOCOPY VARCHAR2
74 );
75
76 --========================================================================
77 -- PROCEDURE :Merge_PartySites
78 -- PARAMETERS:
79 -- p_entity_name Name of Entity Being Merged
80 -- p_from_id Primary Key Id of the entity that is being merged
81 -- p_to_id The record under the 'To Parent' that is being merged
82 -- p_from_fk_id Foreign Key id of the Old Parent Record
83 -- p_to_fk_id Foreign Key id of the New Parent Record
84 -- p_parent_entity_name Name of Parent Entity
85 -- p_batch_id Id of the Batch
86 -- p_batch_party_id Id uniquely identifies the batch and party record that is being merged
87 -- x_return_status Returns the status of call
88 --
89 -- COMMENT :
90 --
91 --========================================================================
92
93 PROCEDURE Merge_PartySites
94 (
95 p_entity_name IN VARCHAR2,
96 p_from_id IN NUMBER,
97 p_to_id IN OUT NOCOPY NUMBER,
98 p_from_fk_id IN NUMBER,
99 p_to_fk_id IN NUMBER,
100 p_parent_entity_name IN VARCHAR2,
101 p_batch_id IN NUMBER,
102 p_batch_party_id IN NUMBER,
103 x_return_status IN OUT NOCOPY VARCHAR2
104 );
105
106
107 END INL_TCAMERGE_GRP;