[Home] [Help]
PACKAGE: APPS.OE_ACKNOWLEDGMENT_PUB
Source
1 PACKAGE OE_Acknowledgment_Pub AUTHID CURRENT_USER AS
2 /* $Header: OEXPACKS.pls 120.5 2010/10/08 05:30:35 srsunkar 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 );
264
265 Procedure Process_3A8
266 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
267 , p_old_line_rec IN 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 --SUN OIP ER
276 FUNCTION Get_Line_Index
277 ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
278 p_line_id IN Number
279 )
280 RETURN NUMBER;
281 --End of SUN OIP ER
282 Procedure Raise_CBOD_Out_Event
283 ( p_orig_sys_document_ref IN Varchar2,
284 p_sold_to_org_id IN Number,
285 p_change_sequence IN Varchar2,
286 p_icn IN Number,
287 p_org_id IN Number,
288 p_transaction_type IN Varchar2,
289 p_confirmation_flag IN Varchar2,
290 p_cbod_message_text IN Varchar2,
294 (
291 x_return_status OUT NOCOPY VARCHAR2);
292 -- GENESIS --
293 TYPE header_ack_rec_type IS RECORD
295 IB_OWNER_CODE VARCHAR2(30),
296 IB_CURRENT_LOCATION_CODE VARCHAR2(30),
297 IB_INSTALLED_AT_LOCATION_CODE VARCHAR2(30),
298 INVOICE_CUSTOMER_ID NUMBER,
299 DELIVER_TO_CUSTOMER_ID NUMBER,
300 ACCOUNTING_RULE_DURATION NUMBER,
301 ATTRIBUTE16 VARCHAR2(240),
302 ATTRIBUTE17 VARCHAR2(240),
303 ATTRIBUTE18 VARCHAR2(240),
304 ATTRIBUTE19 VARCHAR2(240),
305 ATTRIBUTE20 VARCHAR2(240),
306 ACKNOWLEDGMENT_TYPE VARCHAR2(30),
307 BLANKET_NUMBER NUMBER,
308 BOOKED_DATE DATE,
309 FLOW_STATUS_CODE VARCHAR2(30),
310 CREDIT_CARD_APPROVAL_DATE DATE,
311 PAYMENT_TYPE_CODE VARCHAR2(30),
312 PAYMENT_AMOUNT NUMBER,
313 CHECK_NUMBER VARCHAR2(50),
314 CREDIT_CARD_CODE VARCHAR2(80),
315 CREDIT_CARD_HOLDER_NAME VARCHAR2(80),
316 CREDIT_CARD_NUMBER VARCHAR2(80),
317 CREDIT_CARD_EXPIRATION_DATE DATE,
318 CREDIT_CARD_APPROVAL_CODE VARCHAR2(80),
319 CUSTOMER_PREFERENCE_SET_CODE VARCHAR2(30),
320 SALES_CHANNEL_CODE VARCHAR2(30),
321 SOLD_TO_PHONE_ID NUMBER,
322 SHIP_TO_PROVINCE VARCHAR2(240),
323 SHIP_TO_SITE_INT VARCHAR2(30),
324 SHIP_TO_STATE VARCHAR2(240),
325 SHIP_TOLERANCE_ABOVE NUMBER,
326 SHIP_TOLERANCE_BELOW NUMBER,
327 SHIPMENT_PRIORITY VARCHAR2(80),
328 SHIPMENT_PRIORITY_CODE VARCHAR2(30),
329 SHIPMENT_PRIORITY_CODE_INT VARCHAR2(30),
330 SHIPPING_INSTRUCTIONS VARCHAR2(2000),
331 SHIPPING_METHOD VARCHAR2(80),
332 SHIPPING_METHOD_CODE VARCHAR2(30),
333 SOLD_TO_CONTACT VARCHAR2(330),
334 SOLD_TO_CONTACT_ID NUMBER,
335 SOURCE_DOCUMENT_ID NUMBER,
336 SOURCE_DOCUMENT_TYPE_ID NUMBER,
337 SUBMISSION_DATETIME DATE,
338 TAX_EXEMPT_FLAG VARCHAR2(30),
339 TAX_EXEMPT_NUMBER VARCHAR2(80),
340 TAX_EXEMPT_REASON VARCHAR2(80),
341 TAX_EXEMPT_REASON_CODE VARCHAR2(30),
342 TAX_POINT VARCHAR2(80),
343 TAX_POINT_CODE VARCHAR2(30),
344 TRANSACTIONAL_CURR VARCHAR2(80),
345 TRANSACTIONAL_CURR_CODE VARCHAR2(15),
346 VERSION_NUMBER NUMBER,
347 CUSTOMER_PAYMENT_TERM_ID NUMBER,
348 DROP_SHIP_FLAG VARCHAR2(1),
349 ORDER_CATEGORY_CODE VARCHAR2(30),
350 SOLD_TO_ADDRESS1 VARCHAR2(240),
351 SOLD_TO_ADDRESS2 VARCHAR2(240),
352 SOLD_TO_ADDRESS3 VARCHAR2(240),
353 SOLD_TO_ADDRESS4 VARCHAR2(240),
354 SOLD_TO_CITY VARCHAR2(240),
355 SOLD_TO_POSTAL_CODE VARCHAR2(240),
356 SOLD_TO_COUNTRY VARCHAR2(240),
357 SOLD_TO_STATE VARCHAR2(240),
358 SOLD_TO_COUNTY VARCHAR2(240),
359 SOLD_TO_PROVINCE VARCHAR2(240),
360 SOLD_TO_CONTACT_LAST_NAME VARCHAR2(240),
361 SOLD_TO_CONTACT_FIRST_NAME VARCHAR2(240),
362 SHIP_TO_EDI_LOCATION_CODE VARCHAR2(40),
363 SOLD_TO_EDI_LOCATION_CODE VARCHAR2(40),
364 BILL_TO_EDI_LOCATION_CODE VARCHAR2(40),
365 CUSTOMER_PAYMENT_TERM VARCHAR2(30),
366 SHIP_FROM_ADDRESS_1 VARCHAR2(240),
367 SHIP_FROM_ADDRESS_2 VARCHAR2(240),
368 SHIP_FROM_ADDRESS_3 VARCHAR2(240),
369 SHIP_FROM_CITY VARCHAR2(60),
370 SHIP_FROM_POSTAL_CODE VARCHAR2(60),
371 SHIP_FROM_COUNTRY VARCHAR2(60),
372 SHIP_FROM_EDI_LOCATION_CODE VARCHAR2(40),
373 SHIP_FROM_REGION1 VARCHAR2(240),
374 SHIP_FROM_REGION2 VARCHAR2(240),
375 SHIP_FROM_REGION3 VARCHAR2(240),
376 SHIP_FROM_ADDRESS_ID NUMBER,
377 SOLD_TO_ADDRESS_ID NUMBER,
378 SHIP_TO_ADDRESS_ID NUMBER,
379 INVOICE_ADDRESS_ID NUMBER,
380 SHIP_TO_ADDRESS_CODE VARCHAR2(240),
381 TP_CONTEXT VARCHAR2(30),
382 TP_ATTRIBUTE1 VARCHAR2(240),
383 TP_ATTRIBUTE2 VARCHAR2(240),
384 TP_ATTRIBUTE3 VARCHAR2(240),
385 TP_ATTRIBUTE4 VARCHAR2(240),
386 TP_ATTRIBUTE5 VARCHAR2(240),
387 TP_ATTRIBUTE6 VARCHAR2(240),
388 TP_ATTRIBUTE7 VARCHAR2(240),
389 TP_ATTRIBUTE8 VARCHAR2(240),
390 TP_ATTRIBUTE9 VARCHAR2(240),
391 TP_ATTRIBUTE10 VARCHAR2(240),
392 TP_ATTRIBUTE11 VARCHAR2(240),
393 TP_ATTRIBUTE12 VARCHAR2(240),
394 TP_ATTRIBUTE13 VARCHAR2(240),
395 TP_ATTRIBUTE14 VARCHAR2(240),
396 TP_ATTRIBUTE15 VARCHAR2(240),
397 XML_MESSAGE_ID NUMBER,
398 SHIP_TO_CUSTOMER_ID NUMBER,
399 ORDER_FIRMED_DATE DATE,
400 DELIVER_TO_ADDRESS1 VARCHAR2(240),
401 DELIVER_TO_ADDRESS2 VARCHAR2(240),
402 DELIVER_TO_ADDRESS3 VARCHAR2(240),
403 DELIVER_TO_ADDRESS4 VARCHAR2(240),
404 DELIVER_TO_CITY VARCHAR2(60),
405 DELIVER_TO_COUNTRY VARCHAR2(60),
406 DELIVER_TO_COUNTY VARCHAR2(60),
407 DELIVER_TO_POSTAL_CODE VARCHAR2(60),
408 DELIVER_TO_PROVINCE VARCHAR2(60),
409 TRANSACTION_PHASE_CODE VARCHAR2(30),
410 SALES_DOCUMENT_NAME VARCHAR2(240),
411 QUOTE_NUMBER NUMBER,
412 QUOTE_DATE DATE,
413 USER_STATUS_CODE VARCHAR2(30),
414 SOLD_TO_SITE_USE_ID NUMBER,
415 SUPPLIER_SIGNATURE VARCHAR2(240),
416 SUPPLIER_SIGNATURE_DATE DATE,
417 CUSTOMER_SIGNATURE VARCHAR2(240),
421 INVOICE_TO_PARTY_NUMBER VARCHAR2(30),
418 CUSTOMER_SIGNATURE_DATE DATE,
419 SOLD_TO_PARTY_NUMBER VARCHAR2(30),
420 SHIP_TO_PARTY_NUMBER VARCHAR2(30),
422 DELIVER_TO_PARTY_NUMBER VARCHAR2(30),
423 END_CUSTOMER_NUMBER VARCHAR2(50),
424 END_CUSTOMER_PARTY_NUMBER VARCHAR2(30),
425 END_CUSTOMER_ID NUMBER,
426 END_CUSTOMER_CONTACT_ID NUMBER,
427 END_CUSTOMER_SITE_USE_ID NUMBER,
428 END_CUSTOMER_ADDRESS1 VARCHAR2(240),
429 END_CUSTOMER_ADDRESS2 VARCHAR2(240),
430 END_CUSTOMER_ADDRESS3 VARCHAR2(240),
431 END_CUSTOMER_ADDRESS4 VARCHAR2(240),
432 END_CUSTOMER_CITY VARCHAR2(60),
433 END_CUSTOMER_POSTAL_CODE VARCHAR2(60),
434 END_CUSTOMER_COUNTRY VARCHAR2(60),
435 END_CUSTOMER_STATE VARCHAR2(60),
436 END_CUSTOMER_COUNTY VARCHAR2(60),
437 END_CUSTOMER_PROVINCE VARCHAR2(60),
438 END_CUSTOMER_CONTACT VARCHAR2(360),
439 END_CUSTOMER_CONTACT_LAST_NAME VARCHAR2(240),
440 END_CUSTOMER_CONTACT_FIRST_NAM VARCHAR2(240),
441 END_CUSTOMER_NAME VARCHAR2(360),
442 IB_OWNER VARCHAR2(60),
443 IB_CURRENT_LOCATION VARCHAR2(60),
444 IB_INSTALLED_AT_LOCATION VARCHAR2(60),
445 SOLD_TO_LOCATION_ADDRESS1 VARCHAR2(240),
446 SOLD_TO_LOCATION_ADDRESS2 VARCHAR2(240),
447 SOLD_TO_LOCATION_ADDRESS3 VARCHAR2(240),
448 SOLD_TO_LOCATION_ADDRESS4 VARCHAR2(240),
449 SOLD_TO_LOCATION_CITY VARCHAR2(60),
450 SOLD_TO_LOCATION_POSTAL_CODE VARCHAR2(60),
451 SOLD_TO_LOCATION_COUNTRY VARCHAR2(60),
452 GLOBAL_ATTRIBUTE12 VARCHAR2(240),
453 GLOBAL_ATTRIBUTE13 VARCHAR2(240),
454 GLOBAL_ATTRIBUTE14 VARCHAR2(240),
455 GLOBAL_ATTRIBUTE15 VARCHAR2(240),
456 GLOBAL_ATTRIBUTE16 VARCHAR2(240),
457 GLOBAL_ATTRIBUTE17 VARCHAR2(240),
458 GLOBAL_ATTRIBUTE18 VARCHAR2(240),
459 GLOBAL_ATTRIBUTE19 VARCHAR2(240),
460 GLOBAL_ATTRIBUTE20 VARCHAR2(240),
461 HEADER_PO_CONTEXT VARCHAR2(30),
462 INTERFACE_STATUS VARCHAR2(1000),
463 INVOICE_ADDRESS_1 VARCHAR2(240),
464 INVOICE_ADDRESS_2 VARCHAR2(240),
465 INVOICE_ADDRESS_3 VARCHAR2(240),
466 INVOICE_ADDRESS_4 VARCHAR2(240),
467 INVOICE_CITY VARCHAR2(240),
468 INVOICE_COUNTRY VARCHAR2(240),
469 INVOICE_COUNTY VARCHAR2(240),
470 INVOICE_CUSTOMER VARCHAR2(360),
471 INVOICE_CUSTOMER_NUMBER VARCHAR2(50),
472 INVOICE_POSTAL_CODE VARCHAR2(240),
473 INVOICE_PROVINCE_INT VARCHAR2(240),
474 INVOICE_SITE VARCHAR2(30),
475 INVOICE_SITE_CODE VARCHAR2(240),
476 INVOICE_STATE VARCHAR2(240),
477 INVOICE_TO_CONTACT VARCHAR2(330),
478 INVOICE_TO_CONTACT_FIRST_NAME VARCHAR2(240),
479 INVOICE_TO_CONTACT_ID NUMBER,
480 INVOICE_TO_CONTACT_LAST_NAME VARCHAR2(240),
481 INVOICE_TO_ORG VARCHAR2(240),
482 INVOICE_TO_ORG_ID NUMBER,
483 INVOICE_TOLERANCE_ABOVE NUMBER,
484 INVOICE_TOLERANCE_BELOW NUMBER,
485 INVOICING_RULE VARCHAR2(30),
486 INVOICING_RULE_ID NUMBER,
487 OPEN_FLAG VARCHAR2(1),
488 OPERATION_CODE VARCHAR2(30),
489 ORDER_DATE_TYPE_CODE VARCHAR2(30),
490 ORDER_SOURCE VARCHAR2(240),
491 ORDER_SOURCE_ID NUMBER,
492 ORDER_TYPE VARCHAR2(30),
493 ORDER_TYPE_ID NUMBER,
494 ORDERED_BY_CONTACT_FIRST_NAME VARCHAR2(150),
495 ORDERED_BY_CONTACT_LAST_NAME VARCHAR2(150),
496 PACKING_INSTRUCTIONS VARCHAR2(2000),
497 PARTIAL_SHIPMENTS_ALLOWED VARCHAR2(1),
498 PAYMENT_TERM_ID NUMBER,
499 PAYMENT_TERM VARCHAR2(30),
500 PO_ATTRIBUTE_1 VARCHAR2(240),
501 PO_ATTRIBUTE_2 VARCHAR2(240),
502 PO_ATTRIBUTE_3 VARCHAR2(240),
503 PO_ATTRIBUTE_4 VARCHAR2(240),
504 PO_ATTRIBUTE_5 VARCHAR2(240),
505 PO_ATTRIBUTE_6 VARCHAR2(240),
506 PO_ATTRIBUTE_7 VARCHAR2(240),
507 PO_ATTRIBUTE_8 VARCHAR2(240),
508 PO_ATTRIBUTE_9 VARCHAR2(240),
509 PO_ATTRIBUTE_10 VARCHAR2(240),
510 PO_ATTRIBUTE_11 VARCHAR2(240),
511 PO_ATTRIBUTE_12 VARCHAR2(240),
512 PO_ATTRIBUTE_13 VARCHAR2(240),
513 PO_ATTRIBUTE_14 VARCHAR2(240),
514 PO_ATTRIBUTE_15 VARCHAR2(240),
515 PO_REVISION_DATE DATE,
516 PROGRAM VARCHAR2(30),
517 PROGRAM_APPLICATION VARCHAR2(30),
518 PROGRAM_APPLICATION_ID NUMBER,
519 PROGRAM_ID NUMBER,
520 PROGRAM_UPDATE_DATE DATE,
521 RELATED_PO_NUMBER VARCHAR2(50),
522 REMAINDER_ORDERS_ALLOWED VARCHAR2(1),
523 REQUEST_DATE DATE,
524 REQUEST_ID NUMBER,
525 RETURN_REASON_CODE VARCHAR2(30),
526 SALESREP_ID NUMBER,
527 SALESREP VARCHAR2(240),
528 SHIP_TO_ADDRESS_1 VARCHAR2(240),
529 SHIP_TO_ADDRESS_2 VARCHAR2(240),
530 SHIP_TO_ADDRESS_3 VARCHAR2(240),
531 SHIP_TO_ADDRESS_4 VARCHAR2(240),
532 SHIP_TO_CITY VARCHAR2(240),
533 SHIP_TO_CONTACT VARCHAR2(330),
534 SHIP_TO_CONTACT_FIRST_NAME VARCHAR2(240),
535 SHIP_TO_CONTACT_ID NUMBER,
536 SHIP_TO_CONTACT_LAST_NAME VARCHAR2(240),
537 SHIP_TO_COUNTRY VARCHAR2(240),
538 SHIP_TO_COUNTY VARCHAR2(240),
539 SHIP_TO_CUSTOMER VARCHAR2(360),
540 SHIP_TO_CUSTOMER_NUMBER VARCHAR2(50),
541 SHIP_TO_POSTAL_CODE VARCHAR2(240),
542 FIRST_ACK_CODE VARCHAR2(30),
543 LAST_ACK_CODE VARCHAR2(30),
544 FIRST_ACK_DATE DATE,
545 LAST_ACK_DATE DATE,
546 BUYER_SELLER_FLAG VARCHAR2(1),
547 CREATED_BY NUMBER,
548 CREATION_DATE DATE,
549 LAST_UPDATE_DATE DATE,
550 LAST_UPDATE_LOGIN NUMBER,
551 LAST_UPDATED_BY NUMBER,
552 BOOKED_FLAG VARCHAR2(1),
553 AGREEMENT_ID NUMBER,
554 AGREEMENT VARCHAR2(240),
555 AGREEMENT_NAME VARCHAR2(30),
556 CONTEXT VARCHAR2(30),
557 PRICE_LIST VARCHAR2(240),
558 PRICE_LIST_ID NUMBER,
559 PRICING_DATE DATE,
560 SHIP_FROM_ORG_ID NUMBER,
561 SHIP_FROM_ORG VARCHAR2(240),
562 SHIP_TO_ORG_ID NUMBER,
563 SHIP_TO_ORG VARCHAR2(240),
564 SOLD_FROM_ORG VARCHAR2(240),
565 SOLD_FROM_ORG_ID NUMBER,
566 SOLD_TO_ORG VARCHAR2(360),
567 SOLD_TO_ORG_ID NUMBER,
568 ATTRIBUTE1 VARCHAR2(240),
569 ATTRIBUTE2 VARCHAR2(240),
570 ATTRIBUTE3 VARCHAR2(240),
571 ATTRIBUTE4 VARCHAR2(240),
575 ATTRIBUTE8 VARCHAR2(240),
572 ATTRIBUTE5 VARCHAR2(240),
573 ATTRIBUTE6 VARCHAR2(240),
574 ATTRIBUTE7 VARCHAR2(240),
576 ATTRIBUTE9 VARCHAR2(240),
577 ATTRIBUTE10 VARCHAR2(240),
578 ATTRIBUTE11 VARCHAR2(240),
579 ATTRIBUTE12 VARCHAR2(240),
580 ATTRIBUTE13 VARCHAR2(240),
581 ATTRIBUTE14 VARCHAR2(240),
582 ATTRIBUTE15 VARCHAR2(240),
583 CANCELLED_FLAG VARCHAR2(1),
584 CLOSED_FLAG VARCHAR2(1),
585 CONVERSION_RATE NUMBER,
586 CONVERSION_RATE_DATE DATE,
587 CONVERSION_TYPE VARCHAR2(30),
588 CONVERSION_TYPE_CODE VARCHAR2(30),
589 CUST_PO_NUMBER VARCHAR2(50),
590 CUSTOMER_ID NUMBER,
591 CUSTOMER_NAME VARCHAR2(360),
592 CUSTOMER_NUMBER VARCHAR2(30),
593 DELIVER_TO_CONTACT VARCHAR2(330),
594 DELIVER_TO_CONTACT_ID NUMBER,
595 DELIVER_TO_CUSTOMER VARCHAR2(360),
596 DELIVER_TO_CUSTOMER_NUMBER VARCHAR2(50),
597 DELIVER_TO_ORG VARCHAR2(240),
598 DELIVER_TO_ORG_ID NUMBER,
599 DEMAND_CLASS VARCHAR2(80),
600 DEMAND_CLASS_CODE VARCHAR2(30),
601 EARLIEST_SCHEDULE_LIMIT NUMBER,
602 LATEST_SCHEDULE_LIMIT NUMBER,
603 ERROR_FLAG VARCHAR2(1),
604 EXPIRATION_DATE DATE,
605 FOB_POINT VARCHAR2(240),
606 FOB_POINT_CODE VARCHAR2(30),
607 FREIGHT_CARRIER_CODE VARCHAR2(30),
608 FREIGHT_TERMS VARCHAR2(80),
609 FREIGHT_TERMS_CODE VARCHAR2(30),
610 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30),
611 GLOBAL_ATTRIBUTE1 VARCHAR2(240),
612 GLOBAL_ATTRIBUTE2 VARCHAR2(240),
613 GLOBAL_ATTRIBUTE3 VARCHAR2(240),
614 GLOBAL_ATTRIBUTE4 VARCHAR2(240),
615 GLOBAL_ATTRIBUTE5 VARCHAR2(240),
616 GLOBAL_ATTRIBUTE6 VARCHAR2(240),
617 GLOBAL_ATTRIBUTE7 VARCHAR2(240),
618 GLOBAL_ATTRIBUTE8 VARCHAR2(240),
619 GLOBAL_ATTRIBUTE9 VARCHAR2(240),
620 GLOBAL_ATTRIBUTE10 VARCHAR2(240),
621 GLOBAL_ATTRIBUTE11 VARCHAR2(240),
622 DELIVER_TO_STATE VARCHAR2(60),
623 SOLD_TO_LOCATION_STATE VARCHAR2(60),
624 SOLD_TO_LOCATION_COUNTY VARCHAR2(60),
625 SOLD_TO_LOCATION_PROVINCE VARCHAR2(60),
626 HEADER_ID NUMBER,
627 ORIG_SYS_DOCUMENT_REF VARCHAR2(50),
628 ORDER_NUMBER NUMBER,
629 ORDERED_DATE DATE,
630 ORG_ID NUMBER,
631 CHANGE_DATE DATE,
632 CHANGE_SEQUENCE VARCHAR2(50),
633 ACCOUNTING_RULE_ID NUMBER,
634 ACCOUNTING_RULE VARCHAR2(30),
635 ACKNOWLEDGMENT_FLAG VARCHAR2(1));
636
637 TYPE header_ack_tbl_type IS TABLE OF header_ack_rec_type
638 INDEX BY BINARY_INTEGER;
639
640
641 TYPE line_ack_rec_type IS RECORD
642 (END_CUSTOMER_CONTACT_LAST_NAME VARCHAR2(240),
643 END_CUSTOMER_CONTACT_FIRST_NAM VARCHAR2(240),
644 END_CUSTOMER_NAME VARCHAR2(360),
645 IB_OWNER VARCHAR2(60),
646 IB_CURRENT_LOCATION VARCHAR2(60),
647 IB_INSTALLED_AT_LOCATION VARCHAR2(60),
648 ORDER_FIRMED_DATE DATE,
649 ACTUAL_FULFILLMENT_DATE DATE,
650 COMMITMENT VARCHAR2(240),
651 CUSTOMER_PAYMENT_TERM VARCHAR2(30),
652 DELIVER_TO_ADDRESS1 VARCHAR2(240),
653 DELIVER_TO_ADDRESS2 VARCHAR2(240),
654 DELIVER_TO_ADDRESS3 VARCHAR2(240),
655 DELIVER_TO_ADDRESS4 VARCHAR2(240),
656 DELIVER_TO_CITY VARCHAR2(60),
657 DELIVER_TO_COUNTRY VARCHAR2(60),
658 DELIVER_TO_COUNTY VARCHAR2(60),
659 DELIVER_TO_POSTAL_CODE VARCHAR2(60),
660 DELIVER_TO_PROVINCE VARCHAR2(60),
661 DELIVER_TO_STATE VARCHAR2(60),
662 INVOICE_ADDRESS_1 VARCHAR2(240),
663 INVOICE_ADDRESS_2 VARCHAR2(240),
664 INVOICE_ADDRESS_3 VARCHAR2(240),
665 INVOICE_ADDRESS_4 VARCHAR2(240),
666 INVOICE_COUNTRY VARCHAR2(60),
667 INVOICE_COUNTY VARCHAR2(60),
668 INVOICE_POSTAL_CODE VARCHAR2(60),
669 INVOICE_STATE VARCHAR2(60),
670 IB_OWNER_CODE VARCHAR2(30),
671 IB_CURRENT_LOCATION_CODE VARCHAR2(30),
672 IB_INSTALLED_AT_LOCATION_CODE VARCHAR2(30),
673 CONFIG_REV_NBR NUMBER,
674 CONFIG_HEADER_ID NUMBER,
675 SHIP_FROM_ADDRESS_1 VARCHAR2(240),
676 SHIP_FROM_ADDRESS_2 VARCHAR2(240),
677 SHIP_FROM_ADDRESS_3 VARCHAR2(240),
678 SHIP_FROM_CITY VARCHAR2(60),
679 SHIP_FROM_POSTAL_CODE VARCHAR2(60),
680 SHIP_FROM_COUNTRY VARCHAR2(60),
681 SHIP_FROM_EDI_LOCATION_CODE VARCHAR2(40),
682 SHIP_FROM_REGION1 VARCHAR2(240),
683 SHIP_FROM_REGION2 VARCHAR2(240),
684 SHIP_FROM_REGION3 VARCHAR2(240),
685 SHIP_FROM_ADDRESS_ID NUMBER,
686 SHIP_TO_ADDRESS_CODE VARCHAR2(240),
687 SHIP_TO_ADDRESS_NAME VARCHAR2(360),
688 SHIP_TO_ADDRESS_ID NUMBER,
689 INVOICE_ADDRESS_CODE VARCHAR2(40),
690 INVOICE_ADDRESS_NAME VARCHAR2(360),
691 DELIVER_TO_CUSTOMER VARCHAR2(360),
692 SERVICED_LINE_ID NUMBER,
693 SERVICE_REFERENCE_ORDER VARCHAR2(50),
694 SERVICE_REFERENCE_LINE VARCHAR2(50),
695 SERVICE_REFERENCE_SYSTEM VARCHAR2(50),
696 TP_CONTEXT VARCHAR2(30),
697 TP_ATTRIBUTE1 VARCHAR2(240),
698 TP_ATTRIBUTE2 VARCHAR2(240),
699 TP_ATTRIBUTE3 VARCHAR2(240),
700 TP_ATTRIBUTE4 VARCHAR2(240),
701 TP_ATTRIBUTE5 VARCHAR2(240),
702 TP_ATTRIBUTE6 VARCHAR2(240),
703 TP_ATTRIBUTE7 VARCHAR2(240),
704 TP_ATTRIBUTE8 VARCHAR2(240),
705 TP_ATTRIBUTE9 VARCHAR2(240),
706 TP_ATTRIBUTE10 VARCHAR2(240),
707 TP_ATTRIBUTE11 VARCHAR2(240),
708 TP_ATTRIBUTE12 VARCHAR2(240),
709 TP_ATTRIBUTE13 VARCHAR2(240),
710 TP_ATTRIBUTE14 VARCHAR2(240),
711 TP_ATTRIBUTE15 VARCHAR2(240),
712 SPLIT_FROM_SHIPMENT_REF VARCHAR2(50),
713 SHIP_TO_CUSTOMER_ID NUMBER,
714 INVOICE_TO_CUSTOMER_ID NUMBER,
715 UNIT_SELLING_PRICE_PER_PQTY NUMBER,
716 DELIVER_TO_CUSTOMER_ID NUMBER,
717 SHIP_TO_CUSTOMER_NAME VARCHAR2(360),
718 SHIP_TO_CUSTOMER_NUMBER VARCHAR2(30),
719 INVOICE_TO_CUSTOMER_NAME VARCHAR2(360),
720 INVOICE_TO_CUSTOMER_NUMBER VARCHAR2(30),
721 DELIVER_TO_CUSTOMER_NAME VARCHAR2(360),
722 DELIVER_TO_CUSTOMER_NUMBER VARCHAR2(30),
723 ACCOUNTING_RULE_DURATION NUMBER,
724 ATTRIBUTE16 VARCHAR2(240),
725 ATTRIBUTE17 VARCHAR2(240),
726 ATTRIBUTE18 VARCHAR2(240),
730 USER_ITEM_DESCRIPTION VARCHAR2(1000),
727 ATTRIBUTE19 VARCHAR2(240),
728 ATTRIBUTE20 VARCHAR2(240),
729 ACKNOWLEDGMENT_TYPE VARCHAR2(30),
731 BLANKET_NUMBER NUMBER,
732 BLANKET_LINE_NUMBER NUMBER,
733 ORIGINAL_INVENTORY_ITEM_ID NUMBER,
734 ORIGINAL_ORDERED_ITEM_ID NUMBER,
735 ORIGINAL_ORDERED_ITEM VARCHAR2(2000),
736 ORDERED_ITEM VARCHAR2(2000),
737 INVOICE_INTERFACE_STATUS_CODE VARCHAR2(30),
738 PREFERRED_GRADE VARCHAR2(4),
739 ORDERED_QUANTITY2 NUMBER,
740 ORDERED_QUANTITY_UOM2 VARCHAR2(3),
741 SHIPPING_QUANTITY2 NUMBER,
742 CANCELLED_QUANTITY2 NUMBER,
743 SHIPPED_QUANTITY2 NUMBER,
744 SHIPPING_QUANTITY_UOM2 VARCHAR2(3),
745 FULFILLED_QUANTITY2 NUMBER,
746 REVENUE_AMOUNT NUMBER,
747 FULFILLMENT_DATE DATE,
748 ORIGINAL_ITEM_IDENTIFIER_TYPE VARCHAR2(30),
749 ITEM_SUBSTITUTION_TYPE_CODE VARCHAR2(30),
750 AUTO_SELECTED_QUANTITY NUMBER,
751 ORDERED_ITEM_ID NUMBER,
752 ITEM_IDENTIFIER_TYPE VARCHAR2(30),
753 END_ITEM_UNIT_NUMBER VARCHAR2(30),
754 RETURN_ATTRIBUTE13 VARCHAR2(240),
755 RETURN_ATTRIBUTE14 VARCHAR2(240),
756 RETURN_ATTRIBUTE15 VARCHAR2(240),
757 RETURN_ATTRIBUTE2 VARCHAR2(240),
758 RETURN_ATTRIBUTE3 VARCHAR2(240),
759 RETURN_ATTRIBUTE4 VARCHAR2(240),
760 RETURN_ATTRIBUTE5 VARCHAR2(240),
761 RETURN_ATTRIBUTE6 VARCHAR2(240),
762 RETURN_ATTRIBUTE7 VARCHAR2(240),
763 RETURN_ATTRIBUTE8 VARCHAR2(240),
764 RETURN_ATTRIBUTE9 VARCHAR2(240),
765 RETURN_CONTEXT VARCHAR2(30),
766 RETURN_REASON_CODE VARCHAR2(30),
767 RLA_SCHEDULE_TYPE_CODE VARCHAR2(30),
768 SALESREP_ID NUMBER,
769 SALESREP VARCHAR2(240),
770 SCHEDULE_ARRIVAL_DATE DATE,
771 SCHEDULE_SHIP_DATE DATE,
772 SCHEDULE_ITEM_DETAIL VARCHAR2(30),
773 SCHEDULE_STATUS_CODE VARCHAR2(30),
774 SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1),
775 SHIP_SET_ID NUMBER,
776 SHIP_SET_NAME VARCHAR2(30),
777 SHIP_TO_ADDRESS1 VARCHAR2(240),
778 SHIP_TO_ADDRESS2 VARCHAR2(240),
779 SHIP_TO_ADDRESS3 VARCHAR2(240),
780 SHIP_TO_ADDRESS4 VARCHAR2(240),
781 SHIP_TO_CITY VARCHAR2(60),
782 SHIP_TO_CONTACT VARCHAR2(330),
783 SHIP_TO_CONTACT_AREA_CODE1 VARCHAR2(10),
784 SHIP_TO_CONTACT_AREA_CODE2 VARCHAR2(10),
785 SHIP_TO_CONTACT_AREA_CODE3 VARCHAR2(40),
786 SHIP_TO_CONTACT_FIRST_NAME VARCHAR2(150),
787 SHIP_TO_CONTACT_ID NUMBER,
788 SHIP_TO_CONTACT_JOB_TITLE VARCHAR2(100),
789 SHIP_TO_CONTACT_LAST_NAME VARCHAR2(150),
790 SHIP_TO_COUNTRY VARCHAR2(60),
791 SHIP_TO_COUNTY VARCHAR2(60),
792 SHIP_TO_POSTAL_CODE VARCHAR2(60),
793 SHIP_TO_STATE VARCHAR2(60),
794 SHIP_TOLERANCE_ABOVE NUMBER,
795 SHIP_TOLERANCE_BELOW NUMBER,
796 SHIPMENT_NUMBER NUMBER,
797 SHIPMENT_PRIORITY VARCHAR2(80),
798 SHIPMENT_PRIORITY_CODE VARCHAR2(30),
799 SHIPPED_QUANTITY NUMBER,
800 SHIPPING_METHOD VARCHAR2(80),
801 SHIPPING_METHOD_CODE VARCHAR2(30),
802 SHIPPING_QUANTITY NUMBER,
803 SHIPPING_QUANTITY_UOM VARCHAR2(3),
804 SORT_ORDER VARCHAR2(2000),
805 SOURCE_DOCUMENT_ID NUMBER,
806 SOURCE_DOCUMENT_LINE_ID NUMBER,
807 SOURCE_DOCUMENT_TYPE_ID NUMBER,
808 SOURCE_TYPE_CODE VARCHAR2(30),
809 SPLIT_FROM_LINE_ID NUMBER,
810 SUBINVENTORY VARCHAR2(30),
811 SUBMISSION_DATETIME DATE,
812 TASK VARCHAR2(30),
813 TASK_ID NUMBER,
814 TAX VARCHAR2(50),
815 TAX_CODE VARCHAR2(50),
816 TAX_DATE DATE,
817 TAX_EXEMPT_FLAG VARCHAR2(30),
818 TAX_EXEMPT_NUMBER VARCHAR2(80),
819 TAX_EXEMPT_REASON VARCHAR2(80),
820 TAX_EXEMPT_REASON_CODE VARCHAR2(30),
821 TAX_POINT VARCHAR2(80),
822 TAX_POINT_CODE VARCHAR2(30),
823 TAX_RATE NUMBER,
824 TAX_VALUE NUMBER,
825 UNIT_LIST_PRICE NUMBER,
826 UNIT_SELLING_PRICE NUMBER,
827 VEH_CUS_ITEM_CUM_KEY_ID NUMBER,
828 VISIBLE_DEMAND_FLAG VARCHAR2(1),
829 CUSTOMER_LINE_NUMBER VARCHAR2(50),
830 CUSTOMER_SHIPMENT_NUMBER VARCHAR2(50),
831 CUSTOMER_ITEM_NET_PRICE NUMBER,
832 CUSTOMER_PAYMENT_TERM_ID NUMBER,
833 DROP_SHIP_FLAG VARCHAR2(1),
834 SPLIT_FROM_LINE_REF VARCHAR2(50),
835 SHIP_TO_EDI_LOCATION_CODE VARCHAR2(40),
836 SERVICE_TXN_REASON_CODE VARCHAR2(30),
837 SERVICE_TXN_COMMENTS VARCHAR2(2000),
838 SERVICE_DURATION NUMBER,
839 SERVICE_START_DATE DATE,
840 SERVICE_END_DATE DATE,
841 SERVICE_COTERMINATE_FLAG VARCHAR2(1),
842 SERVICE_NUMBER NUMBER,
843 SERVICE_PERIOD VARCHAR2(3),
844 SERVICE_REFERENCE_TYPE_CODE VARCHAR2(30),
845 SERVICE_REFERENCE_LINE_ID NUMBER,
846 SERVICE_REFERENCE_SYSTEM_ID NUMBER,
847 CREDIT_INVOICE_LINE_ID NUMBER,
848 SHIP_TO_PROVINCE VARCHAR2(60),
849 INVOICE_PROVINCE VARCHAR2(60),
850 BILL_TO_EDI_LOCATION_CODE VARCHAR2(40),
851 INVOICE_CITY VARCHAR2(60),
852 INVENTORY_ITEM_SEGMENT_17 VARCHAR2(240),
853 INVENTORY_ITEM_SEGMENT_18 VARCHAR2(240),
854 INVENTORY_ITEM_SEGMENT_19 VARCHAR2(240),
855 INVENTORY_ITEM_SEGMENT_2 VARCHAR2(240),
856 INVENTORY_ITEM_SEGMENT_20 VARCHAR2(240),
857 INVENTORY_ITEM_SEGMENT_3 VARCHAR2(240),
858 INVENTORY_ITEM_SEGMENT_4 VARCHAR2(240),
859 INVENTORY_ITEM_SEGMENT_5 VARCHAR2(240),
860 INVENTORY_ITEM_SEGMENT_6 VARCHAR2(240),
861 INVENTORY_ITEM_SEGMENT_7 VARCHAR2(240),
862 INVENTORY_ITEM_SEGMENT_8 VARCHAR2(240),
863 INVENTORY_ITEM_SEGMENT_9 VARCHAR2(240),
864 INVOICE_COMPLETE_FLAG VARCHAR2(1),
865 INVOICE_SET_ID NUMBER,
866 INVOICE_SET_NAME VARCHAR2(30),
867 INVOICE_NUMBER VARCHAR2(20),
868 INVOICE_TO_CONTACT VARCHAR2(330),
869 INVOICE_TO_CONTACT_ID NUMBER,
870 INVOICE_TO_ORG VARCHAR2(240),
871 INVOICE_TO_ORG_ID NUMBER,
872 INVOICE_TOLERANCE_ABOVE NUMBER,
873 INVOICE_TOLERANCE_BELOW NUMBER,
874 INVOICING_RULE VARCHAR2(30),
875 INVOICING_RULE_ID NUMBER,
876 ITEM_INPUT VARCHAR2(240),
877 ITEM_REVISION VARCHAR2(3),
878 ITEM_TYPE_CODE VARCHAR2(30),
879 LATEST_ACCEPTABLE_DATE DATE,
883 LINE_PO_CONTEXT VARCHAR2(30),
880 LINE_CATEGORY_CODE VARCHAR2(30),
881 LINE_ID NUMBER,
882 LINE_NUMBER NUMBER,
884 LINE_TYPE VARCHAR2(30),
885 LINE_TYPE_ID NUMBER,
886 LINK_TO_LINE_ID NUMBER,
887 LINK_TO_LINE_REF VARCHAR2(50),
888 LOAD_SEQ_NUMBER NUMBER,
889 LOT VARCHAR2(30),
890 MATERIAL_COST NUMBER,
891 MATERIAL_OVERHEAD_COST NUMBER,
892 MODEL_GROUP_NUMBER NUMBER,
893 OPEN_FLAG VARCHAR2(1),
894 OPERATION_CODE VARCHAR2(30),
895 OPTION_FLAG VARCHAR2(1),
896 OPTION_NUMBER NUMBER,
897 ORDER_QUANTITY_UOM VARCHAR2(3),
898 ORDER_SOURCE VARCHAR2(30),
899 ORDER_SOURCE_ID NUMBER,
900 ORDERED_QUANTITY NUMBER,
901 ORG_ID NUMBER,
902 OUTSIDE_PROCESSING_COST NUMBER,
903 ORIG_SYS_SHIPMENT_REF VARCHAR2(50),
904 OVER_SHIP_REASON_CODE VARCHAR2(30),
905 OVER_SHIP_RESOLVED_FLAG VARCHAR2(1),
906 OVERHEAD_COST NUMBER,
907 PAYMENT_TERM VARCHAR2(30),
908 PAYMENT_TERM_ID NUMBER,
909 PAYMENT_TRX VARCHAR2(30),
910 PAYMENT_TRX_ID NUMBER,
911 PLANNING_PROD_SEQ_NUM NUMBER,
912 PRICING_ATTRIBUTE1 VARCHAR2(240),
913 PRICING_ATTRIBUTE10 VARCHAR2(240),
914 PRICING_ATTRIBUTE2 VARCHAR2(240),
915 PRICING_ATTRIBUTE3 VARCHAR2(240),
916 PRICING_ATTRIBUTE4 VARCHAR2(240),
917 PRICING_ATTRIBUTE5 VARCHAR2(240),
918 PRICING_ATTRIBUTE6 VARCHAR2(240),
919 PRICING_ATTRIBUTE7 VARCHAR2(240),
920 PRICING_ATTRIBUTE8 VARCHAR2(240),
921 PRICING_ATTRIBUTE9 VARCHAR2(240),
922 PRICING_CONTEXT VARCHAR2(150),
923 PRICING_DATE DATE,
924 PRICING_QUANTITY NUMBER,
925 PRICING_QUANTITY_UOM VARCHAR2(3),
926 PROGRAM VARCHAR2(30),
927 PROGRAM_APPLICATION VARCHAR2(30),
928 PROGRAM_APPLICATION_ID NUMBER,
929 PROGRAM_ID NUMBER,
930 PROGRAM_UPDATE_DATE DATE,
931 PROJECT VARCHAR2(30),
932 PROJECT_ID NUMBER,
933 PROMISE_DATE DATE,
934 REFERENCE_HEADER VARCHAR2(30),
935 REFERENCE_HEADER_ID NUMBER,
936 REFERENCE_LINE VARCHAR2(30),
937 REFERENCE_LINE_ID NUMBER,
938 REFERENCE_TYPE VARCHAR2(30),
939 RELATED_PO_NUMBER VARCHAR2(50),
940 REQUEST_DATE DATE,
941 REQUEST_ID NUMBER,
942 RESERVED_QUANTITY NUMBER,
943 RESOURCE_COST NUMBER,
944 RETURN_ATTRIBUTE1 VARCHAR2(240),
945 RETURN_ATTRIBUTE10 VARCHAR2(240),
946 RETURN_ATTRIBUTE11 VARCHAR2(240),
947 RETURN_ATTRIBUTE12 VARCHAR2(240),
948 DELIVER_TO_CONTACT_ID NUMBER,
949 DELIVER_TO_ORG VARCHAR2(240),
950 DELIVER_TO_ORG_ID NUMBER,
951 DELIVERY_LEAD_TIME NUMBER,
952 DEMAND_BUCKET_TYPE VARCHAR2(80),
953 DEMAND_BUCKET_TYPE_CODE VARCHAR2(30),
954 DEMAND_CLASS VARCHAR2(80),
955 DEMAND_CLASS_CODE VARCHAR2(30),
956 DEMAND_STREAM VARCHAR2(30),
957 DEP_PLAN_REQUIRED_FLAG VARCHAR2(1),
958 DPW_ASSIGNED_FLAG VARCHAR2(1),
959 EARLIEST_ACCEPTABLE_DATE DATE,
960 ERROR_FLAG VARCHAR2(1),
961 EXPLOSION_DATE DATE,
962 FOB_POINT VARCHAR2(240),
963 FOB_POINT_CODE VARCHAR2(30),
964 FREIGHT_CARRIER_CODE VARCHAR2(30),
965 FREIGHT_TERMS VARCHAR2(80),
966 FREIGHT_TERMS_CODE VARCHAR2(30),
967 FULFILLED_QUANTITY NUMBER,
968 FULFILLMENT_SET_ID NUMBER,
969 FULFILLMENT_SET_NAME VARCHAR2(30),
970 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30),
971 GLOBAL_ATTRIBUTE1 VARCHAR2(240),
972 GLOBAL_ATTRIBUTE10 VARCHAR2(240),
973 GLOBAL_ATTRIBUTE11 VARCHAR2(240),
974 GLOBAL_ATTRIBUTE12 VARCHAR2(240),
975 GLOBAL_ATTRIBUTE13 VARCHAR2(240),
976 GLOBAL_ATTRIBUTE14 VARCHAR2(240),
977 GLOBAL_ATTRIBUTE15 VARCHAR2(240),
978 GLOBAL_ATTRIBUTE16 VARCHAR2(240),
979 GLOBAL_ATTRIBUTE17 VARCHAR2(240),
980 GLOBAL_ATTRIBUTE18 VARCHAR2(240),
981 GLOBAL_ATTRIBUTE19 VARCHAR2(240),
982 GLOBAL_ATTRIBUTE2 VARCHAR2(240),
983 GLOBAL_ATTRIBUTE20 VARCHAR2(240),
984 GLOBAL_ATTRIBUTE3 VARCHAR2(240),
985 GLOBAL_ATTRIBUTE4 VARCHAR2(240),
986 GLOBAL_ATTRIBUTE5 VARCHAR2(240),
987 GLOBAL_ATTRIBUTE6 VARCHAR2(240),
988 GLOBAL_ATTRIBUTE7 VARCHAR2(240),
989 GLOBAL_ATTRIBUTE8 VARCHAR2(240),
990 GLOBAL_ATTRIBUTE9 VARCHAR2(240),
991 INDUSTRY_ATTRIBUTE1 VARCHAR2(240),
992 INDUSTRY_ATTRIBUTE10 VARCHAR2(240),
993 INDUSTRY_ATTRIBUTE11 VARCHAR2(240),
994 INDUSTRY_ATTRIBUTE12 VARCHAR2(240),
995 INDUSTRY_ATTRIBUTE13 VARCHAR2(240),
996 INDUSTRY_ATTRIBUTE14 VARCHAR2(240),
997 INDUSTRY_ATTRIBUTE15 VARCHAR2(240),
998 INDUSTRY_ATTRIBUTE16 VARCHAR2(240),
999 INDUSTRY_ATTRIBUTE17 VARCHAR2(240),
1000 INDUSTRY_ATTRIBUTE18 VARCHAR2(240),
1001 INDUSTRY_ATTRIBUTE19 VARCHAR2(240),
1002 INDUSTRY_ATTRIBUTE2 VARCHAR2(240),
1003 INDUSTRY_ATTRIBUTE20 VARCHAR2(240),
1004 INDUSTRY_ATTRIBUTE21 VARCHAR2(240),
1005 INDUSTRY_ATTRIBUTE22 VARCHAR2(240),
1006 INDUSTRY_ATTRIBUTE23 VARCHAR2(240),
1007 INDUSTRY_ATTRIBUTE24 VARCHAR2(240),
1008 INDUSTRY_ATTRIBUTE25 VARCHAR2(240),
1009 INDUSTRY_ATTRIBUTE26 VARCHAR2(240),
1010 INDUSTRY_ATTRIBUTE27 VARCHAR2(240),
1011 INDUSTRY_ATTRIBUTE28 VARCHAR2(240),
1012 INDUSTRY_ATTRIBUTE29 VARCHAR2(240),
1013 INDUSTRY_ATTRIBUTE3 VARCHAR2(240),
1014 INDUSTRY_ATTRIBUTE30 VARCHAR2(240),
1015 INDUSTRY_ATTRIBUTE4 VARCHAR2(240),
1016 INDUSTRY_ATTRIBUTE5 VARCHAR2(240),
1017 INDUSTRY_ATTRIBUTE6 VARCHAR2(240),
1018 INDUSTRY_ATTRIBUTE7 VARCHAR2(240),
1019 INDUSTRY_ATTRIBUTE8 VARCHAR2(240),
1020 INDUSTRY_ATTRIBUTE9 VARCHAR2(240),
1021 INDUSTRY_CONTEXT VARCHAR2(30),
1022 INTMED_SHIP_TO_CONTACT_ID NUMBER,
1023 INTMED_SHIP_TO_ORG_ID NUMBER,
1024 INTERFACE_STATUS VARCHAR2(1000),
1025 INVENTORY_ITEM VARCHAR2(240),
1026 INVENTORY_ITEM_ID NUMBER,
1027 INVENTORY_ITEM_SEGMENT_1 VARCHAR2(240),
1028 INVENTORY_ITEM_SEGMENT_10 VARCHAR2(240),
1029 INVENTORY_ITEM_SEGMENT_11 VARCHAR2(240),
1030 INVENTORY_ITEM_SEGMENT_12 VARCHAR2(240),
1031 INVENTORY_ITEM_SEGMENT_13 VARCHAR2(240),
1032 INVENTORY_ITEM_SEGMENT_14 VARCHAR2(240),
1033 INVENTORY_ITEM_SEGMENT_15 VARCHAR2(240),
1034 INVENTORY_ITEM_SEGMENT_16 VARCHAR2(240),
1035 SHIP_TO_PARTY_NUMBER VARCHAR2(30),
1036 INVOICE_TO_PARTY_NUMBER VARCHAR2(30),
1037 DELIVER_TO_PARTY_NUMBER VARCHAR2(30),
1038 END_CUSTOMER_NUMBER VARCHAR2(50),
1039 END_CUSTOMER_PARTY_NUMBER VARCHAR2(30),
1040 END_CUSTOMER_ID NUMBER,
1041 END_CUSTOMER_CONTACT_ID NUMBER,
1042 END_CUSTOMER_SITE_USE_ID NUMBER,
1043 END_CUSTOMER_ADDRESS1 VARCHAR2(240),
1044 END_CUSTOMER_ADDRESS2 VARCHAR2(240),
1045 END_CUSTOMER_ADDRESS3 VARCHAR2(240),
1046 END_CUSTOMER_ADDRESS4 VARCHAR2(240),
1047 END_CUSTOMER_CITY VARCHAR2(60),
1048 END_CUSTOMER_POSTAL_CODE VARCHAR2(60),
1049 END_CUSTOMER_COUNTRY VARCHAR2(60),
1050 END_CUSTOMER_STATE VARCHAR2(60),
1051 END_CUSTOMER_COUNTY VARCHAR2(60),
1052 END_CUSTOMER_PROVINCE VARCHAR2(60),
1053 END_CUSTOMER_CONTACT VARCHAR2(360),
1054 SHIPPING_INSTRUCTIONS VARCHAR2(2000),
1055 PACKING_INSTRUCTIONS VARCHAR2(2000),
1056 INVOICED_QUANTITY NUMBER,
1057 REFERENCE_CUSTOMER_TRX_LINE_ID NUMBER,
1058 SPLIT_BY VARCHAR2(30),
1059 LINE_SET_ID NUMBER,
1060 UNIT_LIST_PERCENT NUMBER,
1061 UNIT_SELLING_PERCENT NUMBER,
1062 UNIT_PERCENT_BASE_PRICE NUMBER,
1063 RE_SOURCE_FLAG VARCHAR2(1),
1064 FLOW_STATUS_CODE VARCHAR2(30),
1065 UNIT_LIST_PRICE_PER_PQTY NUMBER,
1066 UNIT_SELLING_PRICE_PQTY NUMBER,
1067 ITEM_RELATIONSHIP_TYPE NUMBER,
1068 HEADER_ID NUMBER,
1069 ORIG_SYS_DOCUMENT_REF VARCHAR2(50),
1070 ORIG_SYS_LINE_REF VARCHAR2(50),
1071 CHANGE_DATE DATE,
1072 CHANGE_SEQUENCE VARCHAR2(50),
1073 ACCOUNTING_RULE VARCHAR2(30),
1074 ORDER_NUMBER NUMBER,
1075 ACCOUNTING_RULE_ID NUMBER,
1076 ACKNOWLEDGMENT_FLAG VARCHAR2(1),
1077 FIRST_ACK_CODE VARCHAR2(30),
1078 LAST_ACK_CODE VARCHAR2(30),
1079 FIRST_ACK_DATE DATE,
1080 LAST_ACK_DATE DATE,
1081 BUYER_SELLER_FLAG VARCHAR2(1),
1082 CREATED_BY NUMBER,
1083 CREATION_DATE DATE,
1084 LAST_UPDATE_DATE DATE,
1085 LAST_UPDATE_LOGIN NUMBER,
1086 LAST_UPDATED_BY NUMBER,
1087 ACTUAL_ARRIVAL_DATE DATE,
1088 ACTUAL_SHIPMENT_DATE DATE,
1089 AGREEMENT VARCHAR2(240),
1090 AGREEMENT_ID NUMBER,
1091 ARRIVAL_SET_ID NUMBER,
1092 ARRIVAL_SET_NAME VARCHAR2(30),
1093 PRICE_LIST VARCHAR2(240),
1094 PRICE_LIST_ID NUMBER,
1095 SHIP_FROM_ORG VARCHAR2(240),
1096 SHIP_FROM_ORG_ID NUMBER,
1097 SHIP_TO_ORG VARCHAR2(240),
1098 SHIP_TO_ORG_ID NUMBER,
1099 SOLD_FROM_ORG VARCHAR2(240),
1100 SOLD_FROM_ORG_ID NUMBER,
1101 SOLD_TO_ORG VARCHAR2(360),
1102 SOLD_TO_ORG_ID NUMBER,
1103 ATO_LINE_ID NUMBER,
1104 ATTRIBUTE1 VARCHAR2(240),
1105 ATTRIBUTE10 VARCHAR2(240),
1106 ATTRIBUTE11 VARCHAR2(240),
1107 ATTRIBUTE12 VARCHAR2(240),
1108 ATTRIBUTE13 VARCHAR2(240),
1109 ATTRIBUTE14 VARCHAR2(240),
1110 ATTRIBUTE15 VARCHAR2(240),
1111 ATTRIBUTE2 VARCHAR2(240),
1112 ATTRIBUTE3 VARCHAR2(240),
1113 ATTRIBUTE4 VARCHAR2(240),
1114 ATTRIBUTE5 VARCHAR2(240),
1115 ATTRIBUTE6 VARCHAR2(240),
1116 ATTRIBUTE7 VARCHAR2(240),
1117 ATTRIBUTE8 VARCHAR2(240),
1118 ATTRIBUTE9 VARCHAR2(240),
1119 AUTHORIZED_TO_SHIP_FLAG VARCHAR2(1),
1120 BOOKED_FLAG VARCHAR2(1),
1121 CALCULATE_PRICE_FLAG VARCHAR2(1),
1122 CANCELLED_FLAG VARCHAR2(1),
1123 CANCELLED_QUANTITY NUMBER,
1124 CLOSED_FLAG VARCHAR2(1),
1125 COMMITMENT_ID NUMBER,
1126 COMPONENT_CODE VARCHAR2(1000),
1127 COMPONENT_NUMBER NUMBER,
1128 COMPONENT_SEQUENCE_ID NUMBER,
1129 CONFIG_DISPLAY_SEQUENCE NUMBER,
1130 CONFIGURATION_ID NUMBER,
1131 CONFIG_LINE_REF VARCHAR2(50),
1132 TOP_MODEL_LINE_ID NUMBER,
1133 CONTEXT VARCHAR2(30),
1134 CONTRACT_PO_NUMBER VARCHAR2(150),
1135 COST_TYPE VARCHAR2(30),
1136 COST_TYPE_ID NUMBER,
1137 COSTING_DATE DATE,
1138 CUST_MODEL_SERIAL_NUMBER VARCHAR2(50),
1139 CUST_PO_NUMBER VARCHAR2(50),
1140 CUST_PRODUCTION_SEQ_NUM VARCHAR2(50),
1141 CUSTOMER_DOCK VARCHAR2(50),
1142 CUSTOMER_DOCK_CODE VARCHAR2(50),
1143 CUSTOMER_ITEM VARCHAR2(2000),
1144 CUSTOMER_ITEM_ID NUMBER,
1145 CUSTOMER_ITEM_REVISION VARCHAR2(50),
1146 CUSTOMER_JOB VARCHAR2(50),
1147 CUSTOMER_PRODUCTION_LINE VARCHAR2(50),
1148 CUSTOMER_TRX_LINE_ID NUMBER,
1149 DELIVERY_ID NUMBER,
1150 DELIVER_TO_CONTACT VARCHAR2(330));
1151
1152 TYPE line_ack_tbl_type IS TABLE OF line_ack_rec_type
1153 INDEX BY BINARY_INTEGER;
1154 -- GENESIS --
1155
1156 END OE_Acknowledgment_Pub;