[Home] [Help]
PACKAGE: APPS.INV_IC_ORDER_PUB
Source
1 PACKAGE INV_IC_ORDER_PUB AS
2 /* $Header: INVPICAS.pls 120.1 2005/06/23 13:55:35 appldev ship $ */
3
4 TYPE Header_Rec_Type IS RECORD
5 ( accounting_rule_id NUMBER
6 , agreement_id NUMBER
7 , attribute1 VARCHAR2(240)
8 , attribute10 VARCHAR2(240)
9 , attribute11 VARCHAR2(240)
10 , attribute12 VARCHAR2(240)
11 , attribute13 VARCHAR2(240)
12 , attribute14 VARCHAR2(240)
13 , attribute15 VARCHAR2(240)
14 , attribute2 VARCHAR2(240)
15 , attribute3 VARCHAR2(240)
16 , attribute4 VARCHAR2(240)
17 , attribute5 VARCHAR2(240)
18 , attribute6 VARCHAR2(240)
19 , attribute7 VARCHAR2(240)
20 , attribute8 VARCHAR2(240)
21 , attribute9 VARCHAR2(240)
22 , booked_flag VARCHAR2(1)
23 , cancelled_flag VARCHAR2(1)
24 , context VARCHAR2(30)
25 , conversion_rate NUMBER
26 , conversion_rate_date DATE
27 , conversion_type_code VARCHAR2(30)
28 , customer_preference_set_code VARCHAR2(30)
29 , created_by NUMBER
30 , creation_date DATE
31 , cust_po_number VARCHAR2(50)
32 , deliver_to_contact_id NUMBER
33 , deliver_to_org_id NUMBER
34 , demand_class_code VARCHAR2(30)
35 , earliest_schedule_limit NUMBER
36 , expiration_date DATE
37 , fob_point_code VARCHAR2(30)
38 , freight_carrier_code VARCHAR2(30)
39 , freight_terms_code VARCHAR2(30)
40 , global_attribute1 VARCHAR2(240)
41 , global_attribute10 VARCHAR2(240)
42 , global_attribute11 VARCHAR2(240)
43 , global_attribute12 VARCHAR2(240)
44 , global_attribute13 VARCHAR2(240)
45 , global_attribute14 VARCHAR2(240)
46 , global_attribute15 VARCHAR2(240)
47 , global_attribute16 VARCHAR2(240)
48 , global_attribute17 VARCHAR2(240)
49 , global_attribute18 VARCHAR2(240)
50 , global_attribute19 VARCHAR2(240)
51 , global_attribute2 VARCHAR2(240)
52 , global_attribute20 VARCHAR2(240)
53 , global_attribute3 VARCHAR2(240)
54 , global_attribute4 VARCHAR2(240)
55 , global_attribute5 VARCHAR2(240)
56 , global_attribute6 VARCHAR2(240)
57 , global_attribute7 VARCHAR2(240)
58 , global_attribute8 VARCHAR2(240)
59 , global_attribute9 VARCHAR2(240)
60 , global_attribute_category VARCHAR2(30)
61 , TP_CONTEXT VARCHAR2(30)
62 , TP_ATTRIBUTE1 VARCHAR2(240)
63 , TP_ATTRIBUTE2 VARCHAR2(240)
64 , TP_ATTRIBUTE3 VARCHAR2(240)
65 , TP_ATTRIBUTE4 VARCHAR2(240)
66 , TP_ATTRIBUTE5 VARCHAR2(240)
67 , TP_ATTRIBUTE6 VARCHAR2(240)
68 , TP_ATTRIBUTE7 VARCHAR2(240)
69 , TP_ATTRIBUTE8 VARCHAR2(240)
70 , TP_ATTRIBUTE9 VARCHAR2(240)
71 , TP_ATTRIBUTE10 VARCHAR2(240)
72 , TP_ATTRIBUTE11 VARCHAR2(240)
73 , TP_ATTRIBUTE12 VARCHAR2(240)
74 , TP_ATTRIBUTE13 VARCHAR2(240)
75 , TP_ATTRIBUTE14 VARCHAR2(240)
76 , TP_ATTRIBUTE15 VARCHAR2(240)
77 , header_id NUMBER
78 , invoice_to_contact_id NUMBER
79 , invoice_to_org_id NUMBER
80 , invoicing_rule_id NUMBER
81 , last_updated_by NUMBER
82 , last_update_date DATE
83 , last_update_login NUMBER
84 , latest_schedule_limit NUMBER
85 , open_flag VARCHAR2(1)
86 , order_category_code VARCHAR2(30)
87 , ordered_date DATE
88 , order_date_type_code VARCHAR2(30)
89 , order_number NUMBER
90 , order_source_id NUMBER
91 , order_type_id NUMBER
92 , org_id NUMBER
93 , orig_sys_document_ref VARCHAR2(50)
94 , partial_shipments_allowed VARCHAR2(1)
95 , payment_term_id NUMBER
96 , price_list_id NUMBER
97 , price_request_code VARCHAR2(240) --PROMOTIONS SEP/01
98 , pricing_date DATE
99 , program_application_id NUMBER
100 , program_id NUMBER
101 , program_update_date DATE
102 , request_date DATE
103 , request_id NUMBER
104 , return_reason_code VARCHAR2(30)
105 , salesrep_id NUMBER
106 , sales_channel_code VARCHAR2(30)
107 , shipment_priority_code VARCHAR2(30)
108 , shipping_method_code VARCHAR2(30)
109 , ship_from_org_id NUMBER
110 , ship_tolerance_above NUMBER
111 , ship_tolerance_below NUMBER
112 , ship_to_contact_id NUMBER
113 , ship_to_org_id NUMBER
114 , sold_from_org_id NUMBER
115 , sold_to_contact_id NUMBER
116 , sold_to_org_id NUMBER
117 , source_document_id NUMBER
118 , source_document_type_id NUMBER
119 , tax_exempt_flag VARCHAR2(30)
120 , tax_exempt_number VARCHAR2(50)
121 , tax_exempt_reason_code VARCHAR2(30)
122 , tax_point_code VARCHAR2(30)
123 , transactional_curr_code VARCHAR2(15)
124 , version_number NUMBER
125 , return_status VARCHAR2(1)
126 , db_flag VARCHAR2(1)
127 , operation VARCHAR2(30)
128 , first_ack_code VARCHAR2(30)
129 , first_ack_date DATE
130 , last_ack_code VARCHAR2(30)
131 , last_ack_date DATE
132 , change_reason VARCHAR2(30)
133 , change_comments VARCHAR2(2000)
134 , change_sequence VARCHAR2(50)
135 , change_request_code VARCHAR2(30)
136 , ready_flag VARCHAR2(1)
137 , status_flag VARCHAR2(1)
138 , force_apply_flag VARCHAR2(1)
139 , drop_ship_flag VARCHAR2(1)
140 , customer_payment_term_id NUMBER
141 , payment_type_code VARCHAR2(30)
142 , payment_amount NUMBER
143 , check_number VARCHAR2(50)
144 , credit_card_code VARCHAR2(80)
145 , credit_card_holder_name VARCHAR2(80)
146 , credit_card_number VARCHAR2(80)
147 , credit_card_expiration_date DATE
148 , credit_card_approval_code VARCHAR2(80)
149 , credit_card_approval_date DATE
150 , shipping_instructions VARCHAR2(2000)
151 , packing_instructions VARCHAR2(2000)
152 , flow_status_code VARCHAR2(30)
153 , booked_date DATE
154 , marketing_source_code_id NUMBER
155 , upgraded_flag VARCHAR2(1)
156 , lock_control NUMBER
157 , ship_to_edi_location_code VARCHAR2(40)
158 , sold_to_edi_location_code VARCHAR2(40)
159 , bill_to_edi_location_code VARCHAR2(40)
160 );
161
162 TYPE Line_Rec_Type IS RECORD
163 ( accounting_rule_id NUMBER
164 , actual_arrival_date DATE
165 , actual_shipment_date DATE
166 , agreement_id NUMBER
167 , arrival_set_id NUMBER
168 , ato_line_id NUMBER
169 , attribute1 VARCHAR2(240)
170 , attribute10 VARCHAR2(240)
171 , attribute11 VARCHAR2(240)
172 , attribute12 VARCHAR2(240)
173 , attribute13 VARCHAR2(240)
174 , attribute14 VARCHAR2(240)
175 , attribute15 VARCHAR2(240)
176 , attribute2 VARCHAR2(240)
177 , attribute3 VARCHAR2(240)
178 , attribute4 VARCHAR2(240)
179 , attribute5 VARCHAR2(240)
180 , attribute6 VARCHAR2(240)
181 , attribute7 VARCHAR2(240)
182 , attribute8 VARCHAR2(240)
183 , attribute9 VARCHAR2(240)
184 , authorized_to_ship_flag VARCHAR2(1)
185 , auto_selected_quantity NUMBER
186 , booked_flag VARCHAR2(1)
187 , cancelled_flag VARCHAR2(1)
188 , cancelled_quantity NUMBER
189 , cancelled_quantity2 NUMBER
190 , commitment_id NUMBER
191 , component_code VARCHAR2(1000)
192 , component_number NUMBER
193 , component_sequence_id NUMBER
194 , config_header_id NUMBER
195 , config_rev_nbr NUMBER
196 , config_display_sequence NUMBER
197 , configuration_id NUMBER
198 , context VARCHAR2(30)
199 , created_by NUMBER
200 , creation_date DATE
201 , credit_invoice_line_id NUMBER
202 , customer_dock_code VARCHAR2(50)
203 , customer_job VARCHAR2(50)
204 , customer_production_line VARCHAR2(50)
205 , customer_trx_line_id NUMBER
206 , cust_model_serial_number VARCHAR2(50)
207 , cust_po_number VARCHAR2(50)
208 , cust_production_seq_num VARCHAR2(50)
209 , delivery_lead_time NUMBER
210 , deliver_to_contact_id NUMBER
211 , deliver_to_org_id NUMBER
212 , demand_bucket_type_code VARCHAR2(30)
213 , demand_class_code VARCHAR2(30)
214 , dep_plan_required_flag VARCHAR2(1)
215 , earliest_acceptable_date DATE
216 , end_item_unit_number VARCHAR2(30)
217 , explosion_date DATE
218 , fob_point_code VARCHAR2(30)
219 , freight_carrier_code VARCHAR2(30)
220 , freight_terms_code VARCHAR2(30)
221 , fulfilled_quantity NUMBER
222 , fulfilled_quantity2 NUMBER
223 , global_attribute1 VARCHAR2(240)
224 , global_attribute10 VARCHAR2(240)
225 , global_attribute11 VARCHAR2(240)
226 , global_attribute12 VARCHAR2(240)
227 , global_attribute13 VARCHAR2(240)
228 , global_attribute14 VARCHAR2(240)
229 , global_attribute15 VARCHAR2(240)
230 , global_attribute16 VARCHAR2(240)
231 , global_attribute17 VARCHAR2(240)
232 , global_attribute18 VARCHAR2(240)
233 , global_attribute19 VARCHAR2(240)
234 , global_attribute2 VARCHAR2(240)
235 , global_attribute20 VARCHAR2(240)
236 , global_attribute3 VARCHAR2(240)
237 , global_attribute4 VARCHAR2(240)
238 , global_attribute5 VARCHAR2(240)
239 , global_attribute6 VARCHAR2(240)
240 , global_attribute7 VARCHAR2(240)
241 , global_attribute8 VARCHAR2(240)
242 , global_attribute9 VARCHAR2(240)
243 , global_attribute_category VARCHAR2(30)
244 , header_id NUMBER
245 , industry_attribute1 VARCHAR2(240)
246 , industry_attribute10 VARCHAR2(240)
247 , industry_attribute11 VARCHAR2(240)
248 , industry_attribute12 VARCHAR2(240)
249 , industry_attribute13 VARCHAR2(240)
250 , industry_attribute14 VARCHAR2(240)
251 , industry_attribute15 VARCHAR2(240)
252 , industry_attribute16 VARCHAR2(240)
253 , industry_attribute17 VARCHAR2(240)
254 , industry_attribute18 VARCHAR2(240)
255 , industry_attribute19 VARCHAR2(240)
256 , industry_attribute20 VARCHAR2(240)
257 , industry_attribute21 VARCHAR2(240)
258 , industry_attribute22 VARCHAR2(240)
259 , industry_attribute23 VARCHAR2(240)
260 , industry_attribute24 VARCHAR2(240)
261 , industry_attribute25 VARCHAR2(240)
262 , industry_attribute26 VARCHAR2(240)
263 , industry_attribute27 VARCHAR2(240)
264 , industry_attribute28 VARCHAR2(240)
265 , industry_attribute29 VARCHAR2(240)
266 , industry_attribute30 VARCHAR2(240)
267 , industry_attribute2 VARCHAR2(240)
268 , industry_attribute3 VARCHAR2(240)
269 , industry_attribute4 VARCHAR2(240)
270 , industry_attribute5 VARCHAR2(240)
271 , industry_attribute6 VARCHAR2(240)
272 , industry_attribute7 VARCHAR2(240)
273 , industry_attribute8 VARCHAR2(240)
274 , industry_attribute9 VARCHAR2(240)
275 , industry_context VARCHAR2(30)
276 , TP_CONTEXT VARCHAR2(30)
277 , TP_ATTRIBUTE1 VARCHAR2(240)
278 , TP_ATTRIBUTE2 VARCHAR2(240)
279 , TP_ATTRIBUTE3 VARCHAR2(240)
280 , TP_ATTRIBUTE4 VARCHAR2(240)
281 , TP_ATTRIBUTE5 VARCHAR2(240)
282 , TP_ATTRIBUTE6 VARCHAR2(240)
283 , TP_ATTRIBUTE7 VARCHAR2(240)
284 , TP_ATTRIBUTE8 VARCHAR2(240)
285 , TP_ATTRIBUTE9 VARCHAR2(240)
286 , TP_ATTRIBUTE10 VARCHAR2(240)
287 , TP_ATTRIBUTE11 VARCHAR2(240)
288 , TP_ATTRIBUTE12 VARCHAR2(240)
289 , TP_ATTRIBUTE13 VARCHAR2(240)
290 , TP_ATTRIBUTE14 VARCHAR2(240)
291 , TP_ATTRIBUTE15 VARCHAR2(240)
292 , intermed_ship_to_org_id NUMBER
293 , intermed_ship_to_contact_id NUMBER
294 , inventory_item_id NUMBER
295 , invoice_interface_status_code VARCHAR2(30)
296 , invoice_to_contact_id NUMBER
297 , invoice_to_org_id NUMBER
298 , invoicing_rule_id NUMBER
299 , ordered_item VARCHAR2(2000)
300 , item_revision VARCHAR2(3)
301 , item_type_code VARCHAR2(30)
302 , last_updated_by NUMBER
303 , last_update_date DATE
304 , last_update_login NUMBER
305 , latest_acceptable_date DATE
306 , line_category_code VARCHAR2(30)
307 , line_id NUMBER
308 , line_number NUMBER
309 , line_type_id NUMBER
310 , link_to_line_ref VARCHAR2(50)
311 , link_to_line_id NUMBER
312 , link_to_line_index NUMBER
316 , open_flag VARCHAR2(1)
313 , model_group_number NUMBER
314 , mfg_component_sequence_id NUMBER
315 , mfg_lead_time NUMBER
317 , option_flag VARCHAR2(1)
318 , option_number NUMBER
319 , ordered_quantity NUMBER
320 , ordered_quantity2 NUMBER
321 , order_quantity_uom VARCHAR2(3)
322 , ordered_quantity_uom2 VARCHAR2(3)
323 , org_id NUMBER
324 , orig_sys_document_ref VARCHAR2(50)
325 , orig_sys_line_ref VARCHAR2(50)
326 , over_ship_reason_code VARCHAR2(30)
327 , over_ship_resolved_flag VARCHAR2(1)
328 , payment_term_id NUMBER
329 , planning_priority NUMBER
330 , preferred_grade VARCHAR2(4)
331 , price_list_id NUMBER
332 , pricing_attribute1 VARCHAR2(240)
333 , pricing_attribute10 VARCHAR2(240)
334 , pricing_attribute2 VARCHAR2(240)
335 , pricing_attribute3 VARCHAR2(240)
336 , pricing_attribute4 VARCHAR2(240)
337 , pricing_attribute5 VARCHAR2(240)
338 , pricing_attribute6 VARCHAR2(240)
339 , pricing_attribute7 VARCHAR2(240)
340 , pricing_attribute8 VARCHAR2(240)
341 , pricing_attribute9 VARCHAR2(240)
342 , pricing_context VARCHAR2(240)
343 , pricing_date DATE
344 , pricing_quantity NUMBER
345 , pricing_quantity_uom VARCHAR2(3)
346 , program_application_id NUMBER
347 , program_id NUMBER
348 , program_update_date DATE
349 , project_id NUMBER
350 , promise_date DATE
351 , re_source_flag VARCHAR2(1)
352 , reference_customer_trx_line_id NUMBER
353 , reference_header_id NUMBER
354 , reference_line_id NUMBER
355 , reference_type VARCHAR2(30)
356 , request_date DATE
357 , request_id NUMBER
358 , reserved_quantity NUMBER
359 , return_attribute1 VARCHAR2(240)
360 , return_attribute10 VARCHAR2(240)
361 , return_attribute11 VARCHAR2(240)
362 , return_attribute12 VARCHAR2(240)
363 , return_attribute13 VARCHAR2(240)
364 , return_attribute14 VARCHAR2(240)
365 , return_attribute15 VARCHAR2(240)
366 , return_attribute2 VARCHAR2(240)
367 , return_attribute3 VARCHAR2(240)
368 , return_attribute4 VARCHAR2(240)
369 , return_attribute5 VARCHAR2(240)
370 , return_attribute6 VARCHAR2(240)
371 , return_attribute7 VARCHAR2(240)
372 , return_attribute8 VARCHAR2(240)
373 , return_attribute9 VARCHAR2(240)
374 , return_context VARCHAR2(30)
375 , return_reason_code VARCHAR2(30)
376 , rla_schedule_type_code VARCHAR2(30)
377 , salesrep_id NUMBER
378 , schedule_arrival_date DATE
379 , schedule_ship_date DATE
380 , schedule_action_code VARCHAR2(30)
381 , schedule_status_code VARCHAR2(30)
382 , shipment_number NUMBER
383 , shipment_priority_code VARCHAR2(30)
384 , shipped_quantity NUMBER
385 , shipped_quantity2 NUMBER
386 , shipping_interfaced_flag VARCHAR2(1)
387 , shipping_method_code VARCHAR2(30)
388 , shipping_quantity NUMBER
389 , shipping_quantity2 NUMBER
390 , shipping_quantity_uom VARCHAR2(3)
391 , shipping_quantity_uom2 VARCHAR2(3)
392 , ship_from_org_id NUMBER
393 , ship_model_complete_flag VARCHAR2(30)
394 , ship_set_id NUMBER
395 , fulfillment_set_id NUMBER
396 , ship_tolerance_above NUMBER
397 , ship_tolerance_below NUMBER
398 , ship_to_contact_id NUMBER
399 , ship_to_org_id NUMBER
400 , sold_to_org_id NUMBER
401 , sold_from_org_id NUMBER
402 , sort_order VARCHAR2(240)
403 , source_document_id NUMBER
404 , source_document_line_id NUMBER
405 , source_document_type_id NUMBER
406 , source_type_code VARCHAR2(30)
407 , split_from_line_id NUMBER
408 , task_id NUMBER
409 , tax_code VARCHAR2(50)
410 , tax_date DATE
411 , tax_exempt_flag VARCHAR2(30)
412 , tax_exempt_number VARCHAR2(50)
413 , tax_exempt_reason_code VARCHAR2(30)
414 , tax_point_code VARCHAR2(30)
415 , tax_rate NUMBER
416 , tax_value NUMBER
417 , top_model_line_ref VARCHAR2(50)
418 , top_model_line_id NUMBER
419 , top_model_line_index NUMBER
420 , unit_list_price NUMBER
421 , unit_list_price_per_pqty NUMBER
422 , unit_selling_price NUMBER
423 , unit_selling_price_per_pqty NUMBER
424 , veh_cus_item_cum_key_id NUMBER
425 , visible_demand_flag VARCHAR2(1)
426 , return_status VARCHAR2(1)
430 , first_ack_date DATE
427 , db_flag VARCHAR2(1)
428 , operation VARCHAR2(30)
429 , first_ack_code VARCHAR2(30)
431 , last_ack_code VARCHAR2(30)
432 , last_ack_date DATE
433 , change_reason VARCHAR2(30)
434 , change_comments VARCHAR2(2000)
435 , arrival_set VARCHAR2(30)
436 , ship_set VARCHAR2(30)
437 , fulfillment_set VARCHAR2(30)
438 , order_source_id NUMBER
439 , orig_sys_shipment_ref VARCHAR2(50)
440 , change_sequence VARCHAR2(50)
441 , change_request_code VARCHAR2(30)
442 , status_flag VARCHAR2(1)
443 , drop_ship_flag VARCHAR2(1)
444 , customer_line_number VARCHAR2(50)
445 , customer_shipment_number VARCHAR2(50)
446 , customer_item_net_price NUMBER
447 , customer_payment_term_id NUMBER
448 , ordered_item_id NUMBER
449 , item_identifier_type VARCHAR2(25)
450 , shipping_instructions VARCHAR2(2000)
451 , packing_instructions VARCHAR2(2000)
452 , calculate_price_flag VARCHAR2(1)
453 , invoiced_quantity NUMBER
454 , service_txn_reason_code VARCHAR2(30)
455 , service_txn_comments VARCHAR2(2000)
456 , service_duration NUMBER
457 , service_period VARCHAR2(3)
458 , service_start_date DATE
459 , service_end_date DATE
460 , service_coterminate_flag VARCHAR2(1)
461 , unit_list_percent NUMBER
462 , unit_selling_percent NUMBER
463 , unit_percent_base_price NUMBER
464 , service_number NUMBER
465 , service_reference_type_code VARCHAR2(30)
466 , service_reference_line_id NUMBER
467 , service_reference_system_id NUMBER
468 , service_ref_order_number NUMBER
469 , service_ref_line_number NUMBER
470 , service_reference_order VARCHAR2(50)
471 , service_reference_line VARCHAR2(50)
472 , service_reference_system VARCHAR2(50)
473 , service_ref_shipment_number NUMBER
474 , service_ref_option_number NUMBER
475 , service_line_index NUMBER
476 , Line_set_id NUMBER
477 , split_by VARCHAR2(240)
478 , Split_Action_Code VARCHAR2(30)
479 , shippable_flag VARCHAR2(1)
480 , model_remnant_flag VARCHAR2(1)
481 , flow_status_code VARCHAR2(30)
482 , fulfilled_flag VARCHAR2(1)
483 , fulfillment_method_code VARCHAR2(30)
484 , revenue_amount NUMBER
485 , marketing_source_code_id NUMBER
486 , fulfillment_date DATE
487 -- Non-database field that will be used ONLY in OE_Order_PVT
488 -- Is set to TRUE when the line is processed till defaulting
489 -- If the line being processed is a child (OPTION) and the parent (MODEL)
490 -- line is yet to be processed in the same call to process order,
491 -- then the processing of child (OPTION) is aborted after defaulting
492 -- and the parent (MODEL) line is processed.
493 -- Once the parent(MODEL) line has been processed, then the child(OPTION)
494 -- line is processed starting from the steps immediately after defaulting
495 -- i.e. apply attribute changes
496 , semi_processed_flag BOOLEAN
497 , upgraded_flag VARCHAR2(1)
498 , lock_control NUMBER
499 , subinventory VARCHAR2(10)
500 , split_from_line_ref VARCHAR2(50)
501 , ship_to_edi_location_code VARCHAR2(40)
502 -- The followings are attributes related to the IC
503 , IC_SHIPPING_ORG_ID NUMBER
504 , IC_SELLING_ORG_ID NUMBER
505 , PRIMARY_UOM VARCHAR2(3)
506 , IC_CUSTOMER_ID NUMBER
507 , IC_ADDRESS_ID NUMBER
508 , IC_CUSTOMER_SITE_ID NUMBER
509 , IC_CUST_TRX_TYPE_ID NUMBER
510 , IC_VENDOR_ID NUMBER
511 , IC_VENDOR_SITE_ID NUMBER
512 , IC_REVALUE_AVERAGE_FLAG VARCHAR2(1)
513 , IC_FREIGHT_CODE_COMBINATION_ID NUMBER
514 , IC_FLOW_TYPE NUMBER
515 , IC_INVENTORY_ACCRUAL_ACCT_ID NUMBER
516 , IC_EXPENSE_ACCRUAL_ACCT_ID NUMBER
517 , IC_INTERCOMPANY_COGS_ACCT_ID NUMBER
518 --
519 -- OPM INVCONV umoogala For Process-Discrete Transfers
520 -- Added following 4 columns to support Adv Pricing for Inter-Org
521 -- Transfers between process and discrete orgs.
522 --
523 , from_organization_id NUMBER
524 , to_organization_id NUMBER
525 , from_ou NUMBER
526 , to_ou NUMBER
527 );
528
529 TYPE Line_Tbl_Type IS TABLE OF Line_Rec_Type
530 INDEX BY BINARY_INTEGER;
531
532 G_HDR header_rec_type;
533 G_LINE line_rec_type;
534
535 /** The following is the global structure for Global Procurement
536 ** For Enhance Drop Ship Project (INV.FP.J Development
537 ** The global structure is has the same structure as the
538 ** PO_HEADERS_ALL and PO_LINES_ALL
539 **/
540 TYPE Proc_Header_Rec_Type IS Record
541 (
542 PO_HEADER_ID NUMBER
543 , AGENT_ID NUMBER(9)
544 , TYPE_LOOKUP_CODE VARCHAR2(25)
545 , SEGMENT1 VARCHAR2(20)
549 , SEGMENT3 VARCHAR2(20)
546 , SUMMARY_FLAG VARCHAR2(1)
547 , ENABLED_FLAG VARCHAR2(1)
548 , SEGMENT2 VARCHAR2(20)
550 , SEGMENT4 VARCHAR2(20)
551 , SEGMENT5 VARCHAR2(20)
552 , START_DATE_ACTIVE DATE
553 , END_DATE_ACTIVE DATE
554 , VENDOR_ID NUMBER
555 , VENDOR_SITE_ID NUMBER
556 , VENDOR_CONTACT_ID NUMBER
557 , SHIP_TO_LOCATION_ID NUMBER
558 , BILL_TO_LOCATION_ID NUMBER
559 , TERMS_ID NUMBER
560 , SHIP_VIA_LOOKUP_CODE VARCHAR2(25)
561 , FOB_LOOKUP_CODE VARCHAR2(25)
562 , FREIGHT_TERMS_LOOKUP_CODE VARCHAR2(25)
563 , STATUS_LOOKUP_CODE VARCHAR2(25)
564 , CURRENCY_CODE VARCHAR2(15)
565 , RATE_TYPE VARCHAR2(30)
566 , RATE_DATE DATE
567 , RATE NUMBER
568 , FROM_HEADER_ID NUMBER
569 , FROM_TYPE_LOOKUP_CODE VARCHAR2(25)
570 , START_DATE DATE
571 , END_DATE DATE
572 , BLANKET_TOTAL_AMOUNT NUMBER
573 , AUTHORIZATION_STATUS VARCHAR2(25)
574 , REVISION_NUM NUMBER
575 , REVISED_DATE DATE
576 , APPROVED_FLAG VARCHAR2(1)
577 , APPROVED_DATE DATE
578 , AMOUNT_LIMIT NUMBER
579 , MIN_RELEASE_AMOUNT NUMBER
580 , NOTE_TO_AUTHORIZER VARCHAR2(240)
581 , NOTE_TO_VENDOR VARCHAR2(240)
582 , NOTE_TO_RECEIVER VARCHAR2(240)
583 , PRINT_COUNT NUMBER
584 , PRINTED_DATE DATE
585 , VENDOR_ORDER_NUM VARCHAR2(25)
586 , CONFIRMING_ORDER_FLAG VARCHAR2(1)
587 , COMMENTS VARCHAR2(240)
588 , REPLY_DATE DATE
589 , REPLY_METHOD_LOOKUP_CODE VARCHAR2(25)
590 , RFQ_CLOSE_DATE DATE
591 , QUOTE_TYPE_LOOKUP_CODE VARCHAR2(25)
592 , QUOTATION_CLASS_CODE VARCHAR2(25)
593 , QUOTE_WARNING_DELAY_UNIT VARCHAR2(25)
594 , QUOTE_WARNING_DELAY NUMBER
595 , QUOTE_VENDOR_QUOTE_NUMBER VARCHAR2(25)
596 , ACCEPTANCE_REQUIRED_FLAG VARCHAR2(1)
597 , ACCEPTANCE_DUE_DATE DATE
598 , CLOSED_DATE DATE
599 , USER_HOLD_FLAG VARCHAR2(1)
600 , APPROVAL_REQUIRED_FLAG VARCHAR2(1)
601 , CANCEL_FLAG VARCHAR2(1)
602 , FIRM_STATUS_LOOKUP_CODE VARCHAR2(30)
603 , FIRM_DATE DATE
604 , FROZEN_FLAG VARCHAR2(1)
605 , ATTRIBUTE_CATEGORY VARCHAR2(30)
606 , ATTRIBUTE1 VARCHAR2(150)
607 , ATTRIBUTE2 VARCHAR2(150)
608 , ATTRIBUTE3 VARCHAR2(150)
609 , ATTRIBUTE4 VARCHAR2(150)
610 , ATTRIBUTE5 VARCHAR2(150)
611 , ATTRIBUTE6 VARCHAR2(150)
612 , ATTRIBUTE7 VARCHAR2(150)
613 , ATTRIBUTE8 VARCHAR2(150)
614 , ATTRIBUTE9 VARCHAR2(150)
615 , ATTRIBUTE10 VARCHAR2(150)
616 , ATTRIBUTE11 VARCHAR2(150)
617 , ATTRIBUTE12 VARCHAR2(150)
618 , ATTRIBUTE13 VARCHAR2(150)
619 , ATTRIBUTE14 VARCHAR2(150)
620 , ATTRIBUTE15 VARCHAR2(150)
621 , CLOSED_CODE VARCHAR2(25)
622 , USSGL_TRANSACTION_CODE VARCHAR2(30)
623 , GOVERNMENT_CONTEXT VARCHAR2(30)
624 , ORG_ID NUMBER
625 , SUPPLY_AGREEMENT_FLAG VARCHAR2(1)
626 , EDI_PROCESSED_FLAG VARCHAR2(1)
627 , EDI_PROCESSED_STATUS VARCHAR2(10)
628 , GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(150)
629 , GLOBAL_ATTRIBUTE1 VARCHAR2(150)
630 , GLOBAL_ATTRIBUTE2 VARCHAR2(150)
631 , GLOBAL_ATTRIBUTE3 VARCHAR2(150)
632 , GLOBAL_ATTRIBUTE4 VARCHAR2(150)
633 , GLOBAL_ATTRIBUTE5 VARCHAR2(150)
634 , GLOBAL_ATTRIBUTE6 VARCHAR2(150)
635 , GLOBAL_ATTRIBUTE7 VARCHAR2(150)
636 , GLOBAL_ATTRIBUTE8 VARCHAR2(150)
637 , GLOBAL_ATTRIBUTE9 VARCHAR2(150)
638 , GLOBAL_ATTRIBUTE10 VARCHAR2(150)
639 , GLOBAL_ATTRIBUTE11 VARCHAR2(150)
640 , GLOBAL_ATTRIBUTE12 VARCHAR2(150)
641 , GLOBAL_ATTRIBUTE13 VARCHAR2(150)
642 , GLOBAL_ATTRIBUTE14 VARCHAR2(150)
643 , GLOBAL_ATTRIBUTE15 VARCHAR2(150)
644 , GLOBAL_ATTRIBUTE16 VARCHAR2(150)
645 , GLOBAL_ATTRIBUTE17 VARCHAR2(150)
646 , GLOBAL_ATTRIBUTE18 VARCHAR2(150)
647 , GLOBAL_ATTRIBUTE19 VARCHAR2(150)
648 , GLOBAL_ATTRIBUTE20 VARCHAR2(150)
649 , INTERFACE_SOURCE_CODE VARCHAR2(25)
650 , REFERENCE_NUM VARCHAR2(25)
651 , WF_ITEM_TYPE VARCHAR2(8)
652 , WF_ITEM_KEY VARCHAR2(240)
653 , MRC_RATE_TYPE VARCHAR2(2000)
654 , MRC_RATE_DATE VARCHAR2(2000)
655 , MRC_RATE VARCHAR2(2000)
656 , PCARD_ID NUMBER(15)
657 , PRICE_UPDATE_TOLERANCE NUMBER
658 , PAY_ON_CODE VARCHAR2(25)
659 , XML_FLAG VARCHAR2(3)
660 , XML_SEND_DATE DATE
661 , XML_CHANGE_SEND_DATE DATE
665 TYPE Proc_Line_Rec_Type IS Record
662 , GLOBAL_AGREEMENT_FLAG VARCHAR2(1)
663 );
664
666 (
667 PO_LINE_ID NUMBER
668 , PO_HEADER_ID NUMBER
669 , LINE_TYPE_ID NUMBER
670 , LINE_NUM NUMBER
671 , ITEM_ID NUMBER
672 , ITEM_REVISION VARCHAR2(3)
673 , CATEGORY_ID NUMBER
674 , ITEM_DESCRIPTION VARCHAR2(240)
675 , UNIT_MEAS_LOOKUP_CODE VARCHAR2(25)
676 , QUANTITY_COMMITTED NUMBER
677 , COMMITTED_AMOUNT NUMBER
678 , ALLOW_PRICE_OVERRIDE_FLAG VARCHAR2(1)
679 , NOT_TO_EXCEED_PRICE NUMBER
680 , LIST_PRICE_PER_UNIT NUMBER
681 , UNIT_PRICE NUMBER
682 , QUANTITY NUMBER
683 , UN_NUMBER_ID NUMBER
684 , HAZARD_CLASS_ID NUMBER
685 , NOTE_TO_VENDOR VARCHAR2(480)
686 , FROM_HEADER_ID NUMBER
687 , FROM_LINE_ID NUMBER
688 , MIN_ORDER_QUANTITY NUMBER
689 , MAX_ORDER_QUANTITY NUMBER
690 , QTY_RCV_TOLERANCE NUMBER
691 , OVER_TOLERANCE_ERROR_FLAG VARCHAR2(25)
692 , MARKET_PRICE NUMBER
693 , UNORDERED_FLAG VARCHAR2(1)
694 , CLOSED_FLAG VARCHAR2(1)
695 , USER_HOLD_FLAG VARCHAR2(1)
696 , CANCEL_FLAG VARCHAR2(1)
697 , CANCELLED_BY NUMBER(9)
698 , CANCEL_DATE DATE
699 , CANCEL_REASON VARCHAR2(240)
700 , FIRM_STATUS_LOOKUP_CODE VARCHAR2(30)
701 , FIRM_DATE DATE
702 , VENDOR_PRODUCT_NUM VARCHAR2(25)
703 , CONTRACT_NUM VARCHAR2(25)
704 , TAXABLE_FLAG VARCHAR2(1)
705 , TAX_NAME VARCHAR2(15)
706 , TYPE_1099 VARCHAR2(10)
707 , CAPITAL_EXPENSE_FLAG VARCHAR2(1)
708 , NEGOTIATED_BY_PREPARER_FLAG VARCHAR2(1)
709 , ATTRIBUTE_CATEGORY VARCHAR2(30)
710 , ATTRIBUTE1 VARCHAR2(150)
711 , ATTRIBUTE2 VARCHAR2(150)
712 , ATTRIBUTE3 VARCHAR2(150)
713 , ATTRIBUTE4 VARCHAR2(150)
714 , ATTRIBUTE5 VARCHAR2(150)
715 , ATTRIBUTE6 VARCHAR2(150)
716 , ATTRIBUTE7 VARCHAR2(150)
717 , ATTRIBUTE8 VARCHAR2(150)
718 , ATTRIBUTE9 VARCHAR2(150)
719 , ATTRIBUTE10 VARCHAR2(150)
720 , REFERENCE_NUM VARCHAR2(25)
721 , ATTRIBUTE11 VARCHAR2(150)
722 , ATTRIBUTE12 VARCHAR2(150)
723 , ATTRIBUTE13 VARCHAR2(150)
724 , ATTRIBUTE14 VARCHAR2(150)
725 , ATTRIBUTE15 VARCHAR2(150)
726 , MIN_RELEASE_AMOUNT NUMBER
727 , PRICE_TYPE_LOOKUP_CODE VARCHAR2(25)
728 , CLOSED_CODE VARCHAR2(25)
729 , PRICE_BREAK_LOOKUP_CODE VARCHAR2(25)
730 , USSGL_TRANSACTION_CODE VARCHAR2(30)
731 , GOVERNMENT_CONTEXT VARCHAR2(30)
732 , CLOSED_DATE DATE
733 , CLOSED_REASON VARCHAR2(240)
734 , CLOSED_BY NUMBER(9)
735 , TRANSACTION_REASON_CODE VARCHAR2(25)
736 , ORG_ID NUMBER
737 , QC_GRADE VARCHAR2(25)
738 , BASE_UOM VARCHAR2(25)
739 , BASE_QTY NUMBER
740 , SECONDARY_UOM VARCHAR2(25)
741 , SECONDARY_QTY NUMBER
742 , GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(150)
743 , GLOBAL_ATTRIBUTE1 VARCHAR2(150)
744 , GLOBAL_ATTRIBUTE2 VARCHAR2(150)
745 , GLOBAL_ATTRIBUTE3 VARCHAR2(150)
746 , GLOBAL_ATTRIBUTE4 VARCHAR2(150)
747 , GLOBAL_ATTRIBUTE5 VARCHAR2(150)
748 , GLOBAL_ATTRIBUTE6 VARCHAR2(150)
749 , GLOBAL_ATTRIBUTE7 VARCHAR2(150)
750 , GLOBAL_ATTRIBUTE8 VARCHAR2(150)
751 , GLOBAL_ATTRIBUTE9 VARCHAR2(150)
752 , GLOBAL_ATTRIBUTE10 VARCHAR2(150)
753 , GLOBAL_ATTRIBUTE11 VARCHAR2(150)
754 , GLOBAL_ATTRIBUTE12 VARCHAR2(150)
755 , GLOBAL_ATTRIBUTE13 VARCHAR2(150)
756 , GLOBAL_ATTRIBUTE14 VARCHAR2(150)
757 , GLOBAL_ATTRIBUTE15 VARCHAR2(150)
758 , GLOBAL_ATTRIBUTE16 VARCHAR2(150)
759 , GLOBAL_ATTRIBUTE17 VARCHAR2(150)
760 , GLOBAL_ATTRIBUTE18 VARCHAR2(150)
761 , GLOBAL_ATTRIBUTE19 VARCHAR2(150)
762 , GLOBAL_ATTRIBUTE20 VARCHAR2(150)
763 , LINE_REFERENCE_NUM VARCHAR2(25)
764 , PROJECT_ID NUMBER
765 , TASK_ID NUMBER
766 , EXPIRATION_DATE DATE
767 , TAX_CODE_ID NUMBER
768 , OKE_CONTRACT_HEADER_ID NUMBER
769 , OKE_CONTRACT_VERSION_ID NUMBER
770 , SECONDARY_QUANTITY NUMBER
771 , SECONDARY_UNIT_OF_MEASURE VARCHAR2(25)
772 , PREFERRED_GRADE VARCHAR2(25)
773 , AUCTION_HEADER_ID NUMBER
774 , AUCTION_DISPLAY_NUMBER VARCHAR2(40)
775 , AUCTION_LINE_NUMBER NUMBER
776 , BID_NUMBER NUMBER
777 , BID_LINE_NUMBER NUMBER
778 , calculate_price_flag VARCHAR2(1)
779 -- The followings are attributes related to the IC
780 , IC_PROCURING_ORG_ID NUMBER
781 , IC_RECEIVING_ORG_ID NUMBER
782 , PRIMARY_UOM VARCHAR2(3)
786 , IC_CUST_TRX_TYPE_ID NUMBER
783 , IC_CUSTOMER_ID NUMBER
784 , IC_ADDRESS_ID NUMBER
785 , IC_CUSTOMER_SITE_ID NUMBER
787 , IC_VENDOR_ID NUMBER
788 , IC_VENDOR_SITE_ID NUMBER
789 , IC_REVALUE_AVERAGE_FLAG VARCHAR2(1)
790 , IC_FREIGHT_CODE_COMBINATION_ID NUMBER
791 , IC_FLOW_TYPE NUMBER
792 , IC_INVENTORY_ACCRUAL_ACCT_ID NUMBER
793 , IC_EXPENSE_ACCRUAL_ACCT_ID NUMBER
794 , IC_INTERCOMPANY_COGS_ACCT_ID NUMBER
795 );
796
797 TYPE Proc_Line_Tbl_Type IS TABLE OF Proc_Line_Rec_Type INDEX BY BINARY_INTEGER;
798
799 G_PROC_HDR Proc_Header_Rec_Type;
800 G_PROC_LINE Proc_Line_Rec_Type;
801
802
803 END INV_IC_ORDER_PUB;
804