1 PACKAGE OZF_WEBADI_INTERFACE_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfadiws.pls 120.8.12020000.2 2013/02/21 06:00:31 sagpraka ship $ */
3 -- Start of Comments
4 -- Package name : ozf_webadi_interface_pvt
5 -- Purpose :
6 -- History : 09-OCT-2003 vansub Created
7 -- NOTE :
8 -- End of Comments
9
10 G_RESALE_LINE_INT_ID NUMBER := 0;
11 G_RESALE_BATCH_ID NUMBER := 0;
12 G_RESALE_BATCH_NUMBER NUMBER := 0;
13 G_COUNT NUMBER := 0;
14 G_LINE_COUNT NUMBER := 0;
15
16
17 PROCEDURE CODE_CONVERSION_WEBADI
18 (
19 P_PARTY_ID IN NUMBER,
20 P_CUST_ACCOUNT_ID IN NUMBER,
21 P_CODE_CONVERSION_TYPE IN VARCHAR2,
22 P_EXTERNAL_CODE IN VARCHAR2,
23 P_INTERNAL_CODE IN VARCHAR2,
24 P_DESCRIPTION IN VARCHAR2,
25 P_START_DATE_ACTIVE IN DATE,
26 P_END_DATE_ACTIVE IN DATE,
27 P_ORG_ID IN NUMBER,
28 P_INTERNAL_CODE_NAME IN VARCHAR2
29 );
30
31 PROCEDURE RESALE_WEBADI
32 (
33 P_BATCH_TYPE IN VARCHAR2,
34 P_BATCH_NUMBER IN VARCHAR2,
35 P_BATCH_COUNT IN NUMBER,
36 P_REPORT_DATE IN DATE,
37 P_REPORT_START_DATE IN DATE,
38 P_REPORT_END_DATE IN DATE,
39 P_DATA_SOURCE_CODE IN VARCHAR2,
40 P_REFERENCE_TYPE IN VARCHAR2,
41 P_REFERENCE_NUMBER IN VARCHAR2,
42 P_YEAR IN NUMBER,
43 P_MONTH IN NUMBER,
44 P_COMMENTS IN VARCHAR2,
45 P_PARTNER_CLAIM_NUMBER IN VARCHAR2,
46 P_TRANSACTION_PURPOSE IN VARCHAR2,
47 P_TRANSACTION_TYPE IN VARCHAR2,
48 P_PARTNER_TYPE IN VARCHAR2,
49 P_PARTNER_PARTY_ID IN NUMBER,
50 P_PARTNER_CUST_ACCOUNT_ID IN NUMBER,
51 P_PARTNER_SITE_ID IN NUMBER,
52 P_PARTNER_CONTACT_NAME IN VARCHAR2,
53 P_PARTNER_EMAIL IN VARCHAR2,
54 P_PARTNER_PHONE IN VARCHAR2,
55 P_PARTNER_FAX IN VARCHAR2,
56 P_CURRENCY IN VARCHAR2,
57 P_CLAIMED_AMOUNT IN NUMBER,
58 P_CREDIT_CODE IN VARCHAR2,
59 P_BATCH_CREDIT_ADVICE_DATE IN DATE,
60 P_RESALE_TRANSFER_TYPE IN VARCHAR2,
61 P_TRANSFER_MVMT_TYPE IN VARCHAR2,
62 P_TRANSFER_DATE IN DATE,
63 P_TRACING_FLAG IN VARCHAR2,
64 P_SHIP_FROM_PARTY_NAME IN VARCHAR2,
65 P_SHIP_FROM_ADDRESS IN VARCHAR2,
66 P_SHIP_FROM_LOCATION IN VARCHAR2,
67 P_SHIP_FROM_CITY IN VARCHAR2,
68 P_SHIP_FROM_STATE IN VARCHAR2,
69 P_SHIP_FROM_POSTAL_CODE IN VARCHAR2,
70 P_SHIP_FROM_COUNTRY IN VARCHAR2,
71 P_SHIP_FROM_CONTACT_NAME IN VARCHAR2,
72 P_SHIP_FROM_PHONE IN VARCHAR2,
73 P_SHIP_FROM_FAX IN VARCHAR2,
74 P_SHIP_FROM_EMAIL IN VARCHAR2,
75 P_SOLD_FROM_PARTY_NAME IN VARCHAR2,
76 P_SOLD_FROM_ADDRESS IN VARCHAR2,
77 P_SOLD_FROM_LOCATION IN VARCHAR2,
78 P_SOLD_FROM_CITY IN VARCHAR2,
79 P_SOLD_FROM_STATE IN VARCHAR2,
80 P_SOLD_FROM_POSTAL_CODE IN VARCHAR2,
81 P_SOLD_FROM_COUNTRY IN VARCHAR2,
82 P_SOLD_FROM_CONTACT_NAME IN VARCHAR2,
83 P_SOLD_FROM_PHONE IN VARCHAR2,
84 P_SOLD_FROM_FAX IN VARCHAR2,
85 P_SOLD_FROM_EMAIL IN VARCHAR2,
86 P_BILL_TO_PARTY_NAME IN VARCHAR2,
87 P_BILL_TO_DUNS_NUMBER IN VARCHAR2,
88 P_BILL_TO_ADDRESS IN VARCHAR2,
89 P_BILL_TO_LOCATION IN VARCHAR2,
90 P_BILL_TO_CITY IN VARCHAR2,
91 P_BILL_TO_STATE IN VARCHAR2,
92 P_BILL_TO_POSTAL_CODE IN VARCHAR2,
93 P_BILL_TO_COUNTRY IN VARCHAR2,
94 P_BILL_TO_CONTACT_NAME IN VARCHAR2,
95 P_BILL_TO_PHONE IN VARCHAR2,
96 P_BILL_TO_FAX IN VARCHAR2,
97 P_BILL_TO_EMAIL IN VARCHAR2,
98 P_SHIP_TO_PARTY_NAME IN VARCHAR2,
99 P_SHIP_TO_DUNS_NUMBER IN VARCHAR2,
100 P_SHIP_TO_ADDRESS IN VARCHAR2,
101 P_SHIP_TO_LOCATION IN VARCHAR2,
102 P_SHIP_TO_CITY IN VARCHAR2,
103 P_SHIP_TO_STATE IN VARCHAR2,
104 P_SHIP_TO_POSTAL_CODE IN VARCHAR2,
105 P_SHIP_TO_COUNTRY IN VARCHAR2,
106 P_SHIP_TO_CONTACT_NAME IN VARCHAR2,
107 P_SHIP_TO_PHONE IN VARCHAR2,
108 P_SHIP_TO_FAX IN VARCHAR2,
109 P_SHIP_TO_EMAIL IN VARCHAR2,
110 P_END_CUST_PARTY_NAME IN VARCHAR2,
111 P_END_CUST_DUNS_NUMBER IN VARCHAR2,
112 P_END_CUST_ADDRESS IN VARCHAR2,
113 P_END_CUST_LOCATION IN VARCHAR2,
114 P_END_CUST_SITE_USE_CODE IN VARCHAR2,
115 P_END_CUST_CITY IN VARCHAR2,
116 P_END_CUST_STATE IN VARCHAR2,
117 P_END_CUST_POSTAL_CODE IN VARCHAR2,
118 P_END_CUST_COUNTRY IN VARCHAR2,
119 P_END_CUST_CONTACT_NAME IN VARCHAR2,
120 P_END_CUST_PHONE IN VARCHAR2,
121 P_END_CUST_FAX IN VARCHAR2,
122 P_END_CUST_EMAIL IN VARCHAR2,
123 P_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
124 P_ORIG_SYSTEM_LINE_REFERENCE IN VARCHAR2,
125 P_ORIG_SYSTEM_CURRENCY_CODE IN VARCHAR2,
126 P_ORIG_SYSTEM_SELLING_PRICE IN NUMBER,
127 P_ORIG_SYSTEM_QUANTITY IN NUMBER,
128 P_ORIG_SYSTEM_UOM IN VARCHAR2,
129 P_ORIG_SYSTEM_PURCHASE_UOM IN VARCHAR2,
130 P_ORIG_SYSTEM_PURCHASE_CURR IN VARCHAR2,
131 P_ORIG_SYSTEM_PURCHASE_PRICE IN NUMBER,
132 P_ORIG_SYSTEM_PURCHASE_QUANT IN NUMBER,
133 P_ORIG_SYSTEM_AGREEMENT_UOM IN VARCHAR2,
134 P_ORIG_SYSTEM_AGREEMENT_NAME IN VARCHAR2,
135 P_ORIG_SYSTEM_AGREEMENT_TYPE IN VARCHAR2,
136 P_ORIG_SYSTEM_AGREEMENT_STATUS IN VARCHAR2,
137 P_ORIG_SYSTEM_AGREEMENT_CURR IN VARCHAR2,
138 P_ORIG_SYSTEM_AGREEMENT_PRICE IN NUMBER,
139 P_ORIG_SYSTEM_AGREEMENT_QUANT IN NUMBER,
140 P_ORIG_SYSTEM_ITEM_NUMBER IN VARCHAR2,
141 P_ORDER_TYPE IN VARCHAR2,
142 P_ORDER_CATEGORY IN VARCHAR2,
143 P_AGREEMENT_TYPE IN VARCHAR2,
144 P_AGREEMENT_NAME IN VARCHAR2,
145 P_AGREEMENT_PRICE IN NUMBER,
146 P_AGREEMENT_UOM IN VARCHAR2,
147 P_LINE_CURRENCY IN VARCHAR2,
148 P_EXCHANGE_RATE IN VARCHAR2,
149 P_EXCHANGE_RATE_TYPE IN VARCHAR2,
150 P_EXCHANGE_RATE_DATE IN DATE,
151 P_PO_NUMBER IN VARCHAR2,
152 P_PO_RELEASE_NUMBER IN VARCHAR2,
153 P_PO_TYPE IN VARCHAR2,
154 P_INVOICE_NUMBER IN VARCHAR2,
155 P_DATE_INVOICED IN DATE,
156 P_ORDER_NUMBER IN VARCHAR2,
157 P_DATE_ORDERED IN DATE,
158 P_DATE_SHIPPED IN DATE,
159 P_LINE_CLAIMED_AMOUNT IN NUMBER,
160 P_PURCHASE_PRICE IN NUMBER,
161 P_PURCHASE_UOM IN VARCHAR2,
162 P_SELLING_PRICE IN NUMBER,
163 P_UOM IN VARCHAR2,
164 P_QUANTITY IN NUMBER,
165 P_LINE_CREDIT_CODE IN VARCHAR2,
166 P_UPC_CODE IN VARCHAR2,
167 P_ITEM_DESCRIPTION IN VARCHAR2,
168 P_RESPONSE_TYPE IN VARCHAR2,
169 P_RESPONSE_CODE IN VARCHAR2,
170 P_FOLLOWUP_ACTION_CODE IN VARCHAR2,
171 P_REJECT_REASON_CODE IN VARCHAR2,
172 P_CREDIT_ADVICE_DATE IN VARCHAR2,
173 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
174 P_ATTRIBUTE1 IN VARCHAR2,
175 P_ATTRIBUTE2 IN VARCHAR2,
176 P_ATTRIBUTE3 IN VARCHAR2,
177 P_ATTRIBUTE4 IN VARCHAR2,
178 P_ATTRIBUTE5 IN VARCHAR2,
179 P_ATTRIBUTE6 IN VARCHAR2,
180 P_ATTRIBUTE7 IN VARCHAR2,
181 P_ATTRIBUTE8 IN VARCHAR2,
182 P_ATTRIBUTE9 IN VARCHAR2,
183 P_ATTRIBUTE10 IN VARCHAR2,
184 P_ATTRIBUTE11 IN VARCHAR2,
185 P_ATTRIBUTE12 IN VARCHAR2,
186 P_ATTRIBUTE13 IN VARCHAR2,
187 P_ATTRIBUTE14 IN VARCHAR2,
188 P_ATTRIBUTE15 IN VARCHAR2,
189 P_INVENTORY_ITEM_SEGMENT1 IN VARCHAR2,
190 P_INVENTORY_ITEM_SEGMENT2 IN VARCHAR2,
191 P_INVENTORY_ITEM_SEGMENT3 IN VARCHAR2,
192 P_INVENTORY_ITEM_SEGMENT4 IN VARCHAR2,
193 P_INVENTORY_ITEM_SEGMENT5 IN VARCHAR2,
194 P_INVENTORY_ITEM_SEGMENT6 IN VARCHAR2,
195 P_INVENTORY_ITEM_SEGMENT7 IN VARCHAR2,
196 P_INVENTORY_ITEM_SEGMENT8 IN VARCHAR2,
197 P_INVENTORY_ITEM_SEGMENT9 IN VARCHAR2,
198 P_INVENTORY_ITEM_SEGMENT10 IN VARCHAR2,
199 P_INVENTORY_ITEM_SEGMENT11 IN VARCHAR2,
200 P_INVENTORY_ITEM_SEGMENT12 IN VARCHAR2,
201 P_INVENTORY_ITEM_SEGMENT13 IN VARCHAR2,
202 P_INVENTORY_ITEM_SEGMENT14 IN VARCHAR2,
203 P_INVENTORY_ITEM_SEGMENT15 IN VARCHAR2,
204 P_INVENTORY_ITEM_SEGMENT16 IN VARCHAR2,
205 P_INVENTORY_ITEM_SEGMENT17 IN VARCHAR2,
206 P_INVENTORY_ITEM_SEGMENT18 IN VARCHAR2,
207 P_INVENTORY_ITEM_SEGMENT19 IN VARCHAR2,
208 P_INVENTORY_ITEM_SEGMENT20 IN VARCHAR2,
209 P_HEADER_ATTRIBUTE_CATEGORY IN VARCHAR2,
210 P_HEADER_ATTRIBUTE1 IN VARCHAR2,
211 P_HEADER_ATTRIBUTE2 IN VARCHAR2,
212 P_HEADER_ATTRIBUTE3 IN VARCHAR2,
213 P_HEADER_ATTRIBUTE4 IN VARCHAR2,
214 P_HEADER_ATTRIBUTE5 IN VARCHAR2,
215 P_HEADER_ATTRIBUTE6 IN VARCHAR2,
216 P_HEADER_ATTRIBUTE7 IN VARCHAR2,
217 P_HEADER_ATTRIBUTE8 IN VARCHAR2,
218 P_HEADER_ATTRIBUTE9 IN VARCHAR2,
219 P_HEADER_ATTRIBUTE10 IN VARCHAR2,
220 P_HEADER_ATTRIBUTE11 IN VARCHAR2,
221 P_HEADER_ATTRIBUTE12 IN VARCHAR2,
222 P_HEADER_ATTRIBUTE13 IN VARCHAR2,
223 P_HEADER_ATTRIBUTE14 IN VARCHAR2,
224 P_HEADER_ATTRIBUTE15 IN VARCHAR2,
225 P_LINE_ATTRIBUTE_CATEGORY IN VARCHAR2,
226 P_LINE_ATTRIBUTE1 IN VARCHAR2,
227 P_LINE_ATTRIBUTE2 IN VARCHAR2,
228 P_LINE_ATTRIBUTE3 IN VARCHAR2,
229 P_LINE_ATTRIBUTE4 IN VARCHAR2,
230 P_LINE_ATTRIBUTE5 IN VARCHAR2,
231 P_LINE_ATTRIBUTE6 IN VARCHAR2,
232 P_LINE_ATTRIBUTE7 IN VARCHAR2,
233 P_LINE_ATTRIBUTE8 IN VARCHAR2,
234 P_LINE_ATTRIBUTE9 IN VARCHAR2,
235 P_LINE_ATTRIBUTE10 IN VARCHAR2,
236 P_LINE_ATTRIBUTE11 IN VARCHAR2,
237 P_LINE_ATTRIBUTE12 IN VARCHAR2,
238 P_LINE_ATTRIBUTE13 IN VARCHAR2,
239 P_LINE_ATTRIBUTE14 IN VARCHAR2,
240 P_LINE_ATTRIBUTE15 IN VARCHAR2,
241 P_RESALE_LINE_INT_ID IN NUMBER,
242 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
243 P_BILL_TO_PARTY IN VARCHAR2,
244 P_BILL_TO_PARTY_SITE IN VARCHAR2,
245 P_SHIP_TO_PARTY IN VARCHAR2,
246 P_SHIP_TO_PARTY_SITE IN VARCHAR2,
247 P_ORIG_BILL_TO_PARTY IN VARCHAR2,
248 P_ORIG_BILL_TO_PARTY_SITE IN VARCHAR2,
249 P_ORIG_SHIP_TO_PARTY IN VARCHAR2,
250 P_ORIG_SHIP_TO_PARTY_SITE IN VARCHAR2,
251 P_ORIG_END_CUST_PARTY IN VARCHAR2,
252 P_ORIG_END_CUST_PARTY_SITE IN VARCHAR2,
253 P_ORG_ID IN VARCHAR2,
254 P_LINE_STATUS IN VARCHAR2,
255 P_DISPUTE_CODE IN VARCHAR2,
256
257 -- For Bug#9447673 SSD IDSM ER(+)
258 P_INVOICE_LINE_NUMBER IN VARCHAR2,
259 P_ORDER_LINE_NUMBER IN VARCHAR2,
260 P_SUPPLIER_ITEM_COST IN NUMBER,
261 P_SUPPLIER_ITEM_UOM IN VARCHAR2
262 -- For Bug#9447673 SSD IDSM ER(-)
263 );
264
265
266 procedure insert_resale_int_line (
267 p_api_version_number IN NUMBER,
268 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
270 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
271 p_int_line_tbl IN ozf_pre_process_pvt.resale_line_int_tbl_type,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2
275 );
276
277 PROCEDURE Update_Resale_Int_Line (
278 p_api_version_number IN NUMBER,
279 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
281 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282 p_int_line_tbl IN ozf_pre_process_pvt.resale_line_int_tbl_type,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2
286 );
287
288 PROCEDURE Update_Resale_Batch (
289 p_api_version_number IN NUMBER,
290 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
292 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293 p_int_batch_rec IN ozf_resale_batches_all%rowtype,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2
297 );
298
299 END OZF_WEBADI_INTERFACE_PVT;