[Home] [Help]
PACKAGE: APPS.DPP_TRANSACTION_PVT
Source
1 PACKAGE DPP_TRANSACTION_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppvtxns.pls 120.8.12010000.3 2009/08/17 10:31:25 rvkondur ship $ */
3 TYPE txn_header_rec IS RECORD
4 (
5 TRANSACTION_HEADER_ID NUMBER,
6 TRANSACTION_INT_HEADER_ID NUMBER,
7 TRANSACTION_NUMBER VARCHAR2(40),
8 REF_DOCUMENT_NUMBER VARCHAR2(40),
9 CONTACT_EMAIL_ADDRESS VARCHAR2(2000),
10 CONTACT_PHONE VARCHAR2(40),
11 TRANSACTION_SOURCE VARCHAR2(40),
12 TRANSACTION_CREATION_DATE DATE,
13 EFFECTIVE_START_DATE DATE,
14 DAYS_COVERED NUMBER,
15 TRANSACTION_STATUS VARCHAR2(20),
16 ORG_ID VARCHAR2(150),
17 ORIG_SYS_DOCUMENT_REF VARCHAR2(40),
18 CREATION_DATE DATE,
19 CREATED_BY NUMBER,
20 LAST_UPDATE_DATE DATE,
21 LAST_UPDATED_BY NUMBER,
22 LAST_UPDATE_LOGIN NUMBER,
23 REQUEST_ID NUMBER,
24 PROGRAM_APPLICATION_ID NUMBER,
25 PROGRAM_ID NUMBER,
26 PROGRAM_UPDATE_DATE DATE,
27 ATTRIBUTE_CATEGORY VARCHAR2(30),
28 ATTRIBUTE1 VARCHAR2(150),
29 ATTRIBUTE2 VARCHAR2(150),
30 ATTRIBUTE3 VARCHAR2(150),
31 ATTRIBUTE4 VARCHAR2(150),
32 ATTRIBUTE5 VARCHAR2(150),
33 ATTRIBUTE6 VARCHAR2(150),
34 ATTRIBUTE7 VARCHAR2(150),
35 ATTRIBUTE8 VARCHAR2(150),
36 ATTRIBUTE9 VARCHAR2(150),
37 ATTRIBUTE10 VARCHAR2(150),
38 ATTRIBUTE11 VARCHAR2(150),
39 ATTRIBUTE12 VARCHAR2(150),
40 ATTRIBUTE13 VARCHAR2(150),
41 ATTRIBUTE14 VARCHAR2(150),
42 ATTRIBUTE15 VARCHAR2(150),
43 ATTRIBUTE16 VARCHAR2(150),
44 ATTRIBUTE17 VARCHAR2(150),
45 ATTRIBUTE18 VARCHAR2(150),
46 ATTRIBUTE19 VARCHAR2(150),
47 ATTRIBUTE20 VARCHAR2(150),
48 ATTRIBUTE21 VARCHAR2(150),
49 ATTRIBUTE22 VARCHAR2(150),
50 ATTRIBUTE23 VARCHAR2(150),
51 ATTRIBUTE24 VARCHAR2(150),
52 ATTRIBUTE25 VARCHAR2(150),
53 ATTRIBUTE26 VARCHAR2(150),
54 ATTRIBUTE27 VARCHAR2(150),
55 ATTRIBUTE28 VARCHAR2(150),
56 ATTRIBUTE29 VARCHAR2(150),
57 ATTRIBUTE30 VARCHAR2(150),
58 VENDOR_ID VARCHAR2(150),
59 VENDOR_CONTACT_ID VARCHAR2(150),
60 VENDOR_SITE_ID VARCHAR2(150),
61 LAST_REFRESHED_BY NUMBER,
62 TRX_CURRENCY VARCHAR2(30),
63 LAST_REFRESHED_DATE DATE,
64 OPERATING_UNIT_NAME VARCHAR2(150),
65 VENDOR_NAME VARCHAR2(150),
66 VENDOR_SITE_CODE VARCHAR2(150),
67 VENDOR_CONTACT_NAME VARCHAR2(50),
68 SUPPLIER_APPROVED_BY VARCHAR2(100),
69 SUPPLIER_APPROVAL_DATE DATE,
70 SUPP_DIST_CLAIM_ID VARCHAR2(150),
71 SUPP_DIST_CLAIM_NUMBER VARCHAR2(150),
72 INTERFACE_STATUS VARCHAR2(1),
73 ERROR_CODE VARCHAR2(30),
74 INVENTORY_ORGANIZATION_ID NUMBER,
75 FUNCTIONAL_CURRENCY VARCHAR2(150)
76 );
77
78 TYPE txn_lines_rec IS RECORD
79 (
80 TRANSACTION_HEADER_ID NUMBER,
81 TRANSACTION_LINE_ID NUMBER,
82 TRANSACTION_INT_LINE_ID NUMBER,
83 TRANSACTION_INT_HEADER_ID NUMBER,
84 SUPPLIER_PART_NUM VARCHAR2(240),
85 LINE_NUMBER NUMBER,
86 PRIOR_PRICE NUMBER,
87 CHANGE_TYPE VARCHAR2(30),
88 CHANGE_VALUE NUMBER,
89 PRICE_CHANGE NUMBER,
90 COVERED_INVENTORY NUMBER,
91 APPROVED_INVENTORY NUMBER,
92 UOM VARCHAR2(3),
93 ORG_ID VARCHAR2(150),
94 ORIG_SYS_DOCUMENT_LINE_REF VARCHAR2(40),
95 LINE_STATUS VARCHAR2(40),
96 CREATION_DATE DATE,
97 CREATED_BY NUMBER,
98 LAST_UPDATE_DATE DATE,
99 LAST_UPDATED_BY NUMBER,
100 LAST_UPDATE_LOGIN NUMBER,
101 REQUEST_ID NUMBER,
102 PROGRAM_APPLICATION_ID NUMBER,
103 PROGRAM_ID NUMBER,
104 PROGRAM_UPDATE_DATE DATE,
105 ATTRIBUTE_CATEGORY VARCHAR2(30),
106 ATTRIBUTE1 VARCHAR2(150),
107 ATTRIBUTE2 VARCHAR2(150),
108 ATTRIBUTE3 VARCHAR2(150),
109 ATTRIBUTE4 VARCHAR2(150),
110 ATTRIBUTE5 VARCHAR2(150),
111 ATTRIBUTE6 VARCHAR2(150),
112 ATTRIBUTE7 VARCHAR2(150),
113 ATTRIBUTE8 VARCHAR2(150),
114 ATTRIBUTE9 VARCHAR2(150),
115 ATTRIBUTE10 VARCHAR2(150),
116 ATTRIBUTE11 VARCHAR2(150),
117 ATTRIBUTE12 VARCHAR2(150),
118 ATTRIBUTE13 VARCHAR2(150),
119 ATTRIBUTE14 VARCHAR2(150),
120 ATTRIBUTE15 VARCHAR2(150),
121 ATTRIBUTE16 VARCHAR2(150),
122 ATTRIBUTE17 VARCHAR2(150),
123 ATTRIBUTE18 VARCHAR2(150),
124 ATTRIBUTE19 VARCHAR2(150),
125 ATTRIBUTE20 VARCHAR2(150),
126 ATTRIBUTE21 VARCHAR2(150),
127 ATTRIBUTE22 VARCHAR2(150),
128 ATTRIBUTE23 VARCHAR2(150),
129 ATTRIBUTE24 VARCHAR2(150),
130 ATTRIBUTE25 VARCHAR2(150),
131 ATTRIBUTE26 VARCHAR2(150),
132 ATTRIBUTE27 VARCHAR2(150),
133 ATTRIBUTE28 VARCHAR2(150),
134 ATTRIBUTE29 VARCHAR2(150),
135 ATTRIBUTE30 VARCHAR2(150),
136 INVENTORY_ITEM_ID VARCHAR2(150),
137 SUPPLIER_NEW_PRICE NUMBER,
138 LAST_CALCULATED_BY NUMBER,
139 LAST_CALCULATED_DATE DATE,
140 CLAIM_AMOUNT NUMBER,
141 SUPP_DIST_CLAIM_ID VARCHAR2(150),
142 UPDATE_PURCHASING_DOCS VARCHAR2(1),
143 NOTIFY_PURCHASING_DOCS VARCHAR2(1),
144 UPDATE_INVENTORY_COSTING VARCHAR2(1),
145 UPDATE_ITEM_LIST_PRICE VARCHAR2(1),
146 SUPP_DIST_CLAIM_STATUS VARCHAR2(1),
147 ONHAND_INVENTORY NUMBER,
148 MANUALLY_ADJUSTED VARCHAR2(1) ,
149 NOTIFY_INBOUND_PRICELIST VARCHAR2(1),
150 NOTIFY_OUTBOUND_PRICELIST VARCHAR2(1),
151 SUPPLIER_APPROVED_BY VARCHAR2(100),
152 SUPPLIER_APPROVAL_DATE DATE,
153 NOTIFY_PROMOTIONS_PRICELIST VARCHAR2(1),
154 ITEM_NUMBER VARCHAR2(240),
155 INTERFACE_STATUS VARCHAR2(1),
156 ERROR_CODE VARCHAR2(30),
157 LIST_PRICE NUMBER
158 );
159
160 TYPE txn_lines_tbl IS TABLE OF txn_lines_rec INDEX BY BINARY_INTEGER;
161
162 PROCEDURE create_transaction(
163 errbuf OUT NOCOPY VARCHAR2
164 , retcode OUT NOCOPY VARCHAR2
165 , p_operating_unit IN VARCHAR2 DEFAULT NULL
166 , p_supplier_name IN VARCHAR2
167 , p_supplier_site IN VARCHAR2 DEFAULT NULL
168 , p_document_reference_number IN VARCHAR2 DEFAULT NULL
169 );
170
171 ---------------------------------------------------------------------
172 -- PROCEDURE
173 -- Insert_Transaction
174 --
175 -- PURPOSE
176 -- It calls different procedure which validates and inserts
177 -- records in to dpp transaction header and lines table.
178 --
179 -- PARAMETERS
180 -- p_transaction_int_header_id
181 -- NOTES
182 -- 1.
183 -- 2.
184 ----------------------------------------------------------------------
185 PROCEDURE Insert_Transaction(
186 p_api_version IN NUMBER
187 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
188 , p_commit IN VARCHAR2 := FND_API.G_FALSE
189 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
190 , p_transaction_int_header_id IN NUMBER
191 , p_operating_unit IN VARCHAR2 DEFAULT NULL
192 , x_return_status OUT NOCOPY VARCHAR2
193 , x_msg_count OUT NOCOPY NUMBER
194 , x_msg_data OUT NOCOPY VARCHAR2
195 );
196
197
198 PROCEDURE Raise_OutBoundEvent(
199 p_api_version IN NUMBER
200 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
201 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
202 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
203 ,p_party_id IN VARCHAR2
204 ,p_party_site_id IN VARCHAR2
205 ,p_claim_id IN VARCHAR2
206 ,p_party_type IN VARCHAR2
207 ,x_return_status OUT NOCOPY VARCHAR2
208 ,x_msg_count OUT NOCOPY NUMBER
209 ,x_msg_data OUT NOCOPY VARCHAR2
210 );
211
212 PROCEDURE inbound_transaction(
213 p_distributor_operating_unit IN VARCHAR2,
214 p_document_reference IN VARCHAR2,
215 p_supplier_name IN VARCHAR2,
216 p_supplier_site IN VARCHAR2,
217 p_supplier_contact IN VARCHAR2,
218 p_supplier_contact_phone IN VARCHAR2,
219 p_supplier_contact_email IN VARCHAR2,
220 p_effective_date IN DATE,
221 p_days_covered IN NUMBER,
222 p_currency IN VARCHAR2,
223 p_hdrattributecontext IN VARCHAR2,
224 p_hdrattribute1 IN VARCHAR2,
225 p_hdrattribute2 IN VARCHAR2,
226 p_hdrattribute3 IN VARCHAR2,
227 p_hdrattribute4 IN VARCHAR2,
228 p_hdrattribute5 IN VARCHAR2,
229 p_hdrattribute6 IN VARCHAR2,
230 p_hdrattribute7 IN VARCHAR2,
231 p_hdrattribute8 IN VARCHAR2,
232 p_hdrattribute9 IN VARCHAR2,
233 p_hdrattribute10 IN VARCHAR2,
234 p_hdrattribute11 IN VARCHAR2,
235 p_hdrattribute12 IN VARCHAR2,
236 p_hdrattribute13 IN VARCHAR2,
237 p_hdrattribute14 IN VARCHAR2,
238 p_hdrattribute15 IN VARCHAR2,
239 p_hdrattribute16 IN VARCHAR2,
240 p_hdrattribute17 IN VARCHAR2,
241 p_hdrattribute18 IN VARCHAR2,
242 p_hdrattribute19 IN VARCHAR2,
243 p_hdrattribute20 IN VARCHAR2,
244 p_hdrattribute21 IN VARCHAR2,
245 p_hdrattribute22 IN VARCHAR2,
246 p_hdrattribute23 IN VARCHAR2,
247 p_hdrattribute24 IN VARCHAR2,
248 p_hdrattribute25 IN VARCHAR2,
249 p_hdrattribute26 IN VARCHAR2,
250 p_hdrattribute27 IN VARCHAR2,
251 p_hdrattribute28 IN VARCHAR2,
252 p_hdrattribute29 IN VARCHAR2,
253 p_hdrattribute30 IN VARCHAR2,
254 p_supplier_part_num IN VARCHAR2,
255 p_item_number IN VARCHAR2,
256 p_change_type IN VARCHAR2,
257 p_change_value IN NUMBER,
258 p_uom IN VARCHAR2,
259 p_dtlattributecontext IN VARCHAR2,
260 p_dtlattribute1 IN VARCHAR2,
261 p_dtlattribute2 IN VARCHAR2,
262 p_dtlattribute3 IN VARCHAR2,
263 p_dtlattribute4 IN VARCHAR2,
264 p_dtlattribute5 IN VARCHAR2,
265 p_dtlattribute6 IN VARCHAR2,
266 p_dtlattribute7 IN VARCHAR2,
267 p_dtlattribute8 IN VARCHAR2,
268 p_dtlattribute9 IN VARCHAR2,
269 p_dtlattribute10 IN VARCHAR2,
270 p_dtlattribute11 IN VARCHAR2,
271 p_dtlattribute12 IN VARCHAR2,
272 p_dtlattribute13 IN VARCHAR2,
273 p_dtlattribute14 IN VARCHAR2,
274 p_dtlattribute15 IN VARCHAR2,
275 p_dtlattribute16 IN VARCHAR2,
276 p_dtlattribute17 IN VARCHAR2,
277 p_dtlattribute18 IN VARCHAR2,
278 p_dtlattribute19 IN VARCHAR2,
279 p_dtlattribute20 IN VARCHAR2,
280 p_dtlattribute21 IN VARCHAR2,
281 p_dtlattribute22 IN VARCHAR2,
282 p_dtlattribute23 IN VARCHAR2,
283 p_dtlattribute24 IN VARCHAR2,
284 p_dtlattribute25 IN VARCHAR2,
285 p_dtlattribute26 IN VARCHAR2,
286 p_dtlattribute27 IN VARCHAR2,
287 p_dtlattribute28 IN VARCHAR2,
288 p_dtlattribute29 IN VARCHAR2,
289 p_dtlattribute30 IN VARCHAR2
290 );
291
292
293 PROCEDURE create_webadi_transaction(
294 p_document_reference_number IN VARCHAR2
295 , p_supplier_name IN VARCHAR2
296 , p_supplier_site IN VARCHAR2
297 , p_operating_unit IN VARCHAR2
298 , x_return_status OUT NOCOPY VARCHAR2
299 , x_msg_data OUT NOCOPY VARCHAR2
300 );
301
302 PROCEDURE inbound_approval(
303 p_distributor_operating_unit IN VARCHAR2,
304 p_document_reference IN VARCHAR2,
305 p_supplier_name IN VARCHAR2,
306 p_supplier_site IN VARCHAR2,
307 p_supplier_contact IN VARCHAR2,
308 p_supplier_contact_phone IN VARCHAR2,
309 p_supplier_contact_email IN VARCHAR2,
310 p_effective_date IN DATE,
311 p_days_covered IN NUMBER,
312 p_currency IN VARCHAR2,
313 p_supplier_approved_by IN VARCHAR2,
314 p_supplier_approval_date IN DATE,
315 p_supp_dist_claim_number IN VARCHAR2,
316 p_hdrattributecontext IN VARCHAR2,
317 p_hdrattribute1 IN VARCHAR2,
318 p_hdrattribute2 IN VARCHAR2,
319 p_hdrattribute3 IN VARCHAR2,
320 p_hdrattribute4 IN VARCHAR2,
321 p_hdrattribute5 IN VARCHAR2,
322 p_hdrattribute6 IN VARCHAR2,
323 p_hdrattribute7 IN VARCHAR2,
324 p_hdrattribute8 IN VARCHAR2,
325 p_hdrattribute9 IN VARCHAR2,
326 p_hdrattribute10 IN VARCHAR2,
327 p_hdrattribute11 IN VARCHAR2,
328 p_hdrattribute12 IN VARCHAR2,
329 p_hdrattribute13 IN VARCHAR2,
330 p_hdrattribute14 IN VARCHAR2,
331 p_hdrattribute15 IN VARCHAR2,
332 p_hdrattribute16 IN VARCHAR2,
333 p_hdrattribute17 IN VARCHAR2,
334 p_hdrattribute18 IN VARCHAR2,
335 p_hdrattribute19 IN VARCHAR2,
336 p_hdrattribute20 IN VARCHAR2,
337 p_hdrattribute21 IN VARCHAR2,
338 p_hdrattribute22 IN VARCHAR2,
339 p_hdrattribute23 IN VARCHAR2,
340 p_hdrattribute24 IN VARCHAR2,
341 p_hdrattribute25 IN VARCHAR2,
342 p_hdrattribute26 IN VARCHAR2,
343 p_hdrattribute27 IN VARCHAR2,
344 p_hdrattribute28 IN VARCHAR2,
345 p_hdrattribute29 IN VARCHAR2,
346 p_hdrattribute30 IN VARCHAR2,
347 p_supplier_part_num IN VARCHAR2,
348 p_item_number IN VARCHAR2,
349 p_change_type IN VARCHAR2,
350 p_change_value IN NUMBER,
351 p_uom IN VARCHAR2,
352 p_approved_inventory IN NUMBER,
353 p_dtlattributecontext IN VARCHAR2,
354 p_dtlattribute1 IN VARCHAR2,
355 p_dtlattribute2 IN VARCHAR2,
356 p_dtlattribute3 IN VARCHAR2,
357 p_dtlattribute4 IN VARCHAR2,
358 p_dtlattribute5 IN VARCHAR2,
359 p_dtlattribute6 IN VARCHAR2,
360 p_dtlattribute7 IN VARCHAR2,
361 p_dtlattribute8 IN VARCHAR2,
362 p_dtlattribute9 IN VARCHAR2,
363 p_dtlattribute10 IN VARCHAR2,
364 p_dtlattribute11 IN VARCHAR2,
365 p_dtlattribute12 IN VARCHAR2,
366 p_dtlattribute13 IN VARCHAR2,
367 p_dtlattribute14 IN VARCHAR2,
371 p_dtlattribute18 IN VARCHAR2,
368 p_dtlattribute15 IN VARCHAR2,
369 p_dtlattribute16 IN VARCHAR2,
370 p_dtlattribute17 IN VARCHAR2,
372 p_dtlattribute19 IN VARCHAR2,
373 p_dtlattribute20 IN VARCHAR2,
377 p_dtlattribute24 IN VARCHAR2,
374 p_dtlattribute21 IN VARCHAR2,
375 p_dtlattribute22 IN VARCHAR2,
376 p_dtlattribute23 IN VARCHAR2,
378 p_dtlattribute25 IN VARCHAR2,
379 p_dtlattribute26 IN VARCHAR2,
380 p_dtlattribute27 IN VARCHAR2,
381 p_dtlattribute28 IN VARCHAR2,
382 p_dtlattribute29 IN VARCHAR2,
383 p_dtlattribute30 IN VARCHAR2,
384 x_return_status OUT NOCOPY VARCHAR2
385 );
386
387 END DPP_TRANSACTION_PVT;