[Home] [Help]
PACKAGE: APPS.OE_ACKNOWLEDGMENT_PUB
Source
1 PACKAGE OE_Acknowledgment_Pub AS
2 /* $Header: OEXPACKS.pls 120.3 2007/12/10 06:55:37 sahvivek ship $ */
3
4 -- Start of Comments
5 -- API name OE_Acknowledgment_Pub
6 -- Type Public
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 G_XML_ORDER_SOURCE_ID NUMBER := 20;
21 G_TRANSACTION_TYPE VARCHAR2(3) := 'ONT';
22 G_TRANSACTION_POI VARCHAR2(6) := 'POI';
23 G_TRANSACTION_POA VARCHAR2(6) := 'POA';
24 G_TRANSACTION_SSO VARCHAR2(6) := 'SSO';
25 G_TRANSACTION_CPO VARCHAR2(6) := 'CPO';
26 G_TRANSACTION_CHO VARCHAR2(6) := 'CHO';
27 G_TRANSACTION_CSO VARCHAR2(6) := 'CSO';
28 G_TRANSACTION_CBODO VARCHAR2(6) := 'CBODO';
29 G_TRANSACTION_850 VARCHAR2(6) := '850';
30 G_TRANSACTION_860 VARCHAR2(6) := '860';
31 G_TRANSACTION_855 VARCHAR2(6) := '855';
32 G_TRANSACTION_865 VARCHAR2(6) := '865';
33 G_TRANSACTION_GENERIC VARCHAR2(8) := 'GENERIC';
34 G_ACK_CODE_XMLACK VARCHAR2(6) := 'XMLACK';
35 G_ACK_CODE_XMLSSO VARCHAR2(6) := 'XMLSSO';
36 G_TRANSACTION_SEBL VARCHAR2(9) := 'SEBL_SYNC'; -- GENESIS
37
38 PROCEDURE Process_Acknowledgment
39 (p_api_version_number IN NUMBER
40 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41
42 ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43 OE_Order_Pub.G_MISS_HEADER_REC
44 ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45 OE_Order_Pub.G_MISS_HEADER_VAL_REC
46 ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47 OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48 ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49 OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50 ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51 OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52 ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53 OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54 ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55 OE_Order_Pub.G_MISS_LINE_TBL
56 ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57 OE_Order_Pub.G_MISS_LINE_VAL_TBL
58 ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59 OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60 ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61 OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62 ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63 OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64 ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65 OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66 ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67 OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68 ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69 OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70 ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71 OE_Order_Pub.G_MISS_REQUEST_TBL
72
73 ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74 OE_Order_Pub.G_MISS_HEADER_REC
75 ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76 OE_Order_Pub.G_MISS_HEADER_VAL_REC
77 ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78 OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79 ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80 OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81 ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82 OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83 ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84 OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85 ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86 OE_Order_Pub.G_MISS_LINE_TBL
87 ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88 OE_Order_Pub.G_MISS_LINE_VAL_TBL
89 ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90 OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91 ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92 OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93 ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94 OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95 ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96 OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97 ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98 OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99 ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100 OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
101
102 ,p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'
103 ,p_reject_order IN VARCHAR2 DEFAULT 'N'
104
105 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 );
107
108 PROCEDURE Query_Inf_Records
109 ( p_order_source_id IN Number := 20,
110 p_orig_sys_document_ref IN Varchar2,
111 p_sold_to_org_id IN Number := NULL,
112 p_change_sequence IN Varchar2 := NULL,
113 p_msg_id IN Number := NULL,
114 p_request_id IN Number := Null,
115 p_xml_transaction_type_code IN Varchar2 := NULL,
116 x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
117 x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
118 x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
119 x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type
120 );
121
122 PROCEDURE Process_Xml_Acknowledgment
123 ( p_api_version_number IN NUMBER := 1,
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125 p_order_source_id IN NUMBER := G_XML_ORDER_SOURCE_ID,
126 p_orig_sys_document_ref IN VARCHAR2,
127 p_sold_to_org_id IN NUMBER := NULL,
128 p_change_sequence IN VARCHAR2 := NULL,
129 p_header_id IN NUMBER := NULL,
130 p_line_id IN NUMBER := NULL,
131 p_msg_id IN NUMBER := NULL,
132 p_request_id IN NUMBER := NULL,
133 p_itemtype IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_ACK,
134 p_start_from_flow IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
135 p_transaction_type IN VARCHAR2 := NULL,
136 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
137 );
138
139 PROCEDURE Process_SSO
140 ( p_api_version_number IN NUMBER := 1,
141 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142 p_header_rec IN OE_Order_Pub.Header_Rec_Type,
143 p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
144 p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
145 p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
146 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147 );
148
149 Procedure Raise_Event_Showso
150 ( p_header_id In Number,
151 p_line_id In Number,
152 p_customer_id In Number,
153 p_orig_sys_document_ref In Varchar2,
154 p_change_sequence In Varchar2 := Null,
155 p_itemtype In Varchar2,
156 p_itemkey In Number := Null,
157 p_party_id In Number := Null,
158 p_party_site_id In Number := Null,
159 p_transaction_type In Varchar2 := Null,
160 p_request_id In Number := NULL,
161 p_commit_flag In Varchar2 := 'Y',
162 p_org_id In Number Default Null,
163 x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
164 );
165
166 Procedure Is_Delivery_Required
167 ( p_customer_id In Number,
168 p_transaction_type In Varchar2,
169 p_transaction_subtype In Varchar2,
170 p_org_id In Number Default Null,
171 x_party_id Out NOCOPY /* file.sql.39 change */ Number,
172 x_party_site_id Out NOCOPY /* file.sql.39 change */ Number,
173 x_is_delivery_required Out NOCOPY /* file.sql.39 change */ Varchar2,
174 x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
175 );
176
177 Function Get_Orig_Sys_Document_Ref
178
179 (p_header_id In Number := Null,
180 p_line_id In Number := Null
181 ) Return Varchar2;
182
183 Function Get_Header_Id
184 (p_orig_sys_document_ref In Varchar2 := Null,
185 p_line_id In Number := Null,
186 p_sold_to_org_id In Number := Null
187 ) Return Number;
188
189 PROCEDURE Process_SSO_CONC_PGM
190 ( errbuf OUT NOCOPY /* file.sql.39 change */ VARCHAR,
191 retcode OUT NOCOPY /* file.sql.39 change */ NUMBER,
192 p_operating_unit IN NUMBER,
193 p_customer_id IN NUMBER,
194 p_open_orders_only IN VARCHAR2,
195 p_closed_for_days IN NUMBER,
196 p_so_number_from IN NUMBER,
197 p_so_number_to IN NUMBER,
198 p_so_date_from IN VARCHAR2,
199 p_so_date_to IN VARCHAR2,
200 p_customer_po_no_from IN VARCHAR2,
201 p_customer_po_no_to IN VARCHAR2
202 );
203
204 Procedure Raise_Event_From_Oeoi
205 ( p_transaction_type In Varchar2,
206 p_orig_sys_document_ref In Varchar2,
207 p_request_id In Number,
208 p_order_imported In Varchar2,
209 p_sold_to_org_id In Number := Null,
210 p_change_sequence In Varchar2 := Null,
211 p_org_id In Number := Null,
212 p_xml_message_id In Number := Null,
213 p_start_from_flow In Varchar2 := Null,
214 p_check_for_delivery In Varchar2 := 'Y',
215 x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
216 );
217
218
219 Procedure Raise_Event_Xmlint
220 (p_order_source_id IN Number DEFAULT NULL,
221 p_partner_document_num IN Varchar2,
222 p_message_text IN Varchar2,
223 p_document_num IN Number,
224 p_order_type_id IN Number DEFAULT NULL,
225 p_change_sequence IN Varchar2 DEFAULT NULL,
226 p_itemtype IN Varchar2,
227 p_itemkey IN Number,
228 p_transaction_type IN Varchar2,
229 p_transaction_subtype IN Varchar2 DEFAULT NULL,
230 p_doc_status IN Varchar2 DEFAULT NULL,
231 p_org_id IN Number DEFAULT NULL,
232 p_sold_to_org_id IN Number DEFAULT NULL,
233 p_document_direction IN Varchar2 DEFAULT NULL,
234 p_xmlg_document_id IN Number DEFAULT NULL,
235 p_xmlg_partner_type IN Varchar2 DEFAULT NULL,
236 p_xmlg_party_id IN Number DEFAULT NULL,
237 p_xmlg_party_site_id IN Number DEFAULT NULL,
238 p_xmlg_icn IN Number DEFAULT NULL,
239 p_xmlg_msgid IN Varchar2 DEFAULT NULL,
240 p_document_disposition IN Varchar2 DEFAULT NULL,
241 p_conc_request_id IN Number DEFAULT NULL,
242 p_processing_stage IN Varchar2 DEFAULT NULL,
243 p_response_flag IN Varchar2 DEFAULT NULL,
244 p_header_id IN Number DEFAULT NULL,
245 p_subscriber_list IN Varchar2 DEFAULT NULL,
246 p_line_ids IN Varchar2 DEFAULT NULL,
247 p_failure_ack_flag IN Varchar2 DEFAULT NULL,
248 x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2
249 );
250
251 Procedure Apply_3A7_Hold
252 ( p_header_id IN NUMBER
253 , p_line_id IN NUMBER
254 , p_sold_to_org_id IN NUMBER
255 , p_tp_check IN VARCHAR2 DEFAULT NULL
256 , x_return_status OUT NOCOPY VARCHAR2
257 );
258
259 Procedure Release_3A7_Hold
260 ( p_header_id IN NUMBER
261 , p_line_id IN NUMBER
262 , x_return_status OUT NOCOPY VARCHAR2
263 );
267 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
264
265 Procedure Process_3A8
266 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
268 , x_return_status OUT NOCOPY VARCHAR2
269 );
270
271 Function EM_Transaction_Type
272 ( p_txn_code IN Varchar2
273 ) RETURN VARCHAR2;
274
275 Procedure Raise_CBOD_Out_Event
276 ( p_orig_sys_document_ref IN Varchar2,
277 p_sold_to_org_id IN Number,
278 p_change_sequence IN Varchar2,
279 p_icn IN Number,
280 p_org_id IN Number,
281 p_transaction_type IN Varchar2,
282 p_confirmation_flag IN Varchar2,
283 p_cbod_message_text IN Varchar2,
284 x_return_status OUT NOCOPY VARCHAR2);
285 -- GENESIS --
286 TYPE header_ack_rec_type IS RECORD
287 (
288 IB_OWNER_CODE VARCHAR2(30),
289 IB_CURRENT_LOCATION_CODE VARCHAR2(30),
290 IB_INSTALLED_AT_LOCATION_CODE VARCHAR2(30),
291 INVOICE_CUSTOMER_ID NUMBER(22),
292 DELIVER_TO_CUSTOMER_ID NUMBER(22),
293 ACCOUNTING_RULE_DURATION NUMBER(22),
294 ATTRIBUTE16 VARCHAR2(240),
295 ATTRIBUTE17 VARCHAR2(240),
296 ATTRIBUTE18 VARCHAR2(240),
297 ATTRIBUTE19 VARCHAR2(240),
298 ATTRIBUTE20 VARCHAR2(240),
299 ACKNOWLEDGMENT_TYPE VARCHAR2(30),
300 BLANKET_NUMBER NUMBER(22),
301 BOOKED_DATE DATE,
302 FLOW_STATUS_CODE VARCHAR2(30),
303 CREDIT_CARD_APPROVAL_DATE DATE,
304 PAYMENT_TYPE_CODE VARCHAR2(30),
305 PAYMENT_AMOUNT NUMBER(22),
306 CHECK_NUMBER VARCHAR2(50),
307 CREDIT_CARD_CODE VARCHAR2(80),
308 CREDIT_CARD_HOLDER_NAME VARCHAR2(80),
309 CREDIT_CARD_NUMBER VARCHAR2(80),
310 CREDIT_CARD_EXPIRATION_DATE DATE,
311 CREDIT_CARD_APPROVAL_CODE VARCHAR2(80),
312 CUSTOMER_PREFERENCE_SET_CODE VARCHAR2(30),
313 SALES_CHANNEL_CODE VARCHAR2(30),
314 SOLD_TO_PHONE_ID NUMBER(22),
315 SHIP_TO_PROVINCE VARCHAR2(240),
316 SHIP_TO_SITE_INT VARCHAR2(30),
317 SHIP_TO_STATE VARCHAR2(240),
318 SHIP_TOLERANCE_ABOVE NUMBER(22),
319 SHIP_TOLERANCE_BELOW NUMBER(22),
320 SHIPMENT_PRIORITY VARCHAR2(80),
321 SHIPMENT_PRIORITY_CODE VARCHAR2(30),
322 SHIPMENT_PRIORITY_CODE_INT VARCHAR2(30),
323 SHIPPING_INSTRUCTIONS VARCHAR2(2000),
324 SHIPPING_METHOD VARCHAR2(80),
325 SHIPPING_METHOD_CODE VARCHAR2(30),
326 SOLD_TO_CONTACT VARCHAR2(330),
327 SOLD_TO_CONTACT_ID NUMBER(22),
328 SOURCE_DOCUMENT_ID NUMBER(22),
329 SOURCE_DOCUMENT_TYPE_ID NUMBER(22),
330 SUBMISSION_DATETIME DATE,
331 TAX_EXEMPT_FLAG VARCHAR2(30),
332 TAX_EXEMPT_NUMBER VARCHAR2(80),
333 TAX_EXEMPT_REASON VARCHAR2(80),
334 TAX_EXEMPT_REASON_CODE VARCHAR2(30),
335 TAX_POINT VARCHAR2(80),
336 TAX_POINT_CODE VARCHAR2(30),
337 TRANSACTIONAL_CURR VARCHAR2(80),
338 TRANSACTIONAL_CURR_CODE VARCHAR2(15),
339 VERSION_NUMBER NUMBER(22),
340 CUSTOMER_PAYMENT_TERM_ID NUMBER(22),
341 DROP_SHIP_FLAG VARCHAR2(1),
342 ORDER_CATEGORY_CODE VARCHAR2(30),
343 SOLD_TO_ADDRESS1 VARCHAR2(240),
344 SOLD_TO_ADDRESS2 VARCHAR2(240),
345 SOLD_TO_ADDRESS3 VARCHAR2(240),
346 SOLD_TO_ADDRESS4 VARCHAR2(240),
347 SOLD_TO_CITY VARCHAR2(240),
348 SOLD_TO_POSTAL_CODE VARCHAR2(240),
349 SOLD_TO_COUNTRY VARCHAR2(240),
350 SOLD_TO_STATE VARCHAR2(240),
351 SOLD_TO_COUNTY VARCHAR2(240),
352 SOLD_TO_PROVINCE VARCHAR2(240),
353 SOLD_TO_CONTACT_LAST_NAME VARCHAR2(240),
354 SOLD_TO_CONTACT_FIRST_NAME VARCHAR2(240),
355 SHIP_TO_EDI_LOCATION_CODE VARCHAR2(40),
356 SOLD_TO_EDI_LOCATION_CODE VARCHAR2(40),
357 BILL_TO_EDI_LOCATION_CODE VARCHAR2(40),
358 CUSTOMER_PAYMENT_TERM VARCHAR2(30),
359 SHIP_FROM_ADDRESS_1 VARCHAR2(240),
360 SHIP_FROM_ADDRESS_2 VARCHAR2(240),
361 SHIP_FROM_ADDRESS_3 VARCHAR2(240),
362 SHIP_FROM_CITY VARCHAR2(60),
363 SHIP_FROM_POSTAL_CODE VARCHAR2(60),
364 SHIP_FROM_COUNTRY VARCHAR2(60),
368 SHIP_FROM_REGION3 VARCHAR2(240),
365 SHIP_FROM_EDI_LOCATION_CODE VARCHAR2(40),
366 SHIP_FROM_REGION1 VARCHAR2(240),
367 SHIP_FROM_REGION2 VARCHAR2(240),
369 SHIP_FROM_ADDRESS_ID NUMBER(22),
370 SOLD_TO_ADDRESS_ID NUMBER(22),
371 SHIP_TO_ADDRESS_ID NUMBER(22),
372 INVOICE_ADDRESS_ID NUMBER(22),
373 SHIP_TO_ADDRESS_CODE VARCHAR2(240),
374 TP_CONTEXT VARCHAR2(30),
375 TP_ATTRIBUTE1 VARCHAR2(240),
376 TP_ATTRIBUTE2 VARCHAR2(240),
377 TP_ATTRIBUTE3 VARCHAR2(240),
378 TP_ATTRIBUTE4 VARCHAR2(240),
379 TP_ATTRIBUTE5 VARCHAR2(240),
380 TP_ATTRIBUTE6 VARCHAR2(240),
381 TP_ATTRIBUTE7 VARCHAR2(240),
382 TP_ATTRIBUTE8 VARCHAR2(240),
383 TP_ATTRIBUTE9 VARCHAR2(240),
384 TP_ATTRIBUTE10 VARCHAR2(240),
385 TP_ATTRIBUTE11 VARCHAR2(240),
386 TP_ATTRIBUTE12 VARCHAR2(240),
387 TP_ATTRIBUTE13 VARCHAR2(240),
388 TP_ATTRIBUTE14 VARCHAR2(240),
389 TP_ATTRIBUTE15 VARCHAR2(240),
390 XML_MESSAGE_ID NUMBER(22),
391 SHIP_TO_CUSTOMER_ID NUMBER(22),
392 ORDER_FIRMED_DATE DATE,
393 DELIVER_TO_ADDRESS1 VARCHAR2(240),
394 DELIVER_TO_ADDRESS2 VARCHAR2(240),
395 DELIVER_TO_ADDRESS3 VARCHAR2(240),
396 DELIVER_TO_ADDRESS4 VARCHAR2(240),
397 DELIVER_TO_CITY VARCHAR2(60),
398 DELIVER_TO_COUNTRY VARCHAR2(60),
399 DELIVER_TO_COUNTY VARCHAR2(60),
400 DELIVER_TO_POSTAL_CODE VARCHAR2(60),
401 DELIVER_TO_PROVINCE VARCHAR2(60),
402 TRANSACTION_PHASE_CODE VARCHAR2(30),
403 SALES_DOCUMENT_NAME VARCHAR2(240),
404 QUOTE_NUMBER NUMBER(22),
405 QUOTE_DATE DATE,
406 USER_STATUS_CODE VARCHAR2(30),
407 SOLD_TO_SITE_USE_ID NUMBER(22),
408 SUPPLIER_SIGNATURE VARCHAR2(240),
409 SUPPLIER_SIGNATURE_DATE DATE,
410 CUSTOMER_SIGNATURE VARCHAR2(240),
411 CUSTOMER_SIGNATURE_DATE DATE,
412 SOLD_TO_PARTY_NUMBER VARCHAR2(30),
413 SHIP_TO_PARTY_NUMBER VARCHAR2(30),
414 INVOICE_TO_PARTY_NUMBER VARCHAR2(30),
415 DELIVER_TO_PARTY_NUMBER VARCHAR2(30),
416 END_CUSTOMER_NUMBER VARCHAR2(50),
417 END_CUSTOMER_PARTY_NUMBER VARCHAR2(30),
418 END_CUSTOMER_ID NUMBER(22),
419 END_CUSTOMER_CONTACT_ID NUMBER(22),
420 END_CUSTOMER_SITE_USE_ID NUMBER(22),
421 END_CUSTOMER_ADDRESS1 VARCHAR2(240),
422 END_CUSTOMER_ADDRESS2 VARCHAR2(240),
423 END_CUSTOMER_ADDRESS3 VARCHAR2(240),
424 END_CUSTOMER_ADDRESS4 VARCHAR2(240),
425 END_CUSTOMER_CITY VARCHAR2(60),
426 END_CUSTOMER_POSTAL_CODE VARCHAR2(60),
427 END_CUSTOMER_COUNTRY VARCHAR2(60),
428 END_CUSTOMER_STATE VARCHAR2(60),
429 END_CUSTOMER_COUNTY VARCHAR2(60),
430 END_CUSTOMER_PROVINCE VARCHAR2(60),
431 END_CUSTOMER_CONTACT VARCHAR2(360),
432 END_CUSTOMER_CONTACT_LAST_NAME VARCHAR2(240),
433 END_CUSTOMER_CONTACT_FIRST_NAM VARCHAR2(240),
434 END_CUSTOMER_NAME VARCHAR2(360),
435 IB_OWNER VARCHAR2(60),
436 IB_CURRENT_LOCATION VARCHAR2(60),
437 IB_INSTALLED_AT_LOCATION VARCHAR2(60),
438 SOLD_TO_LOCATION_ADDRESS1 VARCHAR2(240),
439 SOLD_TO_LOCATION_ADDRESS2 VARCHAR2(240),
440 SOLD_TO_LOCATION_ADDRESS3 VARCHAR2(240),
441 SOLD_TO_LOCATION_ADDRESS4 VARCHAR2(240),
442 SOLD_TO_LOCATION_CITY VARCHAR2(60),
443 SOLD_TO_LOCATION_POSTAL_CODE VARCHAR2(60),
444 SOLD_TO_LOCATION_COUNTRY VARCHAR2(60),
445 GLOBAL_ATTRIBUTE12 VARCHAR2(240),
446 GLOBAL_ATTRIBUTE13 VARCHAR2(240),
447 GLOBAL_ATTRIBUTE14 VARCHAR2(240),
448 GLOBAL_ATTRIBUTE15 VARCHAR2(240),
449 GLOBAL_ATTRIBUTE16 VARCHAR2(240),
450 GLOBAL_ATTRIBUTE17 VARCHAR2(240),
451 GLOBAL_ATTRIBUTE18 VARCHAR2(240),
452 GLOBAL_ATTRIBUTE19 VARCHAR2(240),
453 GLOBAL_ATTRIBUTE20 VARCHAR2(240),
454 HEADER_PO_CONTEXT VARCHAR2(30),
455 INTERFACE_STATUS VARCHAR2(1000),
456 INVOICE_ADDRESS_1 VARCHAR2(240),
457 INVOICE_ADDRESS_2 VARCHAR2(240),
458 INVOICE_ADDRESS_3 VARCHAR2(240),
459 INVOICE_ADDRESS_4 VARCHAR2(240),
460 INVOICE_CITY VARCHAR2(240),
461 INVOICE_COUNTRY VARCHAR2(240),
462 INVOICE_COUNTY VARCHAR2(240),
463 INVOICE_CUSTOMER VARCHAR2(360),
464 INVOICE_CUSTOMER_NUMBER VARCHAR2(50),
465 INVOICE_POSTAL_CODE VARCHAR2(240),
466 INVOICE_PROVINCE_INT VARCHAR2(240),
467 INVOICE_SITE VARCHAR2(30),
468 INVOICE_SITE_CODE VARCHAR2(240),
469 INVOICE_STATE VARCHAR2(240),
470 INVOICE_TO_CONTACT VARCHAR2(330),
471 INVOICE_TO_CONTACT_FIRST_NAME VARCHAR2(240),
472 INVOICE_TO_CONTACT_ID NUMBER(22),
473 INVOICE_TO_CONTACT_LAST_NAME VARCHAR2(240),
474 INVOICE_TO_ORG VARCHAR2(240),
475 INVOICE_TO_ORG_ID NUMBER(22),
476 INVOICE_TOLERANCE_ABOVE NUMBER(22),
477 INVOICE_TOLERANCE_BELOW NUMBER(22),
478 INVOICING_RULE VARCHAR2(30),
479 INVOICING_RULE_ID NUMBER(22),
480 OPEN_FLAG VARCHAR2(1),
481 OPERATION_CODE VARCHAR2(30),
482 ORDER_DATE_TYPE_CODE VARCHAR2(30),
483 ORDER_SOURCE VARCHAR2(240),
484 ORDER_SOURCE_ID NUMBER(22),
485 ORDER_TYPE VARCHAR2(30),
486 ORDER_TYPE_ID NUMBER(22),
487 ORDERED_BY_CONTACT_FIRST_NAME VARCHAR2(150),
488 ORDERED_BY_CONTACT_LAST_NAME VARCHAR2(150),
489 PACKING_INSTRUCTIONS VARCHAR2(2000),
490 PARTIAL_SHIPMENTS_ALLOWED VARCHAR2(1),
491 PAYMENT_TERM_ID NUMBER(22),
492 PAYMENT_TERM VARCHAR2(30),
493 PO_ATTRIBUTE_1 VARCHAR2(240),
494 PO_ATTRIBUTE_2 VARCHAR2(240),
495 PO_ATTRIBUTE_3 VARCHAR2(240),
496 PO_ATTRIBUTE_4 VARCHAR2(240),
497 PO_ATTRIBUTE_5 VARCHAR2(240),
498 PO_ATTRIBUTE_6 VARCHAR2(240),
499 PO_ATTRIBUTE_7 VARCHAR2(240),
500 PO_ATTRIBUTE_8 VARCHAR2(240),
501 PO_ATTRIBUTE_9 VARCHAR2(240),
502 PO_ATTRIBUTE_10 VARCHAR2(240),
503 PO_ATTRIBUTE_11 VARCHAR2(240),
507 PO_ATTRIBUTE_15 VARCHAR2(240),
504 PO_ATTRIBUTE_12 VARCHAR2(240),
505 PO_ATTRIBUTE_13 VARCHAR2(240),
506 PO_ATTRIBUTE_14 VARCHAR2(240),
508 PO_REVISION_DATE DATE,
509 PROGRAM VARCHAR2(30),
510 PROGRAM_APPLICATION VARCHAR2(30),
511 PROGRAM_APPLICATION_ID NUMBER(22),
512 PROGRAM_ID NUMBER(22),
513 PROGRAM_UPDATE_DATE DATE,
514 RELATED_PO_NUMBER VARCHAR2(50),
515 REMAINDER_ORDERS_ALLOWED VARCHAR2(1),
516 REQUEST_DATE DATE,
517 REQUEST_ID NUMBER(22),
518 RETURN_REASON_CODE VARCHAR2(30),
519 SALESREP_ID NUMBER(22),
520 SALESREP VARCHAR2(240),
521 SHIP_TO_ADDRESS_1 VARCHAR2(240),
522 SHIP_TO_ADDRESS_2 VARCHAR2(240),
523 SHIP_TO_ADDRESS_3 VARCHAR2(240),
524 SHIP_TO_ADDRESS_4 VARCHAR2(240),
525 SHIP_TO_CITY VARCHAR2(240),
526 SHIP_TO_CONTACT VARCHAR2(330),
527 SHIP_TO_CONTACT_FIRST_NAME VARCHAR2(240),
528 SHIP_TO_CONTACT_ID NUMBER(22),
529 SHIP_TO_CONTACT_LAST_NAME VARCHAR2(240),
530 SHIP_TO_COUNTRY VARCHAR2(240),
531 SHIP_TO_COUNTY VARCHAR2(240),
532 SHIP_TO_CUSTOMER VARCHAR2(360),
533 SHIP_TO_CUSTOMER_NUMBER VARCHAR2(50),
534 SHIP_TO_POSTAL_CODE VARCHAR2(240),
535 FIRST_ACK_CODE VARCHAR2(30),
536 LAST_ACK_CODE VARCHAR2(30),
537 FIRST_ACK_DATE DATE,
538 LAST_ACK_DATE DATE,
539 BUYER_SELLER_FLAG VARCHAR2(1),
540 CREATED_BY NUMBER(22),
541 CREATION_DATE DATE,
542 LAST_UPDATE_DATE DATE,
543 LAST_UPDATE_LOGIN NUMBER(22),
544 LAST_UPDATED_BY NUMBER(22),
545 BOOKED_FLAG VARCHAR2(1),
546 AGREEMENT_ID NUMBER(22),
547 AGREEMENT VARCHAR2(240),
548 AGREEMENT_NAME VARCHAR2(30),
549 CONTEXT VARCHAR2(30),
550 PRICE_LIST VARCHAR2(240),
551 PRICE_LIST_ID NUMBER(22),
552 PRICING_DATE DATE,
553 SHIP_FROM_ORG_ID NUMBER(22),
554 SHIP_FROM_ORG VARCHAR2(240),
555 SHIP_TO_ORG_ID NUMBER(22),
556 SHIP_TO_ORG VARCHAR2(240),
557 SOLD_FROM_ORG VARCHAR2(240),
558 SOLD_FROM_ORG_ID NUMBER(22),
559 SOLD_TO_ORG VARCHAR2(360),
560 SOLD_TO_ORG_ID NUMBER(22),
561 ATTRIBUTE1 VARCHAR2(240),
562 ATTRIBUTE2 VARCHAR2(240),
563 ATTRIBUTE3 VARCHAR2(240),
564 ATTRIBUTE4 VARCHAR2(240),
565 ATTRIBUTE5 VARCHAR2(240),
566 ATTRIBUTE6 VARCHAR2(240),
567 ATTRIBUTE7 VARCHAR2(240),
568 ATTRIBUTE8 VARCHAR2(240),
569 ATTRIBUTE9 VARCHAR2(240),
570 ATTRIBUTE10 VARCHAR2(240),
571 ATTRIBUTE11 VARCHAR2(240),
572 ATTRIBUTE12 VARCHAR2(240),
573 ATTRIBUTE13 VARCHAR2(240),
574 ATTRIBUTE14 VARCHAR2(240),
575 ATTRIBUTE15 VARCHAR2(240),
576 CANCELLED_FLAG VARCHAR2(1),
577 CLOSED_FLAG VARCHAR2(1),
578 CONVERSION_RATE NUMBER(22),
579 CONVERSION_RATE_DATE DATE,
580 CONVERSION_TYPE VARCHAR2(30),
581 CONVERSION_TYPE_CODE VARCHAR2(30),
582 CUST_PO_NUMBER VARCHAR2(50),
583 CUSTOMER_ID NUMBER(22),
584 CUSTOMER_NAME VARCHAR2(360),
585 CUSTOMER_NUMBER VARCHAR2(30),
586 DELIVER_TO_CONTACT VARCHAR2(330),
587 DELIVER_TO_CONTACT_ID NUMBER(22),
588 DELIVER_TO_CUSTOMER VARCHAR2(360),
589 DELIVER_TO_CUSTOMER_NUMBER VARCHAR2(50),
590 DELIVER_TO_ORG VARCHAR2(240),
591 DELIVER_TO_ORG_ID NUMBER(22),
592 DEMAND_CLASS VARCHAR2(80),
593 DEMAND_CLASS_CODE VARCHAR2(30),
594 EARLIEST_SCHEDULE_LIMIT NUMBER(22),
595 LATEST_SCHEDULE_LIMIT NUMBER(22),
596 ERROR_FLAG VARCHAR2(1),
597 EXPIRATION_DATE DATE,
598 FOB_POINT VARCHAR2(240),
599 FOB_POINT_CODE VARCHAR2(30),
600 FREIGHT_CARRIER_CODE VARCHAR2(30),
601 FREIGHT_TERMS VARCHAR2(80),
602 FREIGHT_TERMS_CODE VARCHAR2(30),
603 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30),
604 GLOBAL_ATTRIBUTE1 VARCHAR2(240),
605 GLOBAL_ATTRIBUTE2 VARCHAR2(240),
606 GLOBAL_ATTRIBUTE3 VARCHAR2(240),
607 GLOBAL_ATTRIBUTE4 VARCHAR2(240),
608 GLOBAL_ATTRIBUTE5 VARCHAR2(240),
609 GLOBAL_ATTRIBUTE6 VARCHAR2(240),
610 GLOBAL_ATTRIBUTE7 VARCHAR2(240),
611 GLOBAL_ATTRIBUTE8 VARCHAR2(240),
612 GLOBAL_ATTRIBUTE9 VARCHAR2(240),
613 GLOBAL_ATTRIBUTE10 VARCHAR2(240),
614 GLOBAL_ATTRIBUTE11 VARCHAR2(240),
615 DELIVER_TO_STATE VARCHAR2(60),
616 SOLD_TO_LOCATION_STATE VARCHAR2(60),
617 SOLD_TO_LOCATION_COUNTY VARCHAR2(60),
618 SOLD_TO_LOCATION_PROVINCE VARCHAR2(60),
619 HEADER_ID NUMBER(22),
620 ORIG_SYS_DOCUMENT_REF VARCHAR2(50),
621 ORDER_NUMBER NUMBER(22),
622 ORDERED_DATE DATE,
623 ORG_ID NUMBER(22),
624 CHANGE_DATE DATE,
625 CHANGE_SEQUENCE VARCHAR2(50),
626 ACCOUNTING_RULE_ID NUMBER(22),
627 ACCOUNTING_RULE VARCHAR2(30),
628 ACKNOWLEDGMENT_FLAG VARCHAR2(1));
629
630 TYPE header_ack_tbl_type IS TABLE OF header_ack_rec_type
631 INDEX BY BINARY_INTEGER;
632
633
634 TYPE line_ack_rec_type IS RECORD
635 (END_CUSTOMER_CONTACT_LAST_NAME VARCHAR2(240),
636 END_CUSTOMER_CONTACT_FIRST_NAM VARCHAR2(240),
637 END_CUSTOMER_NAME VARCHAR2(360),
638 IB_OWNER VARCHAR2(60),
639 IB_CURRENT_LOCATION VARCHAR2(60),
640 IB_INSTALLED_AT_LOCATION VARCHAR2(60),
641 ORDER_FIRMED_DATE DATE,
642 ACTUAL_FULFILLMENT_DATE DATE,
643 COMMITMENT VARCHAR2(240),
644 CUSTOMER_PAYMENT_TERM VARCHAR2(30),
645 DELIVER_TO_ADDRESS1 VARCHAR2(240),
646 DELIVER_TO_ADDRESS2 VARCHAR2(240),
647 DELIVER_TO_ADDRESS3 VARCHAR2(240),
648 DELIVER_TO_ADDRESS4 VARCHAR2(240),
649 DELIVER_TO_CITY VARCHAR2(60),
650 DELIVER_TO_COUNTRY VARCHAR2(60),
651 DELIVER_TO_COUNTY VARCHAR2(60),
652 DELIVER_TO_POSTAL_CODE VARCHAR2(60),
653 DELIVER_TO_PROVINCE VARCHAR2(60),
654 DELIVER_TO_STATE VARCHAR2(60),
655 INVOICE_ADDRESS_1 VARCHAR2(240),
656 INVOICE_ADDRESS_2 VARCHAR2(240),
657 INVOICE_ADDRESS_3 VARCHAR2(240),
658 INVOICE_ADDRESS_4 VARCHAR2(240),
659 INVOICE_COUNTRY VARCHAR2(60),
660 INVOICE_COUNTY VARCHAR2(60),
661 INVOICE_POSTAL_CODE VARCHAR2(60),
662 INVOICE_STATE VARCHAR2(60),
663 IB_OWNER_CODE VARCHAR2(30),
667 CONFIG_HEADER_ID NUMBER(22),
664 IB_CURRENT_LOCATION_CODE VARCHAR2(30),
665 IB_INSTALLED_AT_LOCATION_CODE VARCHAR2(30),
666 CONFIG_REV_NBR NUMBER(22),
668 SHIP_FROM_ADDRESS_1 VARCHAR2(240),
669 SHIP_FROM_ADDRESS_2 VARCHAR2(240),
670 SHIP_FROM_ADDRESS_3 VARCHAR2(240),
671 SHIP_FROM_CITY VARCHAR2(60),
672 SHIP_FROM_POSTAL_CODE VARCHAR2(60),
673 SHIP_FROM_COUNTRY VARCHAR2(60),
674 SHIP_FROM_EDI_LOCATION_CODE VARCHAR2(40),
675 SHIP_FROM_REGION1 VARCHAR2(240),
676 SHIP_FROM_REGION2 VARCHAR2(240),
677 SHIP_FROM_REGION3 VARCHAR2(240),
678 SHIP_FROM_ADDRESS_ID NUMBER(22),
679 SHIP_TO_ADDRESS_CODE VARCHAR2(240),
680 SHIP_TO_ADDRESS_NAME VARCHAR2(360),
681 SHIP_TO_ADDRESS_ID NUMBER(22),
682 INVOICE_ADDRESS_CODE VARCHAR2(40),
683 INVOICE_ADDRESS_NAME VARCHAR2(360),
684 DELIVER_TO_CUSTOMER VARCHAR2(360),
685 SERVICED_LINE_ID NUMBER(22),
686 SERVICE_REFERENCE_ORDER VARCHAR2(50),
687 SERVICE_REFERENCE_LINE VARCHAR2(50),
688 SERVICE_REFERENCE_SYSTEM VARCHAR2(50),
689 TP_CONTEXT VARCHAR2(30),
690 TP_ATTRIBUTE1 VARCHAR2(240),
691 TP_ATTRIBUTE2 VARCHAR2(240),
692 TP_ATTRIBUTE3 VARCHAR2(240),
693 TP_ATTRIBUTE4 VARCHAR2(240),
694 TP_ATTRIBUTE5 VARCHAR2(240),
695 TP_ATTRIBUTE6 VARCHAR2(240),
696 TP_ATTRIBUTE7 VARCHAR2(240),
697 TP_ATTRIBUTE8 VARCHAR2(240),
698 TP_ATTRIBUTE9 VARCHAR2(240),
699 TP_ATTRIBUTE10 VARCHAR2(240),
700 TP_ATTRIBUTE11 VARCHAR2(240),
701 TP_ATTRIBUTE12 VARCHAR2(240),
702 TP_ATTRIBUTE13 VARCHAR2(240),
703 TP_ATTRIBUTE14 VARCHAR2(240),
704 TP_ATTRIBUTE15 VARCHAR2(240),
705 SPLIT_FROM_SHIPMENT_REF VARCHAR2(50),
706 SHIP_TO_CUSTOMER_ID NUMBER(22),
707 INVOICE_TO_CUSTOMER_ID NUMBER(22),
708 UNIT_SELLING_PRICE_PER_PQTY NUMBER(22),
709 DELIVER_TO_CUSTOMER_ID NUMBER(22),
710 SHIP_TO_CUSTOMER_NAME VARCHAR2(360),
711 SHIP_TO_CUSTOMER_NUMBER VARCHAR2(30),
712 INVOICE_TO_CUSTOMER_NAME VARCHAR2(360),
713 INVOICE_TO_CUSTOMER_NUMBER VARCHAR2(30),
714 DELIVER_TO_CUSTOMER_NAME VARCHAR2(360),
715 DELIVER_TO_CUSTOMER_NUMBER VARCHAR2(30),
716 ACCOUNTING_RULE_DURATION NUMBER(22),
717 ATTRIBUTE16 VARCHAR2(240),
718 ATTRIBUTE17 VARCHAR2(240),
719 ATTRIBUTE18 VARCHAR2(240),
720 ATTRIBUTE19 VARCHAR2(240),
721 ATTRIBUTE20 VARCHAR2(240),
722 ACKNOWLEDGMENT_TYPE VARCHAR2(30),
723 USER_ITEM_DESCRIPTION VARCHAR2(1000),
724 BLANKET_NUMBER NUMBER(22),
725 BLANKET_LINE_NUMBER NUMBER(22),
726 ORIGINAL_INVENTORY_ITEM_ID NUMBER(22),
727 ORIGINAL_ORDERED_ITEM_ID NUMBER(22),
728 ORIGINAL_ORDERED_ITEM VARCHAR2(2000),
729 ORDERED_ITEM VARCHAR2(2000),
730 INVOICE_INTERFACE_STATUS_CODE VARCHAR2(30),
731 PREFERRED_GRADE VARCHAR2(4),
732 ORDERED_QUANTITY2 NUMBER(22),
733 ORDERED_QUANTITY_UOM2 VARCHAR2(3),
734 SHIPPING_QUANTITY2 NUMBER(22),
735 CANCELLED_QUANTITY2 NUMBER(22),
736 SHIPPED_QUANTITY2 NUMBER(22),
737 SHIPPING_QUANTITY_UOM2 VARCHAR2(3),
738 FULFILLED_QUANTITY2 NUMBER(22),
739 REVENUE_AMOUNT NUMBER(22),
740 FULFILLMENT_DATE DATE,
741 ORIGINAL_ITEM_IDENTIFIER_TYPE VARCHAR2(30),
742 ITEM_SUBSTITUTION_TYPE_CODE VARCHAR2(30),
743 AUTO_SELECTED_QUANTITY NUMBER(22),
744 ORDERED_ITEM_ID NUMBER(22),
745 ITEM_IDENTIFIER_TYPE VARCHAR2(30),
746 END_ITEM_UNIT_NUMBER VARCHAR2(30),
747 RETURN_ATTRIBUTE13 VARCHAR2(240),
748 RETURN_ATTRIBUTE14 VARCHAR2(240),
749 RETURN_ATTRIBUTE15 VARCHAR2(240),
750 RETURN_ATTRIBUTE2 VARCHAR2(240),
751 RETURN_ATTRIBUTE3 VARCHAR2(240),
752 RETURN_ATTRIBUTE4 VARCHAR2(240),
753 RETURN_ATTRIBUTE5 VARCHAR2(240),
754 RETURN_ATTRIBUTE6 VARCHAR2(240),
755 RETURN_ATTRIBUTE7 VARCHAR2(240),
756 RETURN_ATTRIBUTE8 VARCHAR2(240),
757 RETURN_ATTRIBUTE9 VARCHAR2(240),
758 RETURN_CONTEXT VARCHAR2(30),
759 RETURN_REASON_CODE VARCHAR2(30),
760 RLA_SCHEDULE_TYPE_CODE VARCHAR2(30),
761 SALESREP_ID NUMBER(22),
762 SALESREP VARCHAR2(240),
763 SCHEDULE_ARRIVAL_DATE DATE,
764 SCHEDULE_SHIP_DATE DATE,
765 SCHEDULE_ITEM_DETAIL VARCHAR2(30),
766 SCHEDULE_STATUS_CODE VARCHAR2(30),
767 SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1),
768 SHIP_SET_ID NUMBER(22),
769 SHIP_SET_NAME VARCHAR2(30),
770 SHIP_TO_ADDRESS1 VARCHAR2(240),
771 SHIP_TO_ADDRESS2 VARCHAR2(240),
772 SHIP_TO_ADDRESS3 VARCHAR2(240),
773 SHIP_TO_ADDRESS4 VARCHAR2(240),
774 SHIP_TO_CITY VARCHAR2(60),
775 SHIP_TO_CONTACT VARCHAR2(330),
776 SHIP_TO_CONTACT_AREA_CODE1 VARCHAR2(10),
777 SHIP_TO_CONTACT_AREA_CODE2 VARCHAR2(10),
778 SHIP_TO_CONTACT_AREA_CODE3 VARCHAR2(40),
779 SHIP_TO_CONTACT_FIRST_NAME VARCHAR2(150),
780 SHIP_TO_CONTACT_ID NUMBER(22),
781 SHIP_TO_CONTACT_JOB_TITLE VARCHAR2(100),
782 SHIP_TO_CONTACT_LAST_NAME VARCHAR2(150),
783 SHIP_TO_COUNTRY VARCHAR2(60),
784 SHIP_TO_COUNTY VARCHAR2(60),
785 SHIP_TO_POSTAL_CODE VARCHAR2(60),
786 SHIP_TO_STATE VARCHAR2(60),
787 SHIP_TOLERANCE_ABOVE NUMBER(22),
788 SHIP_TOLERANCE_BELOW NUMBER(22),
789 SHIPMENT_NUMBER NUMBER(22),
790 SHIPMENT_PRIORITY VARCHAR2(80),
791 SHIPMENT_PRIORITY_CODE VARCHAR2(30),
792 SHIPPED_QUANTITY NUMBER(22),
793 SHIPPING_METHOD VARCHAR2(80),
794 SHIPPING_METHOD_CODE VARCHAR2(30),
795 SHIPPING_QUANTITY NUMBER(22),
796 SHIPPING_QUANTITY_UOM VARCHAR2(3),
797 SORT_ORDER VARCHAR2(2000),
798 SOURCE_DOCUMENT_ID NUMBER(22),
799 SOURCE_DOCUMENT_LINE_ID NUMBER(22),
800 SOURCE_DOCUMENT_TYPE_ID NUMBER(22),
801 SOURCE_TYPE_CODE VARCHAR2(30),
802 SPLIT_FROM_LINE_ID NUMBER(22),
803 SUBINVENTORY VARCHAR2(30),
804 SUBMISSION_DATETIME DATE,
805 TASK VARCHAR2(30),
806 TASK_ID NUMBER(22),
807 TAX VARCHAR2(50),
808 TAX_CODE VARCHAR2(50),
809 TAX_DATE DATE,
810 TAX_EXEMPT_FLAG VARCHAR2(30),
811 TAX_EXEMPT_NUMBER VARCHAR2(80),
812 TAX_EXEMPT_REASON VARCHAR2(80),
813 TAX_EXEMPT_REASON_CODE VARCHAR2(30),
817 TAX_VALUE NUMBER(22),
814 TAX_POINT VARCHAR2(80),
815 TAX_POINT_CODE VARCHAR2(30),
816 TAX_RATE NUMBER(22),
818 UNIT_LIST_PRICE NUMBER(22),
819 UNIT_SELLING_PRICE NUMBER(22),
820 VEH_CUS_ITEM_CUM_KEY_ID NUMBER(22),
821 VISIBLE_DEMAND_FLAG VARCHAR2(1),
822 CUSTOMER_LINE_NUMBER VARCHAR2(50),
823 CUSTOMER_SHIPMENT_NUMBER VARCHAR2(50),
824 CUSTOMER_ITEM_NET_PRICE NUMBER(22),
825 CUSTOMER_PAYMENT_TERM_ID NUMBER(22),
826 DROP_SHIP_FLAG VARCHAR2(1),
827 SPLIT_FROM_LINE_REF VARCHAR2(50),
828 SHIP_TO_EDI_LOCATION_CODE VARCHAR2(40),
829 SERVICE_TXN_REASON_CODE VARCHAR2(30),
830 SERVICE_TXN_COMMENTS VARCHAR2(2000),
831 SERVICE_DURATION NUMBER(22),
832 SERVICE_START_DATE DATE,
833 SERVICE_END_DATE DATE,
834 SERVICE_COTERMINATE_FLAG VARCHAR2(1),
835 SERVICE_NUMBER NUMBER(22),
836 SERVICE_PERIOD VARCHAR2(3),
837 SERVICE_REFERENCE_TYPE_CODE VARCHAR2(30),
838 SERVICE_REFERENCE_LINE_ID NUMBER(22),
839 SERVICE_REFERENCE_SYSTEM_ID NUMBER(22),
840 CREDIT_INVOICE_LINE_ID NUMBER(22),
841 SHIP_TO_PROVINCE VARCHAR2(60),
842 INVOICE_PROVINCE VARCHAR2(60),
843 BILL_TO_EDI_LOCATION_CODE VARCHAR2(40),
844 INVOICE_CITY VARCHAR2(60),
845 INVENTORY_ITEM_SEGMENT_17 VARCHAR2(240),
846 INVENTORY_ITEM_SEGMENT_18 VARCHAR2(240),
847 INVENTORY_ITEM_SEGMENT_19 VARCHAR2(240),
848 INVENTORY_ITEM_SEGMENT_2 VARCHAR2(240),
849 INVENTORY_ITEM_SEGMENT_20 VARCHAR2(240),
850 INVENTORY_ITEM_SEGMENT_3 VARCHAR2(240),
851 INVENTORY_ITEM_SEGMENT_4 VARCHAR2(240),
852 INVENTORY_ITEM_SEGMENT_5 VARCHAR2(240),
853 INVENTORY_ITEM_SEGMENT_6 VARCHAR2(240),
854 INVENTORY_ITEM_SEGMENT_7 VARCHAR2(240),
855 INVENTORY_ITEM_SEGMENT_8 VARCHAR2(240),
856 INVENTORY_ITEM_SEGMENT_9 VARCHAR2(240),
857 INVOICE_COMPLETE_FLAG VARCHAR2(1),
858 INVOICE_SET_ID NUMBER(22),
859 INVOICE_SET_NAME VARCHAR2(30),
860 INVOICE_NUMBER VARCHAR2(20),
861 INVOICE_TO_CONTACT VARCHAR2(330),
862 INVOICE_TO_CONTACT_ID NUMBER(22),
863 INVOICE_TO_ORG VARCHAR2(240),
864 INVOICE_TO_ORG_ID NUMBER(22),
865 INVOICE_TOLERANCE_ABOVE NUMBER(22),
866 INVOICE_TOLERANCE_BELOW NUMBER(22),
867 INVOICING_RULE VARCHAR2(30),
868 INVOICING_RULE_ID NUMBER(22),
869 ITEM_INPUT VARCHAR2(240),
870 ITEM_REVISION VARCHAR2(3),
871 ITEM_TYPE_CODE VARCHAR2(30),
872 LATEST_ACCEPTABLE_DATE DATE,
873 LINE_CATEGORY_CODE VARCHAR2(30),
874 LINE_ID NUMBER(22),
875 LINE_NUMBER NUMBER(22),
876 LINE_PO_CONTEXT VARCHAR2(30),
877 LINE_TYPE VARCHAR2(30),
878 LINE_TYPE_ID NUMBER(22),
879 LINK_TO_LINE_ID NUMBER(22),
880 LINK_TO_LINE_REF VARCHAR2(50),
881 LOAD_SEQ_NUMBER NUMBER(22),
882 LOT VARCHAR2(30),
883 MATERIAL_COST NUMBER(22),
884 MATERIAL_OVERHEAD_COST NUMBER(22),
885 MODEL_GROUP_NUMBER NUMBER(22),
886 OPEN_FLAG VARCHAR2(1),
887 OPERATION_CODE VARCHAR2(30),
888 OPTION_FLAG VARCHAR2(1),
889 OPTION_NUMBER NUMBER(22),
890 ORDER_QUANTITY_UOM VARCHAR2(3),
891 ORDER_SOURCE VARCHAR2(30),
892 ORDER_SOURCE_ID NUMBER(22),
893 ORDERED_QUANTITY NUMBER(22),
894 ORG_ID NUMBER(22),
895 OUTSIDE_PROCESSING_COST NUMBER(22),
896 ORIG_SYS_SHIPMENT_REF VARCHAR2(50),
897 OVER_SHIP_REASON_CODE VARCHAR2(30),
898 OVER_SHIP_RESOLVED_FLAG VARCHAR2(1),
899 OVERHEAD_COST NUMBER(22),
900 PAYMENT_TERM VARCHAR2(30),
901 PAYMENT_TERM_ID NUMBER(22),
902 PAYMENT_TRX VARCHAR2(30),
903 PAYMENT_TRX_ID NUMBER(22),
904 PLANNING_PROD_SEQ_NUM NUMBER(22),
905 PRICING_ATTRIBUTE1 VARCHAR2(240),
906 PRICING_ATTRIBUTE10 VARCHAR2(240),
907 PRICING_ATTRIBUTE2 VARCHAR2(240),
908 PRICING_ATTRIBUTE3 VARCHAR2(240),
909 PRICING_ATTRIBUTE4 VARCHAR2(240),
910 PRICING_ATTRIBUTE5 VARCHAR2(240),
911 PRICING_ATTRIBUTE6 VARCHAR2(240),
912 PRICING_ATTRIBUTE7 VARCHAR2(240),
913 PRICING_ATTRIBUTE8 VARCHAR2(240),
914 PRICING_ATTRIBUTE9 VARCHAR2(240),
915 PRICING_CONTEXT VARCHAR2(150),
916 PRICING_DATE DATE,
917 PRICING_QUANTITY NUMBER(22),
918 PRICING_QUANTITY_UOM VARCHAR2(3),
919 PROGRAM VARCHAR2(30),
920 PROGRAM_APPLICATION VARCHAR2(30),
921 PROGRAM_APPLICATION_ID NUMBER(22),
922 PROGRAM_ID NUMBER(22),
923 PROGRAM_UPDATE_DATE DATE,
924 PROJECT VARCHAR2(30),
925 PROJECT_ID NUMBER(22),
926 PROMISE_DATE DATE,
927 REFERENCE_HEADER VARCHAR2(30),
928 REFERENCE_HEADER_ID NUMBER(22),
929 REFERENCE_LINE VARCHAR2(30),
930 REFERENCE_LINE_ID NUMBER(22),
931 REFERENCE_TYPE VARCHAR2(30),
932 RELATED_PO_NUMBER VARCHAR2(50),
933 REQUEST_DATE DATE,
934 REQUEST_ID NUMBER(22),
935 RESERVED_QUANTITY NUMBER(22),
936 RESOURCE_COST NUMBER(22),
937 RETURN_ATTRIBUTE1 VARCHAR2(240),
938 RETURN_ATTRIBUTE10 VARCHAR2(240),
939 RETURN_ATTRIBUTE11 VARCHAR2(240),
940 RETURN_ATTRIBUTE12 VARCHAR2(240),
941 DELIVER_TO_CONTACT_ID NUMBER(22),
942 DELIVER_TO_ORG VARCHAR2(240),
943 DELIVER_TO_ORG_ID NUMBER(22),
944 DELIVERY_LEAD_TIME NUMBER(22),
945 DEMAND_BUCKET_TYPE VARCHAR2(80),
946 DEMAND_BUCKET_TYPE_CODE VARCHAR2(30),
947 DEMAND_CLASS VARCHAR2(80),
948 DEMAND_CLASS_CODE VARCHAR2(30),
949 DEMAND_STREAM VARCHAR2(30),
950 DEP_PLAN_REQUIRED_FLAG VARCHAR2(1),
951 DPW_ASSIGNED_FLAG VARCHAR2(1),
952 EARLIEST_ACCEPTABLE_DATE DATE,
953 ERROR_FLAG VARCHAR2(1),
954 EXPLOSION_DATE DATE,
955 FOB_POINT VARCHAR2(240),
956 FOB_POINT_CODE VARCHAR2(30),
957 FREIGHT_CARRIER_CODE VARCHAR2(30),
958 FREIGHT_TERMS VARCHAR2(80),
959 FREIGHT_TERMS_CODE VARCHAR2(30),
960 FULFILLED_QUANTITY NUMBER(22),
961 FULFILLMENT_SET_ID NUMBER(22),
962 FULFILLMENT_SET_NAME VARCHAR2(30),
963 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30),
964 GLOBAL_ATTRIBUTE1 VARCHAR2(240),
965 GLOBAL_ATTRIBUTE10 VARCHAR2(240),
966 GLOBAL_ATTRIBUTE11 VARCHAR2(240),
967 GLOBAL_ATTRIBUTE12 VARCHAR2(240),
971 GLOBAL_ATTRIBUTE16 VARCHAR2(240),
968 GLOBAL_ATTRIBUTE13 VARCHAR2(240),
969 GLOBAL_ATTRIBUTE14 VARCHAR2(240),
970 GLOBAL_ATTRIBUTE15 VARCHAR2(240),
972 GLOBAL_ATTRIBUTE17 VARCHAR2(240),
973 GLOBAL_ATTRIBUTE18 VARCHAR2(240),
974 GLOBAL_ATTRIBUTE19 VARCHAR2(240),
975 GLOBAL_ATTRIBUTE2 VARCHAR2(240),
976 GLOBAL_ATTRIBUTE20 VARCHAR2(240),
977 GLOBAL_ATTRIBUTE3 VARCHAR2(240),
978 GLOBAL_ATTRIBUTE4 VARCHAR2(240),
979 GLOBAL_ATTRIBUTE5 VARCHAR2(240),
980 GLOBAL_ATTRIBUTE6 VARCHAR2(240),
981 GLOBAL_ATTRIBUTE7 VARCHAR2(240),
982 GLOBAL_ATTRIBUTE8 VARCHAR2(240),
983 GLOBAL_ATTRIBUTE9 VARCHAR2(240),
984 INDUSTRY_ATTRIBUTE1 VARCHAR2(240),
985 INDUSTRY_ATTRIBUTE10 VARCHAR2(240),
986 INDUSTRY_ATTRIBUTE11 VARCHAR2(240),
987 INDUSTRY_ATTRIBUTE12 VARCHAR2(240),
988 INDUSTRY_ATTRIBUTE13 VARCHAR2(240),
989 INDUSTRY_ATTRIBUTE14 VARCHAR2(240),
990 INDUSTRY_ATTRIBUTE15 VARCHAR2(240),
991 INDUSTRY_ATTRIBUTE16 VARCHAR2(240),
992 INDUSTRY_ATTRIBUTE17 VARCHAR2(240),
993 INDUSTRY_ATTRIBUTE18 VARCHAR2(240),
994 INDUSTRY_ATTRIBUTE19 VARCHAR2(240),
995 INDUSTRY_ATTRIBUTE2 VARCHAR2(240),
996 INDUSTRY_ATTRIBUTE20 VARCHAR2(240),
997 INDUSTRY_ATTRIBUTE21 VARCHAR2(240),
998 INDUSTRY_ATTRIBUTE22 VARCHAR2(240),
999 INDUSTRY_ATTRIBUTE23 VARCHAR2(240),
1000 INDUSTRY_ATTRIBUTE24 VARCHAR2(240),
1001 INDUSTRY_ATTRIBUTE25 VARCHAR2(240),
1002 INDUSTRY_ATTRIBUTE26 VARCHAR2(240),
1003 INDUSTRY_ATTRIBUTE27 VARCHAR2(240),
1004 INDUSTRY_ATTRIBUTE28 VARCHAR2(240),
1005 INDUSTRY_ATTRIBUTE29 VARCHAR2(240),
1006 INDUSTRY_ATTRIBUTE3 VARCHAR2(240),
1007 INDUSTRY_ATTRIBUTE30 VARCHAR2(240),
1008 INDUSTRY_ATTRIBUTE4 VARCHAR2(240),
1009 INDUSTRY_ATTRIBUTE5 VARCHAR2(240),
1010 INDUSTRY_ATTRIBUTE6 VARCHAR2(240),
1011 INDUSTRY_ATTRIBUTE7 VARCHAR2(240),
1012 INDUSTRY_ATTRIBUTE8 VARCHAR2(240),
1013 INDUSTRY_ATTRIBUTE9 VARCHAR2(240),
1014 INDUSTRY_CONTEXT VARCHAR2(30),
1015 INTMED_SHIP_TO_CONTACT_ID NUMBER(22),
1016 INTMED_SHIP_TO_ORG_ID NUMBER(22),
1017 INTERFACE_STATUS VARCHAR2(1000),
1018 INVENTORY_ITEM VARCHAR2(240),
1019 INVENTORY_ITEM_ID NUMBER(22),
1020 INVENTORY_ITEM_SEGMENT_1 VARCHAR2(240),
1021 INVENTORY_ITEM_SEGMENT_10 VARCHAR2(240),
1022 INVENTORY_ITEM_SEGMENT_11 VARCHAR2(240),
1023 INVENTORY_ITEM_SEGMENT_12 VARCHAR2(240),
1024 INVENTORY_ITEM_SEGMENT_13 VARCHAR2(240),
1025 INVENTORY_ITEM_SEGMENT_14 VARCHAR2(240),
1026 INVENTORY_ITEM_SEGMENT_15 VARCHAR2(240),
1027 INVENTORY_ITEM_SEGMENT_16 VARCHAR2(240),
1028 SHIP_TO_PARTY_NUMBER VARCHAR2(30),
1029 INVOICE_TO_PARTY_NUMBER VARCHAR2(30),
1030 DELIVER_TO_PARTY_NUMBER VARCHAR2(30),
1031 END_CUSTOMER_NUMBER VARCHAR2(50),
1032 END_CUSTOMER_PARTY_NUMBER VARCHAR2(30),
1033 END_CUSTOMER_ID NUMBER(22),
1034 END_CUSTOMER_CONTACT_ID NUMBER(22),
1035 END_CUSTOMER_SITE_USE_ID NUMBER(22),
1036 END_CUSTOMER_ADDRESS1 VARCHAR2(240),
1037 END_CUSTOMER_ADDRESS2 VARCHAR2(240),
1038 END_CUSTOMER_ADDRESS3 VARCHAR2(240),
1039 END_CUSTOMER_ADDRESS4 VARCHAR2(240),
1040 END_CUSTOMER_CITY VARCHAR2(60),
1041 END_CUSTOMER_POSTAL_CODE VARCHAR2(60),
1042 END_CUSTOMER_COUNTRY VARCHAR2(60),
1043 END_CUSTOMER_STATE VARCHAR2(60),
1044 END_CUSTOMER_COUNTY VARCHAR2(60),
1045 END_CUSTOMER_PROVINCE VARCHAR2(60),
1046 END_CUSTOMER_CONTACT VARCHAR2(360),
1047 SHIPPING_INSTRUCTIONS VARCHAR2(2000),
1048 PACKING_INSTRUCTIONS VARCHAR2(2000),
1049 INVOICED_QUANTITY NUMBER(22),
1050 REFERENCE_CUSTOMER_TRX_LINE_ID NUMBER(22),
1051 SPLIT_BY VARCHAR2(30),
1052 LINE_SET_ID NUMBER(22),
1053 UNIT_LIST_PERCENT NUMBER(22),
1054 UNIT_SELLING_PERCENT NUMBER(22),
1055 UNIT_PERCENT_BASE_PRICE NUMBER(22),
1056 RE_SOURCE_FLAG VARCHAR2(1),
1057 FLOW_STATUS_CODE VARCHAR2(30),
1058 UNIT_LIST_PRICE_PER_PQTY NUMBER(22),
1059 UNIT_SELLING_PRICE_PQTY NUMBER(22),
1060 ITEM_RELATIONSHIP_TYPE NUMBER(22),
1061 HEADER_ID NUMBER(22),
1062 ORIG_SYS_DOCUMENT_REF VARCHAR2(50),
1063 ORIG_SYS_LINE_REF VARCHAR2(50),
1064 CHANGE_DATE DATE,
1065 CHANGE_SEQUENCE VARCHAR2(50),
1066 ACCOUNTING_RULE VARCHAR2(30),
1067 ORDER_NUMBER NUMBER(22),
1068 ACCOUNTING_RULE_ID NUMBER(22),
1069 ACKNOWLEDGMENT_FLAG VARCHAR2(1),
1070 FIRST_ACK_CODE VARCHAR2(30),
1071 LAST_ACK_CODE VARCHAR2(30),
1072 FIRST_ACK_DATE DATE,
1073 LAST_ACK_DATE DATE,
1074 BUYER_SELLER_FLAG VARCHAR2(1),
1075 CREATED_BY NUMBER(22),
1076 CREATION_DATE DATE,
1077 LAST_UPDATE_DATE DATE,
1078 LAST_UPDATE_LOGIN NUMBER(22),
1079 LAST_UPDATED_BY NUMBER(22),
1080 ACTUAL_ARRIVAL_DATE DATE,
1081 ACTUAL_SHIPMENT_DATE DATE,
1082 AGREEMENT VARCHAR2(240),
1083 AGREEMENT_ID NUMBER(22),
1084 ARRIVAL_SET_ID NUMBER(22),
1085 ARRIVAL_SET_NAME VARCHAR2(30),
1086 PRICE_LIST VARCHAR2(240),
1087 PRICE_LIST_ID NUMBER(22),
1088 SHIP_FROM_ORG VARCHAR2(240),
1089 SHIP_FROM_ORG_ID NUMBER(22),
1090 SHIP_TO_ORG VARCHAR2(240),
1091 SHIP_TO_ORG_ID NUMBER(22),
1092 SOLD_FROM_ORG VARCHAR2(240),
1093 SOLD_FROM_ORG_ID NUMBER(22),
1094 SOLD_TO_ORG VARCHAR2(360),
1095 SOLD_TO_ORG_ID NUMBER(22),
1096 ATO_LINE_ID NUMBER(22),
1097 ATTRIBUTE1 VARCHAR2(240),
1098 ATTRIBUTE10 VARCHAR2(240),
1099 ATTRIBUTE11 VARCHAR2(240),
1100 ATTRIBUTE12 VARCHAR2(240),
1101 ATTRIBUTE13 VARCHAR2(240),
1102 ATTRIBUTE14 VARCHAR2(240),
1103 ATTRIBUTE15 VARCHAR2(240),
1104 ATTRIBUTE2 VARCHAR2(240),
1105 ATTRIBUTE3 VARCHAR2(240),
1106 ATTRIBUTE4 VARCHAR2(240),
1107 ATTRIBUTE5 VARCHAR2(240),
1108 ATTRIBUTE6 VARCHAR2(240),
1109 ATTRIBUTE7 VARCHAR2(240),
1110 ATTRIBUTE8 VARCHAR2(240),
1111 ATTRIBUTE9 VARCHAR2(240),
1112 AUTHORIZED_TO_SHIP_FLAG VARCHAR2(1),
1113 BOOKED_FLAG VARCHAR2(1),
1114 CALCULATE_PRICE_FLAG VARCHAR2(1),
1115 CANCELLED_FLAG VARCHAR2(1),
1116 CANCELLED_QUANTITY NUMBER(22),
1117 CLOSED_FLAG VARCHAR2(1),
1118 COMMITMENT_ID NUMBER(22),
1122 CONFIG_DISPLAY_SEQUENCE NUMBER(22),
1119 COMPONENT_CODE VARCHAR2(1000),
1120 COMPONENT_NUMBER NUMBER(22),
1121 COMPONENT_SEQUENCE_ID NUMBER(22),
1123 CONFIGURATION_ID NUMBER(22),
1124 CONFIG_LINE_REF VARCHAR2(50),
1125 TOP_MODEL_LINE_ID NUMBER(22),
1126 CONTEXT VARCHAR2(30),
1127 CONTRACT_PO_NUMBER VARCHAR2(150),
1128 COST_TYPE VARCHAR2(30),
1129 COST_TYPE_ID NUMBER(22),
1130 COSTING_DATE DATE,
1131 CUST_MODEL_SERIAL_NUMBER VARCHAR2(50),
1132 CUST_PO_NUMBER VARCHAR2(50),
1133 CUST_PRODUCTION_SEQ_NUM VARCHAR2(50),
1134 CUSTOMER_DOCK VARCHAR2(50),
1135 CUSTOMER_DOCK_CODE VARCHAR2(50),
1136 CUSTOMER_ITEM VARCHAR2(2000),
1137 CUSTOMER_ITEM_ID NUMBER(22),
1138 CUSTOMER_ITEM_REVISION VARCHAR2(50),
1139 CUSTOMER_JOB VARCHAR2(50),
1140 CUSTOMER_PRODUCTION_LINE VARCHAR2(50),
1141 CUSTOMER_TRX_LINE_ID NUMBER(22),
1142 DELIVERY_ID NUMBER(22),
1143 DELIVER_TO_CONTACT VARCHAR2(330));
1144
1145 TYPE line_ack_tbl_type IS TABLE OF line_ack_rec_type
1146 INDEX BY BINARY_INTEGER;
1147 -- GENESIS --
1148
1149 END OE_Acknowledgment_Pub;