[Home] [Help]
PACKAGE: APPS.PO_AUTOCREATE_TYPES
Source
1 PACKAGE PO_AUTOCREATE_TYPES AUTHID CURRENT_USER AS
2 /* $Header: PO_AUTOCREATE_TYPES.pls 120.8.12020000.3 2013/03/22 14:34:55 sbontala ship $ */
3
4
5 -- type defined for header records
6
7 TYPE headers_rec_type IS RECORD
8 (
9 -- attributes read from interface table
10 intf_header_id NUMBER,
11 draft_id NUMBER,
12 po_header_id NUMBER,
13 action VARCHAR2(30),
14 document_num VARCHAR2(30),
15 doc_type VARCHAR2(30),
16 doc_subtype VARCHAR2(30),
17 rate_type VARCHAR2(30),
18 rate_type_code VARCHAR2(30),
19 rate_date DATE,
20 rate NUMBER,
21 agent_id NUMBER,
22 agent_name VARCHAR2(2000),
23 ship_to_loc_id NUMBER,
24 ship_to_loc VARCHAR2(100),
25 bill_to_loc_id NUMBER,
26 bill_to_loc VARCHAR2(100),
27 payment_terms VARCHAR2(100),
28 terms_id NUMBER,
29 vendor_name VARCHAR2(2000),
30 vendor_num VARCHAR2(30),
31 vendor_id NUMBER,
32 vendor_site_code VARCHAR2(30),
33 vendor_site_id NUMBER,
34 vendor_contact VARCHAR2(2000),
35 vendor_contact_id NUMBER,
36 from_rfq_num VARCHAR2(30),
37 from_header_id NUMBER,
38 fob VARCHAR2(30),
39 freight_carrier VARCHAR2(30),
40 freight_term VARCHAR2(30),
41 pay_on_code VARCHAR2(30),
42 shipping_control VARCHAR2(30),
43 currency_code VARCHAR2(30),
44 quote_warning_delay NUMBER,
45 approval_required_flag VARCHAR2(1),
46 reply_date DATE,
47 approval_status VARCHAR2(30),
48 approved_date DATE,
49 from_type_lookup_code VARCHAR2(30),
50 revision_num NUMBER,
51 confirming_order_flag VARCHAR2(1),
52 acceptance_required_flag VARCHAR2(1),
53 min_release_amount NUMBER,
54 closed_code VARCHAR2(30),
55 print_count NUMBER,
56 frozen_flag VARCHAR2(1),
57 encumbrance_required_flag VARCHAR2(1),
58 vendor_doc_num VARCHAR2(30),
59 org_id NUMBER,
60 acceptance_due_date DATE,
61 amount_to_encumber NUMBER,
62 effective_date DATE,
63 expiration_date DATE,
64 po_release_id NUMBER,
65 release_num NUMBER,
66 release_date DATE,
67 revised_date DATE,
68 printed_date DATE,
69 closed_date DATE,
70 amount_agreed NUMBER,
71 amount_limit NUMBER,
72 firm_flag VARCHAR2(30),
73 gl_encumbered_date DATE,
74 gl_encumbered_period VARCHAR2(30),
75 budget_account_id NUMBER,
76 budget_account VARCHAR2(2000),
77 budget_account_segment1 VARCHAR2(30),
78 budget_account_segment2 VARCHAR2(30),
79 budget_account_segment3 VARCHAR2(30),
80 budget_account_segment4 VARCHAR2(30),
81 budget_account_segment5 VARCHAR2(30),
82 budget_account_segment6 VARCHAR2(30),
83 budget_account_segment7 VARCHAR2(30),
84 budget_account_segment8 VARCHAR2(30),
85 budget_account_segment9 VARCHAR2(30),
86 budget_account_segment10 VARCHAR2(30),
87 budget_account_segment11 VARCHAR2(30),
88 budget_account_segment12 VARCHAR2(30),
89 budget_account_segment13 VARCHAR2(30),
90 budget_account_segment14 VARCHAR2(30),
91 budget_account_segment15 VARCHAR2(30),
92 budget_account_segment16 VARCHAR2(30),
93 budget_account_segment17 VARCHAR2(30),
94 budget_account_segment18 VARCHAR2(30),
95 budget_account_segment19 VARCHAR2(30),
96 budget_account_segment20 VARCHAR2(30),
97 budget_account_segment21 VARCHAR2(30),
98 budget_account_segment22 VARCHAR2(30),
99 budget_account_segment23 VARCHAR2(30),
100 budget_account_segment24 VARCHAR2(30),
101 budget_account_segment25 VARCHAR2(30),
102 budget_account_segment26 VARCHAR2(30),
103 budget_account_segment27 VARCHAR2(30),
104 budget_account_segment28 VARCHAR2(30),
105 budget_account_segment29 VARCHAR2(30),
106 budget_account_segment30 VARCHAR2(30),
107 created_language VARCHAR2(5),
108 style_id NUMBER,
109 style_display_name VARCHAR2(2000),
110 global_agreement_flag VARCHAR2(1),
111 clm_standard_form VARCHAR2(200),
112 clm_document_format VARCHAR2(200),
113 -- standard who columns
114 last_update_date DATE,
115 last_updated_by NUMBER,
116 last_update_login NUMBER,
117 creation_date DATE,
118 created_by NUMBER,
119 request_id NUMBER,
120 program_application_id NUMBER,
121 program_id NUMBER,
122 program_update_date DATE,
123
124 -- attributes not read from interface table but exist in txn table
125 status_lookup_code VARCHAR2(30),
126 cancel_flag VARCHAR2(1),
127 vendor_order_num VARCHAR2(30),
128 quote_vendor_quote_num VARCHAR2(30),
129 doc_creation_method VARCHAR2(30),
130 quotation_class_code VARCHAR2(30),
131 approved_flag VARCHAR2(1),
132 tax_attribute_update_code VARCHAR2(30),
133 po_dist_id NUMBER,
134
135 -- attributes added for processing purpose
136 error_flag VARCHAR2(1),
137 rec_count NUMBER,
138 intf_id_index DBMS_SQL.NUMBER_TABLE,
139
140 -- vendor related attributes
141 ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE,
142 type_1099 po_vendors.type_1099%type,
143 hold_flag po_vendors.hold_flag%type,
144 invoice_currency_code po_vendors.invoice_currency_code%type,
145 receipt_required_flag po_vendors.receipt_required_flag%type,
146 num_1099 po_vendors.num_1099%type,
147 vat_registration_num po_vendors.vat_registration_num%type,
148 inspection_required_flag po_vendors.inspection_required_flag%TYPE,
149 invoice_match_option po_vendors.match_option%type := NULL,
150 clm_award_type VARCHAR2(100),
151
152 -- CLM specific attributes
153 clm_source_document_id NUMBER,
154 clm_effective_date DATE,
155 clm_vendor_offer_number VARCHAR2(400),
156 clm_award_administrator VARCHAR2(400),
157 clm_no_signed_copies_to_return NUMBER,
158 clm_min_guarantee_award_amt NUMBER,
159 clm_min_guar_award_amt_percent NUMBER,
160 clm_min_order_amount NUMBER,
161 clm_max_order_amount NUMBER,
162 clm_amount_released NUMBER,
163 clm_external_idv VARCHAR2(2000),
164
165 --umbrella program related attributes
166 umbrella_program_id NUMBER,
167 fon_ref_id NUMBER,
168 clm_contract_officer NUMBER -- bug 12987412
169 -- ATTENTION: If you are adding new attributes to this record type, see
170 -- the message above first.
171 );
172 /* bug 12987412 : While autocreating req to award, the clm_contract
173 officer was not getting defaulted.
174 If new award is creeated , default from preferences.
175 IF adding to existing award , then default from base document.*/
176
177
178
179 -- type defined for line records
180
181 TYPE lines_rec_type IS RECORD
182 (
183 -- attributes read from line interface records
184 intf_line_id_tbl PO_TBL_NUMBER,
185 intf_header_id_tbl PO_TBL_NUMBER,
186 po_header_id_tbl PO_TBL_NUMBER,
187 po_line_id_tbl PO_TBL_NUMBER,
188 action_tbl PO_TBL_VARCHAR30,
189 document_num_tbl PO_TBL_VARCHAR30,
190 item_tbl PO_TBL_VARCHAR2000,
191 vendor_product_num_tbl PO_TBL_VARCHAR30,
192 supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
193 item_id_tbl PO_TBL_NUMBER,
194 item_revision_tbl PO_TBL_VARCHAR5,
195 job_business_group_name_tbl PO_TBL_VARCHAR2000,
196 job_business_group_id_tbl PO_TBL_NUMBER,
197 job_name_tbl PO_TBL_VARCHAR2000,
198 job_id_tbl PO_TBL_NUMBER,
199 category_tbl PO_TBL_VARCHAR2000,
200 category_id_tbl PO_TBL_NUMBER,
201 ip_category_tbl PO_TBL_VARCHAR2000,
202 ip_category_id_tbl PO_TBL_NUMBER,
203 uom_code_tbl PO_TBL_VARCHAR5,
204 unit_of_measure_tbl PO_TBL_VARCHAR30,
205 line_type_tbl PO_TBL_VARCHAR30,
206 line_type_id_tbl PO_TBL_NUMBER,
207 un_number_tbl PO_TBL_VARCHAR30,
208 un_number_id_tbl PO_TBL_NUMBER,
209 hazard_class_tbl PO_TBL_VARCHAR100,
210 hazard_class_id_tbl PO_TBL_NUMBER,
211 template_name_tbl PO_TBL_VARCHAR30,
212 template_id_tbl PO_TBL_NUMBER,
213 item_desc_tbl PO_TBL_VARCHAR2000,
214 unit_price_tbl PO_TBL_NUMBER,
215 base_unit_price_tbl PO_TBL_NUMBER,
216 from_header_id_tbl PO_TBL_NUMBER,
217 from_line_id_tbl PO_TBL_NUMBER,
218 list_price_per_unit_tbl PO_TBL_NUMBER,
219 market_price_tbl PO_TBL_NUMBER,
220 capital_expense_flag_tbl PO_TBL_VARCHAR1,
221 min_release_amount_tbl PO_TBL_NUMBER,
222 allow_price_override_flag_tbl PO_TBL_VARCHAR1,
223 price_type_tbl PO_TBL_VARCHAR30,
224 price_break_lookup_code_tbl PO_TBL_VARCHAR30,
225 closed_code_tbl PO_TBL_VARCHAR30,
226 quantity_tbl PO_TBL_NUMBER,
227 line_num_tbl PO_TBL_NUMBER,
228 shipment_num_tbl PO_TBL_NUMBER,
229 price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
230 effective_date_tbl PO_TBL_DATE,
231 expiration_date_tbl PO_TBL_DATE,
232 attribute14_tbl PO_TBL_VARCHAR2000,
233 price_update_tolerance_tbl PO_TBL_NUMBER,
234 line_loc_populated_flag_tbl PO_TBL_VARCHAR1,
235 negotiated_flag_tbl PO_TBL_VARCHAR1,
236 amount_tbl PO_TBL_NUMBER,
237 contractor_last_name_tbl PO_TBL_VARCHAR2000,
238 contractor_first_name_tbl PO_TBL_VARCHAR2000,
239 over_tolerance_err_flag_tbl PO_TBL_VARCHAR30,
240 not_to_exceed_price_tbl PO_TBL_NUMBER,
241 po_release_id_tbl PO_TBL_NUMBER,
242 release_num_tbl PO_TBL_NUMBER,
243 source_shipment_id_tbl PO_TBL_NUMBER,
244 contract_num_tbl PO_TBL_VARCHAR30,
245 contract_id_tbl PO_TBL_NUMBER,
246 type_1099_tbl PO_TBL_VARCHAR30,
247 closed_by_tbl PO_TBL_NUMBER,
248 closed_date_tbl PO_TBL_DATE,
249 committed_amount_tbl PO_TBL_NUMBER,
250 qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
251 weight_uom_code_tbl PO_TBL_VARCHAR5,
252 volume_uom_code_tbl PO_TBL_VARCHAR5,
253 secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
254 secondary_quantity_tbl PO_TBL_NUMBER,
255 preferred_grade_tbl PO_TBL_VARCHAR2000,
256 process_code_tbl PO_TBL_VARCHAR30,
257 parent_interface_line_id_tbl PO_TBL_NUMBER,
258 file_line_language_tbl PO_TBL_VARCHAR5,
259 requisition_line_id_tbl PO_TBL_NUMBER,
263 clm_option_indicator_tbl PO_TBL_VARCHAR1,
260 group_line_id_tbl PO_TBL_NUMBER,
261 line_num_display_tbl PO_TBL_VARCHAR100,
262 clm_info_flag_tbl PO_TBL_VARCHAR1,
264 clm_base_line_num_tbl PO_TBL_NUMBER,
265 clm_option_num_tbl PO_TBL_NUMBER,
266 clm_option_from_date_tbl PO_TBL_DATE,
267 clm_option_to_date_tbl PO_TBL_DATE,
268 clm_funded_flag_tbl PO_TBL_VARCHAR1,
269 cost_constraint_tbl PO_TBL_VARCHAR240,
270 contract_type_tbl po_tbl_varchar240,
271 clm_idc_type_tbl po_tbl_varchar240,
272 need_by_date_tbl PO_TBL_DATE,
273 transaction_reason_code_tbl po_tbl_varchar240,
274 retainage_rate_tbl po_tbl_number,
275 consigned_flag_tbl po_tbl_varchar1,
276 oke_contract_version_id_tbl po_tbl_number,
277 oke_contract_header_id_tbl po_tbl_number,
278 note_to_vendor_tbl po_tbl_varchar2000,
279 qty_rcv_tolerance_tbl PO_TBL_NUMBER,
280 from_line_location_id_tbl po_tbl_number,
281 auction_header_id_tbl po_tbl_number,
282 auction_display_number_tbl po_tbl_varchar240,
283 auction_line_number_tbl po_tbl_number,
284 bid_number_tbl po_tbl_number,
285 bid_line_number_tbl po_tbl_number,
286 supplier_ref_number_tbl po_tbl_varchar240,
287 max_retainage_amount_tbl po_tbl_number,
288 progress_payment_rate_tbl po_tbl_number,
289 recoupment_rate_tbl po_tbl_number,
290 catalog_name_tbl po_tbl_varchar2000,
291 firm_status_lookup_code_tbl po_tbl_varchar240,
292 drop_ship_flag_tbl po_tbl_varchar1,
293 line_ship_to_org_id_tbl po_tbl_number,
294 line_ship_to_loc_id_tbl po_tbl_number,
295
296
297 -- standard who columns
298 last_updated_by_tbl PO_TBL_NUMBER,
299 last_update_date_tbl PO_TBL_DATE,
300 last_update_login_tbl PO_TBL_NUMBER,
301 creation_date_tbl PO_TBL_DATE,
302 created_by_tbl PO_TBL_NUMBER,
303 request_id_tbl PO_TBL_NUMBER,
304 program_application_id_tbl PO_TBL_NUMBER,
305 program_id_tbl PO_TBL_NUMBER,
306 program_update_date_tbl PO_TBL_DATE,
307
308 -- attributes that are in line txn table but not in interface table
309 order_type_lookup_code_tbl PO_TBL_VARCHAR30,
310 purchase_basis_tbl PO_TBL_VARCHAR30,
311 matching_basis_tbl PO_TBL_VARCHAR30,
312 unordered_flag_tbl PO_TBL_VARCHAR1,
313 cancel_flag_tbl PO_TBL_VARCHAR1,
314 quantity_committed_tbl PO_TBL_NUMBER,
315 tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
316 taxable_flag_tbl po_tbl_varchar1,
317 tax_name_tbl PO_TBL_VARCHAR30,
318 org_id_tbl po_tbl_number,
319
320 -- attributes read from the header interface record
321 draft_id_tbl PO_TBL_NUMBER,
322 hd_action_tbl PO_TBL_VARCHAR30,
323 hd_po_header_id_tbl PO_TBL_NUMBER,
324 hd_vendor_id_tbl PO_TBL_NUMBER,
325 hd_vendor_site_id_tbl PO_TBL_NUMBER,
326 hd_min_release_amount_tbl PO_TBL_NUMBER,
327 hd_start_date_tbl PO_TBL_DATE,
328 hd_end_date_tbl PO_TBL_DATE,
329 hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
330 hd_currency_code_tbl PO_TBL_VARCHAR30,
331 hd_created_language_tbl PO_TBL_VARCHAR5,
332 hd_style_id_tbl PO_TBL_NUMBER,
333 hd_rate_type_tbl PO_TBL_VARCHAR30,
334 hd_rate_date_tbl PO_TBL_DATE,
335 hd_rate_tbl PO_TBL_NUMBER,
336 hd_pcard_id_tbl po_tbl_number,
337
338 -- attributes added for item defaults type processing
339 it_list_price_per_unit_tbl po_tbl_number,
340 it_market_price_tbl po_tbl_number,
341 it_taxable_flag_tbl po_tbl_varchar1,
342 it_unit_meas_lookup_code_tbl po_tbl_varchar30,
343 it_inspect_req_flag_tbl po_tbl_varchar1,
344 it_receipt_req_flag_tbl po_tbl_varchar1,
345 it_invoice_tolerance_tbl po_tbl_number,
346 it_rcv_tolerance_tbl po_tbl_number,
347 it_secondary_uom_code_tbl po_tbl_varchar30,
348 it_grade_control_flag_tbl po_tbl_varchar1,
349
350 -- attributes for receiving controls.
351 -- The following attributes are equivalent to PO_INTERFACE_S.rcv_controls_type
352 rc_enforce_shipto_loc_code_tbl po_tbl_varchar30,
353 rc_subst_receipt_flag_tbl po_tbl_varchar1,
354 rc_receiving_routing_id_tbl po_tbl_number,
355 rc_qty_rcv_tolerance_tbl po_tbl_number,
356 rc_qty_rcv_exception_code_tbl po_tbl_varchar30,
357 rc_days_early_recpt_tbl po_tbl_number,
358 rc_days_late_recpt_tbl po_tbl_number,
359 rc_receipt_days_excep_code_tbl po_tbl_varchar30,
360
361
362
363
364
365 -- attributes added for location processing
366 create_line_loc_tbl PO_TBL_VARCHAR1,
367 destination_type_code_tbl po_tbl_varchar30,
368 dest_organization_id_tbl po_tbl_number,
369 deliver_to_loc_id_tbl po_tbl_number,
370 tax_code_id_tbl po_tbl_number,
371 txn_flow_header_id_tbl PO_TBL_NUMBER,
372 receipt_required_flag_tbl po_tbl_varchar1,
373 note_to_receiver_tbl PO_TBL_VARCHAR2000,
374 vmi_flag_tbl po_tbl_varchar1,
375 promised_date_tbl PO_TBL_DATE,
376 has_advance_flag_tbl po_tbl_varchar1,
377 advance_amount_tbl po_tbl_number,
378 poll_intf_pop_flag_tbl po_tbl_varchar1,
379 price_discount_tbl PO_TBL_NUMBER,
380 terms_id_tbl PO_TBL_NUMBER,
381 Shipment_Type_tbl po_tbl_varchar100,
382 rate_for_req_fields_tbl po_tbl_number,
383 line_loc_id_tbl po_tbl_number,
384
385 -- attributes added for uniqueness checking
386 origin_line_num_tbl PO_TBL_NUMBER,
390
387 group_num_tbl PO_TBL_NUMBER,
388 match_line_found_tbl PO_TBL_VARCHAR1,
389 line_num_unique_tbl PO_TBL_VARCHAR1,
391 -- attributes added for processing purpose
392 error_flag_tbl PO_TBL_VARCHAR1,
393 need_to_reject_flag_tbl PO_TBL_VARCHAR1,
394 allow_desc_update_flag_tbl PO_TBL_VARCHAR1,
395 rec_count NUMBER,
396 intf_id_index_tbl DBMS_SQL.NUMBER_TABLE,
397
398 -- CLM specific attributes
399 clm_min_total_amount_tbl PO_TBL_NUMBER,
400 clm_max_total_amount_tbl PO_TBL_NUMBER,
401 clm_min_total_quantity_tbl PO_TBL_NUMBER,
402 clm_max_total_quantity_tbl PO_TBL_NUMBER,
403 clm_min_order_amount_tbl PO_TBL_NUMBER,
404 clm_max_order_amount_tbl PO_TBL_NUMBER,
405 clm_min_order_quantity_tbl PO_TBL_NUMBER,
406 clm_max_order_quantity_tbl PO_TBL_NUMBER,
407 clm_total_amount_ordered_tbl PO_TBL_NUMBER,
408 clm_total_quantity_ordered_tbl PO_TBL_NUMBER,
409 clm_period_perf_end_date_tbl PO_TBL_DATE,
410 clm_period_perf_start_date_tbl PO_TBL_DATE,
411 clm_exercised_flag_tbl PO_TBL_VARCHAR1, -- Bug 9960752
412 clm_exercised_date_tbl PO_TBL_DATE, -- Bug 9960752
413 --CLM Phase4 Changes
414 clm_exhibit_name_tbl PO_TBL_VARCHAR20,
415 clm_delivery_event_code_tbl PO_TBL_VARCHAR30,
416 clm_delivery_period_tbl PO_TBL_NUMBER,
417 clm_promise_period_tbl PO_TBL_NUMBER,
418 clm_pop_duration_tbl PO_TBL_NUMBER,
419 clm_delivery_period_uom_tbl PO_TBL_VARCHAR25,
420 clm_promise_period_uom_tbl PO_TBL_VARCHAR25,
421 clm_pop_duration_uom_tbl PO_TBL_VARCHAR25
422 -- ATTENTION: If you are adding new attributes to this record type, see
423 -- the message above first.
424 );
425
426 -- type defined for line location records
427
428
429 TYPE line_locs_rec_type IS RECORD
430 (
431 -- attributes read from line location interface records
432 intf_line_loc_id_tbl PO_TBL_NUMBER,
433 intf_line_id_tbl PO_TBL_NUMBER,
434 intf_header_id_tbl PO_TBL_NUMBER,
435 shipment_num_tbl PO_TBL_NUMBER,
436 shipment_type_tbl PO_TBL_VARCHAR30,
437 line_loc_id_tbl PO_TBL_NUMBER,
438 ship_to_org_code_tbl PO_TBL_VARCHAR5,
439 ship_to_org_id_tbl PO_TBL_NUMBER,
440 ship_to_loc_tbl PO_TBL_VARCHAR100,
441 ship_to_loc_id_tbl PO_TBL_NUMBER,
442 payment_terms_tbl PO_TBL_VARCHAR100,
443 terms_id_tbl PO_TBL_NUMBER,
444 receiving_routing_tbl PO_TBL_VARCHAR30,
445 receiving_routing_id_tbl PO_TBL_NUMBER,
446 inspection_required_flag_tbl PO_TBL_VARCHAR1,
447 receipt_required_flag_tbl PO_TBL_VARCHAR1,
448 price_override_tbl PO_TBL_NUMBER,
449 qty_rcv_tolerance_tbl PO_TBL_NUMBER,
450 qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
451 enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
452 allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
453 days_early_receipt_allowed_tbl PO_TBL_NUMBER,
454 days_late_receipt_allowed_tbl PO_TBL_NUMBER,
455 receipt_days_except_code_tbl PO_TBL_VARCHAR30,
456 invoice_close_tolerance_tbl PO_TBL_NUMBER,
457 receive_close_tolerance_tbl PO_TBL_NUMBER,
458 accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
459 firm_flag_tbl PO_TBL_VARCHAR30,
460 fob_tbl PO_TBL_VARCHAR30,
461 freight_carrier_tbl PO_TBL_VARCHAR30,
462 freight_term_tbl PO_TBL_VARCHAR30,
463 need_by_date_tbl PO_TBL_DATE,
464 promised_date_tbl PO_TBL_DATE,
465 quantity_tbl PO_TBL_NUMBER,
466 start_date_tbl PO_TBL_DATE,
467 end_date_tbl PO_TBL_DATE,
468 note_to_receiver_tbl PO_TBL_VARCHAR2000,
469 price_discount_tbl PO_TBL_NUMBER,
470 secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
471 secondary_quantity_tbl PO_TBL_NUMBER,
472 preferred_grade_tbl PO_TBL_VARCHAR2000,
473 tax_code_id_tbl PO_TBL_NUMBER,
474 tax_name_tbl PO_TBL_VARCHAR30,
475 taxable_flag_tbl PO_TBL_VARCHAR1,
476 unit_of_measure_tbl PO_TBL_VARCHAR30,
477 value_basis_tbl PO_TBL_VARCHAR30,
478 matching_basis_tbl PO_TBL_VARCHAR30,
479
480 -- attributes in txn table but not in interface table
481 match_option_tbl PO_TBL_VARCHAR30,
482 txn_flow_header_id_tbl PO_TBL_NUMBER,
483 outsourced_assembly_tbl PO_TBL_NUMBER,
484 tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
485
486 -- standard who columns
487 last_updated_by_tbl PO_TBL_NUMBER,
488 last_update_date_tbl PO_TBL_DATE,
489 last_update_login_tbl PO_TBL_NUMBER,
490 creation_date_tbl PO_TBL_DATE,
491 created_by_tbl PO_TBL_NUMBER,
492 request_id_tbl PO_TBL_NUMBER,
493 program_application_id_tbl PO_TBL_NUMBER,
494 program_id_tbl PO_TBL_NUMBER,
495 program_update_date_tbl PO_TBL_DATE,
496
497 -- attributes read from the line interface record
498 ln_po_line_id_tbl PO_TBL_NUMBER,
499 ln_item_id_tbl PO_TBL_NUMBER,
500 ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
501 ln_action_tbl PO_TBL_VARCHAR30,
502 ln_unit_price_tbl PO_TBL_NUMBER,
506 ln_purchase_basis_tbl PO_TBL_VARCHAR30,
503 ln_line_type_id_tbl PO_TBL_NUMBER,
504 ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
505 ln_closed_code_tbl PO_TBL_VARCHAR30,
507 ln_matching_basis_tbl PO_TBL_VARCHAR30,
508 ln_item_revision_tbl PO_TBL_VARCHAR5,
509 ln_expiration_date_tbl PO_TBL_DATE,
510 ln_government_context_tbl PO_TBL_VARCHAR30,
511 ln_closed_reason_tbl PO_TBL_VARCHAR2000,
512 ln_closed_date_tbl PO_TBL_DATE,
513 ln_closed_by_tbl PO_TBL_NUMBER,
514 ln_from_header_id_tbl PO_TBL_NUMBER,
515 ln_from_line_id_tbl PO_TBL_NUMBER,
516 ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30,
517
518 -- attributes read from the header interface record
519 draft_id_tbl PO_TBL_NUMBER,
520 hd_po_header_id_tbl PO_TBL_NUMBER,
521 hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
522 hd_vendor_id_tbl PO_TBL_NUMBER,
523 hd_vendor_site_id_tbl PO_TBL_NUMBER,
524 hd_terms_id_tbl PO_TBL_NUMBER,
525 hd_fob_tbl PO_TBL_VARCHAR30,
526 hd_freight_carrier_tbl PO_TBL_VARCHAR30,
527 hd_freight_term_tbl PO_TBL_VARCHAR30,
528 hd_approved_flag_tbl PO_TBL_VARCHAR1,
529 hd_effective_date_tbl PO_TBL_DATE,
530 hd_expiration_date_tbl PO_TBL_DATE,
531 hd_style_id_tbl PO_TBL_NUMBER,
532
533 -- attributes added for item processing(read from line)
534 --ln_qty_rcv_tolerance_tbl PO_TBL_NUMBER,
535 ln_unit_weight_tbl PO_TBL_NUMBER,
536 ln_unit_volume_tbl PO_TBL_NUMBER,
537 ln_item_attribute_category_tbl PO_TBL_VARCHAR2000,
538 ln_item_attribute1_tbl PO_TBL_VARCHAR2000,
539 ln_item_attribute2_tbl PO_TBL_VARCHAR2000,
540 ln_item_attribute3_tbl PO_TBL_VARCHAR2000,
541 ln_item_attribute4_tbl PO_TBL_VARCHAR2000,
542 ln_item_attribute5_tbl PO_TBL_VARCHAR2000,
543 ln_item_attribute6_tbl PO_TBL_VARCHAR2000,
544 ln_item_attribute7_tbl PO_TBL_VARCHAR2000,
545 ln_item_attribute8_tbl PO_TBL_VARCHAR2000,
546 ln_item_attribute9_tbl PO_TBL_VARCHAR2000,
547 ln_item_attribute10_tbl PO_TBL_VARCHAR2000,
548 ln_item_attribute11_tbl PO_TBL_VARCHAR2000,
549 ln_item_attribute12_tbl PO_TBL_VARCHAR2000,
550 ln_item_attribute13_tbl PO_TBL_VARCHAR2000,
551 ln_item_attribute14_tbl PO_TBL_VARCHAR2000,
552 ln_item_attribute15_tbl PO_TBL_VARCHAR2000,
553 ln_item_tbl PO_TBL_VARCHAR2000,
554 ln_item_desc_tbl PO_TBL_VARCHAR2000,
555 ln_list_price_per_unit_tbl PO_TBL_NUMBER,
556 ln_market_price_tbl PO_TBL_NUMBER,
557 ln_un_number_id_tbl PO_TBL_NUMBER,
558 ln_hazard_class_id_tbl PO_TBL_NUMBER,
559 ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
560 ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
561 ln_volume_uom_code_tbl PO_TBL_VARCHAR5,
562 ln_template_id_tbl PO_TBL_NUMBER,
563 ln_category_id_tbl PO_TBL_NUMBER,
564 line_ref_index_tbl PO_TBL_NUMBER,
565
566 -- attributes added for processing purpose
567 shipment_num_unique_tbl PO_TBL_VARCHAR1,
568 error_flag_tbl PO_TBL_VARCHAR1,
569 rec_count NUMBER,
570 intf_id_index_tbl DBMS_SQL.NUMBER_TABLE
571
572 -- ATTENTION: If you are adding new attributes to this record type, see
573 -- the message above first.
574 );
575
576 -- type defined for distribution record
577
578
579 TYPE distributions_rec_type IS RECORD
580 (
581 intf_dist_id_tbl PO_TBL_NUMBER,
582 intf_header_id_tbl PO_TBL_NUMBER,
583 intf_line_id_tbl PO_TBL_NUMBER,
584 intf_line_loc_id_tbl PO_TBL_NUMBER,
585 po_dist_id_tbl PO_TBL_NUMBER,
586 dist_num_tbl PO_TBL_NUMBER,
587 deliver_to_loc_tbl PO_TBL_VARCHAR100,
588 deliver_to_loc_id_tbl PO_TBL_NUMBER,
589 deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
590 deliver_to_person_id_tbl PO_TBL_NUMBER,
591 dest_type_tbl PO_TBL_VARCHAR30,
592 dest_type_code_tbl PO_TBL_VARCHAR30,
593 dest_org_tbl PO_TBL_VARCHAR100,
594 dest_org_id_tbl PO_TBL_NUMBER,
595 wip_entity_tbl PO_TBL_VARCHAR2000,
596 wip_entity_id_tbl PO_TBL_NUMBER,
597 wip_line_code_tbl PO_TBL_VARCHAR30,
598 wip_line_id_tbl PO_TBL_NUMBER,
599 bom_resource_code_tbl PO_TBL_VARCHAR30,
600 bom_resource_id_tbl PO_TBL_NUMBER,
601 charge_account_tbl PO_TBL_VARCHAR2000,
602 charge_account_id_tbl PO_TBL_NUMBER,
603 set_of_books_id_tbl PO_TBL_NUMBER,
604 dest_charge_account_id_tbl PO_TBL_NUMBER,
605 project_accounting_context_tbl PO_TBL_VARCHAR30,
606 award_num_tbl PO_TBL_VARCHAR30,
607 award_id_tbl PO_TBL_NUMBER,
608 project_tbl PO_TBL_VARCHAR30,
609 project_id_tbl PO_TBL_NUMBER,
610 task_tbl PO_TBL_VARCHAR2000, --- Bug#16505809
611 task_id_tbl PO_TBL_NUMBER,
612 expenditure_tbl PO_TBL_VARCHAR100,
613 expenditure_type_tbl PO_TBL_VARCHAR30,
614 expenditure_org_tbl PO_TBL_VARCHAR100,
615 expenditure_org_id_tbl PO_TBL_NUMBER,
616 expenditure_item_date_tbl PO_TBL_DATE,
620 gl_encumbered_date_tbl PO_TBL_DATE,
617 end_item_unit_number_tbl PO_TBL_VARCHAR30,
618 dest_context_tbl PO_TBL_VARCHAR30,
619 encumbered_flag_tbl PO_TBL_VARCHAR1,
621 gl_encumbered_period_tbl PO_TBL_VARCHAR30,
622 variance_account_id_tbl PO_TBL_NUMBER,
623 accrual_account_id_tbl PO_TBL_NUMBER,
624 budget_account_id_tbl PO_TBL_NUMBER,
625 dest_variance_account_id_tbl PO_TBL_NUMBER,
626 dest_subinventory_tbl PO_TBL_VARCHAR30,
627 amount_ordered_tbl PO_TBL_NUMBER,
628 quantity_ordered_tbl PO_TBL_NUMBER,
629 wip_rep_schedule_id_tbl PO_TBL_NUMBER,
630 wip_operation_seq_num_tbl PO_TBL_NUMBER,
631 wip_resource_seq_num_tbl PO_TBL_NUMBER,
632 prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
633 recovery_rate_tbl PO_TBL_NUMBER,
634 tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
635 recoverable_tax_tbl PO_TBL_NUMBER,
636 nonrecoverable_tax_tbl PO_TBL_NUMBER,
637 oke_contract_line_id_tbl PO_TBL_NUMBER,
638 oke_cont_deliverable_id_tbl PO_TBL_NUMBER,
639 account_segment1_tbl PO_TBL_VARCHAR30,
640 account_segment2_tbl PO_TBL_VARCHAR30,
641 account_segment3_tbl PO_TBL_VARCHAR30,
642 account_segment4_tbl PO_TBL_VARCHAR30,
643 account_segment5_tbl PO_TBL_VARCHAR30,
644 account_segment6_tbl PO_TBL_VARCHAR30,
645 account_segment7_tbl PO_TBL_VARCHAR30,
646 account_segment8_tbl PO_TBL_VARCHAR30,
647 account_segment9_tbl PO_TBL_VARCHAR30,
648 account_segment10_tbl PO_TBL_VARCHAR30,
649 account_segment11_tbl PO_TBL_VARCHAR30,
650 account_segment12_tbl PO_TBL_VARCHAR30,
651 account_segment13_tbl PO_TBL_VARCHAR30,
652 account_segment14_tbl PO_TBL_VARCHAR30,
653 account_segment15_tbl PO_TBL_VARCHAR30,
654 account_segment16_tbl PO_TBL_VARCHAR30,
655 account_segment17_tbl PO_TBL_VARCHAR30,
656 account_segment18_tbl PO_TBL_VARCHAR30,
657 account_segment19_tbl PO_TBL_VARCHAR30,
658 account_segment20_tbl PO_TBL_VARCHAR30,
659 account_segment21_tbl PO_TBL_VARCHAR30,
660 account_segment22_tbl PO_TBL_VARCHAR30,
661 account_segment23_tbl PO_TBL_VARCHAR30,
662 account_segment24_tbl PO_TBL_VARCHAR30,
663 account_segment25_tbl PO_TBL_VARCHAR30,
664 account_segment26_tbl PO_TBL_VARCHAR30,
665 account_segment27_tbl PO_TBL_VARCHAR30,
666 account_segment28_tbl PO_TBL_VARCHAR30,
667 account_segment29_tbl PO_TBL_VARCHAR30,
668 account_segment30_tbl PO_TBL_VARCHAR30,
669 dist_attribute1_tbl PO_TBL_VARCHAR2000,
670 dist_attribute2_tbl PO_TBL_VARCHAR2000,
671 dist_attribute3_tbl PO_TBL_VARCHAR2000,
672 dist_attribute4_tbl PO_TBL_VARCHAR2000,
673 dist_attribute5_tbl PO_TBL_VARCHAR2000,
674 dist_attribute6_tbl PO_TBL_VARCHAR2000,
675 dist_attribute7_tbl PO_TBL_VARCHAR2000,
676 dist_attribute8_tbl PO_TBL_VARCHAR2000,
677 dist_attribute9_tbl PO_TBL_VARCHAR2000,
678 dist_attribute10_tbl PO_TBL_VARCHAR2000,
679 dist_attribute11_tbl PO_TBL_VARCHAR2000,
680 dist_attribute12_tbl PO_TBL_VARCHAR2000,
681 dist_attribute13_tbl PO_TBL_VARCHAR2000,
682 dist_attribute14_tbl PO_TBL_VARCHAR2000,
683 dist_attribute15_tbl PO_TBL_VARCHAR2000,
684
685 -- standard who columns
686 last_updated_by_tbl PO_TBL_NUMBER,
687 last_update_date_tbl PO_TBL_DATE,
688 last_update_login_tbl PO_TBL_NUMBER,
689 creation_date_tbl PO_TBL_DATE,
690 created_by_tbl PO_TBL_NUMBER,
691 request_id_tbl PO_TBL_NUMBER,
692 program_application_id_tbl PO_TBL_NUMBER,
693 program_id_tbl PO_TBL_NUMBER,
694 program_update_date_tbl PO_TBL_DATE,
695
696 -- attributes exist in txn table but not in interface table
697 tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
698 award_set_id_tbl PO_TBL_NUMBER,
699 org_id_tbl PO_TBL_NUMBER,
700 distribution_type_tbl PO_TBL_VARCHAR25,
701 req_distribution_id_tbl PO_TBL_NUMBER,
702
703 -- attributes read from line location record
704 loc_ship_to_org_id_tbl PO_TBL_NUMBER,
705 loc_line_loc_id_tbl PO_TBL_NUMBER,
706 loc_shipment_type_tbl PO_TBL_VARCHAR30,
707 loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
708 loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
709 loc_need_by_date_tbl PO_TBL_DATE,
710 loc_promised_date_tbl PO_TBL_DATE,
711 loc_price_override_tbl PO_TBL_NUMBER,
712 loc_outsourced_assembly_tbl PO_TBL_NUMBER,
713 loc_attribute1_tbl PO_TBL_VARCHAR2000,
714 loc_attribute2_tbl PO_TBL_VARCHAR2000,
715 loc_attribute3_tbl PO_TBL_VARCHAR2000,
716 loc_attribute4_tbl PO_TBL_VARCHAR2000,
717 loc_attribute5_tbl PO_TBL_VARCHAR2000,
718 loc_attribute6_tbl PO_TBL_VARCHAR2000,
719 loc_attribute7_tbl PO_TBL_VARCHAR2000,
720 loc_attribute8_tbl PO_TBL_VARCHAR2000,
721 loc_attribute9_tbl PO_TBL_VARCHAR2000,
722 loc_attribute10_tbl PO_TBL_VARCHAR2000,
723 loc_attribute11_tbl PO_TBL_VARCHAR2000,
724 loc_attribute12_tbl PO_TBL_VARCHAR2000,
725 loc_attribute13_tbl PO_TBL_VARCHAR2000,
726 loc_attribute14_tbl PO_TBL_VARCHAR2000,
727 loc_attribute15_tbl PO_TBL_VARCHAR2000,
728
729 -- attributes read from line record
730 ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
734 ln_line_type_id_tbl PO_TBL_NUMBER,
731 ln_purchase_basis_tbl PO_TBL_VARCHAR30,
732 ln_item_id_tbl PO_TBL_NUMBER,
733 ln_category_id_tbl PO_TBL_NUMBER,
735 ln_po_line_id_tbl PO_TBL_NUMBER,
736 ln_attribute1_tbl PO_TBL_VARCHAR2000,
737 ln_attribute2_tbl PO_TBL_VARCHAR2000,
738 ln_attribute3_tbl PO_TBL_VARCHAR2000,
739 ln_attribute4_tbl PO_TBL_VARCHAR2000,
740 ln_attribute5_tbl PO_TBL_VARCHAR2000,
741 ln_attribute6_tbl PO_TBL_VARCHAR2000,
742 ln_attribute7_tbl PO_TBL_VARCHAR2000,
743 ln_attribute8_tbl PO_TBL_VARCHAR2000,
744 ln_attribute9_tbl PO_TBL_VARCHAR2000,
745 ln_attribute10_tbl PO_TBL_VARCHAR2000,
746 ln_attribute11_tbl PO_TBL_VARCHAR2000,
747 ln_attribute12_tbl PO_TBL_VARCHAR2000,
748 ln_attribute13_tbl PO_TBL_VARCHAR2000,
749 ln_attribute14_tbl PO_TBL_VARCHAR2000,
750 ln_attribute15_tbl PO_TBL_VARCHAR2000,
751
752 -- attributes read from header record
753 draft_id_tbl PO_TBL_NUMBER,
754 hd_agent_id_tbl PO_TBL_NUMBER,
755 hd_po_header_id_tbl PO_TBL_NUMBER,
756 hd_rate_date_tbl PO_TBL_DATE,
757 hd_rate_tbl PO_TBL_NUMBER,
758 hd_type_lookup_code_tbl PO_TBL_VARCHAR30,
759 hd_vendor_id_tbl PO_TBL_NUMBER,
760 hd_attribute1_tbl PO_TBL_VARCHAR2000,
761 hd_attribute2_tbl PO_TBL_VARCHAR2000,
762 hd_attribute3_tbl PO_TBL_VARCHAR2000,
763 hd_attribute4_tbl PO_TBL_VARCHAR2000,
764 hd_attribute5_tbl PO_TBL_VARCHAR2000,
765 hd_attribute6_tbl PO_TBL_VARCHAR2000,
766 hd_attribute7_tbl PO_TBL_VARCHAR2000,
767 hd_attribute8_tbl PO_TBL_VARCHAR2000,
768 hd_attribute9_tbl PO_TBL_VARCHAR2000,
769 hd_attribute10_tbl PO_TBL_VARCHAR2000,
770 hd_attribute11_tbl PO_TBL_VARCHAR2000,
771 hd_attribute12_tbl PO_TBL_VARCHAR2000,
772 hd_attribute13_tbl PO_TBL_VARCHAR2000,
773 hd_attribute14_tbl PO_TBL_VARCHAR2000,
774 hd_attribute15_tbl PO_TBL_VARCHAR2000,
775
776 -- attributes added for processing
777 ship_to_ou_id_tbl PO_TBL_NUMBER,
778 ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
779 item_status_tbl PO_TBL_VARCHAR1,
780 gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
781 dist_num_unique_tbl PO_TBL_VARCHAR1,
782 error_flag_tbl PO_TBL_VARCHAR1,
783 rec_count NUMBER,
784
785 -- CLM specific attributes
786 clm_misc_loa PO_TBL_VARCHAR2000,
787 clm_defence_funding PO_TBL_VARCHAR30,
788 clm_fms_case_number PO_TBL_VARCHAR2000,
789 clm_agency_acct_identifier PO_TBL_VARCHAR100
790 -- ATTENTION: If you are adding new attributes to this record type, see
791 -- the message above first.
792 );
793
794
795
796
797 -- type defined for proce difference records
798
799 TYPE price_diffs_rec_type IS RECORD
800 (
801 intf_price_diff_id_tbl PO_TBL_NUMBER,
802 intf_line_id_tbl PO_TBL_NUMBER,
803 intf_header_id_tbl PO_TBL_NUMBER,
804 price_diff_num_tbl PO_TBL_NUMBER,
805 price_type_tbl PO_TBL_VARCHAR30,
806 entity_type_tbl PO_TBL_VARCHAR30,
807 entity_id_tbl PO_TBL_NUMBER,
808 multiplier_tbl PO_TBL_NUMBER,
809 min_multiplier_tbl PO_TBL_NUMBER,
810 max_multiplier_tbl PO_TBL_NUMBER,
811 enabled_flag_tbl PO_TBL_VARCHAR1,
812 process_status_tbl PO_TBL_VARCHAR30,
813
814 -- attribute read from line location
815 loc_line_loc_id_tbl PO_TBL_NUMBER,
816
817 -- attributes read from line record
818 ln_po_line_id_tbl PO_TBL_NUMBER,
819
820 -- attributes read from header record
821 draft_id_tbl PO_TBL_NUMBER,
822 hd_style_id_tbl PO_TBL_NUMBER,
823
824 -- attributes added for processing
825 error_flag_tbl PO_TBL_VARCHAR1,
826 price_diff_num_unique_tbl PO_TBL_VARCHAR1,
827 rec_count NUMBER
828
829 -- ATTENTION: If you are adding new attributes to this record type, see
830 -- the message above first.
831 );
832
833
834
835 -- type defined for attributes values records
836
837 TYPE attr_values_rec_type IS RECORD
838 (
839 -- attribute from attr_values table
840 intf_attr_values_id_tbl PO_TBL_NUMBER,
841 org_id_tbl PO_TBL_NUMBER,
842
843 -- attributes from line record
844 ln_po_line_id_tbl PO_TBL_NUMBER,
845 ln_ip_category_id_tbl PO_TBL_NUMBER,
846 ln_item_id_tbl PO_TBL_NUMBER,
847
848 -- attribute from header record
849 draft_id_tbl PO_TBL_NUMBER,
850
851 -- attributes added for processing purpose
852 attribute_values_id_tbl PO_TBL_NUMBER,
853 source_tbl DBMS_SQL.VARCHAR2_TABLE,
854 error_flag_tbl PO_TBL_VARCHAR1,
855
856 rec_count NUMBER
857
858 -- ATTENTION: If you are adding new attributes to this record type, see
859 -- the message above first.
860 );
861
862
863
864
865 -- type defined for attribute values tlp records
866
867 TYPE attr_values_tlp_rec_type IS RECORD
868 (
869 -- attribute from attr_values table
873
870 intf_attr_values_tlp_id_tbl PO_TBL_NUMBER,
871 language_tbl PO_TBL_VARCHAR5,
872 org_id_tbl PO_TBL_NUMBER,
874 -- attribute from line
875 ln_po_line_id_tbl PO_TBL_NUMBER,
876 ln_ip_category_id_tbl PO_TBL_NUMBER,
877 ln_item_id_tbl PO_TBL_NUMBER,
878 ln_item_desc_tbl PO_TBL_VARCHAR2000,
879 ln_item_long_desc_tbl PO_TBL_VARCHAR2000,
880
881 -- attribute from headers
882 draft_id_tbl PO_TBL_NUMBER,
883
884 -- attributes added for processing purpose
885 error_flag_tbl PO_TBL_VARCHAR1,
886 attribute_values_tlp_id_tbl PO_TBL_NUMBER,
887 source_tbl DBMS_SQL.VARCHAR2_TABLE,
888
889 rec_count NUMBER
890
891 -- ATTENTION: If you are adding new attributes to this record type, see
892 -- the message above first.
893 );
894
895 TYPE intf_cursor_type IS REF CURSOR;
896
897 TYPE varchar_index_tbl_type IS TABLE OF NUMBER INDEX BY VARCHAR2(30);
898
899 END PO_AUTOCREATE_TYPES;