1 PACKAGE WSH_VENDOR_PARTY_MERGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHVMRGS.pls 120.11 2011/05/10 06:09:11 shtadepa ship $ */
3
4 --========================================================================
5 -- PROCEDURE :Vendor_Merge
6 -- PARAMETERS:
7 -- P_from_id Merge from vendor ID
8 -- P_to_id Merge to vendor ID
9 -- P_from_party_id Merge from party ID
10 -- P_to_party_id Merge to party ID
11 -- P_from_site_id Merge from vendor site ID
12 -- P_to_site_id Merge to vendor site ID
13 -- p_Calling_mode Mode to indicate what data to update
14 -- Possible values :
15 -- - 'INVOICE' and 'PO'
16 -- X_return_status Return status
17 --
18 -- COMMENT :
19 -- This is the core WSH merge routine and will be called from the
20 -- Vendor_Party_Merge() API.
21 --
22 -- This procedure can be divided into two portions, merge validation and merge.
23 -- In the first portion, it will determine if the vendor merge is allowed.
24 -- In the second portion, it will update all the affected tables if merge is allowed
25 --
26 -- Parameter p_calling_mode indicates what updates to perform.
27 -- 'INVOICE' ==> Update only non-PO entities
28 -- 'PO' ==> Update PO related entities
29
30 --========================================================================
31
32 PROCEDURE Vendor_Merge (
33 p_from_id IN NUMBER,
34 p_to_id IN NUMBER,
35 p_from_party_id IN NUMBER,
36 p_to_party_id IN NUMBER,
37 p_from_site_id IN NUMBER,
38 p_to_site_id IN NUMBER,
39 p_calling_mode IN VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2 );
41
42
43
44 --========================================================================
45 -- PROCEDURE :Vendor_Party_Merge
46 -- PARAMETERS:
47 -- P_from_vendor_id Merge from vendor ID
48 -- P_to_vendor_id Merge to vendor ID
49 -- P_from_party_id Merge from party ID
50 -- P_to_party_id Merge to party ID
51 -- P_from_vendor_site_id Merge from vendor site ID
52 -- P_to_vendor_site_id Merge to vendor site ID
53 -- P_from_party_site_id Merge from party site ID
54 -- P_to_party_site_id Merge to party site ID
55 -- p_calling_mode Mode in which AP calls us
56 -- 'INVOICE' or 'PO'
57 -- X_return_status Return status
58 --
59 -- COMMENTS
60 -- This is the API that is called by APXINUPD.rdf. This in turn
61 -- will call the core Vendor_Merge() procedure to
62 -- perform all the necessary updates to WSH data.
63 --
64 -- HISTORY
65 -- rlanka 7/27/2005 Created
66 -- rlanka 8/09/2005 Added new parameter p_calling_mode
67 -- to track the phase in which
68 -- APXINUPD.rdf calls us.
69 --
70 --========================================================================
71
72 PROCEDURE Vendor_Party_Merge
73 (
74 p_from_vendor_id IN NUMBER,
75 p_to_vendor_id IN NUMBER,
76 p_from_party_id IN NUMBER,
77 p_to_party_id IN NUMBER,
78 p_from_vendor_site_id IN NUMBER,
79 p_to_vendor_site_id IN NUMBER,
80 p_from_party_site_id IN NUMBER,
81 p_to_partysite_id IN NUMBER,
82 p_calling_mode IN VARCHAR2 DEFAULT 'INVOICE',
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88
89
90
91 --========================================================================
92 -- PROCEDURE : Create_Site
93 -- PARAMETERS:
94 -- P_from_id Merge from party ID
95 -- P_to_id Merge to party ID
96 -- P_to_vendor_id Merge to vendor ID
97 -- P_delivery_id Delivery ID
98 -- P_delivery_name Delivery Name
99 -- P_location_id SF Location ID
100 -- X_return_status Return status
101 --
102 -- COMMENT : This is a procedure to create a new party site.
103 -- It also creates a corresponding party site use record and
104 -- calls Process_Locations() to update information in WSH
105 -- location tables.
106 --========================================================================
107 PROCEDURE Create_Site(
108 p_from_id IN NUMBER,
109 p_to_id IN NUMBER,
110 p_to_vendor_id IN NUMBER,
111 p_delivery_id IN NUMBER,
112 p_delivery_name IN VARCHAR2,
113 p_location_id IN NUMBER,
114 x_return_status OUT NOCOPY VARCHAR2
115 );
116
117
118 --========================================================================
119 -- PROCEDURE : Merge_RTV_Transactions
120 -- PARAMETERS:
121 -- P_from_vendor_id Merge from Vendor Id
122 -- P_to_vendor_id Merge to Vendor Id
123 -- P_from_site_id Merge from vendor site ID
124 -- P_to_site_id Merge to vendor site ID
125 -- X_return_status Return status
126 --
127 -- COMMENT : This is the procedure to merge the shipping RTV transactions.
128 -- This will be called from Vendor_Merge() API
129 --========================================================================
130
131
132 PROCEDURE Merge_RTV_Transactions
133 ( p_from_vendor_id IN NUMBER,
134 p_to_vendor_id IN NUMBER,
135 p_from_site_id IN NUMBER,
136 p_to_site_id IN NUMBER,
137 x_return_status OUT NOCOPY VARCHAR2 );
138
139
140 END WSH_VENDOR_PARTY_MERGE_PKG;