[Home] [Help]
PACKAGE: APPS.PO_PDOI_TYPES
Source
1 PACKAGE PO_PDOI_TYPES AS
2 /* $Header: PO_PDOI_TYPES.pls 120.25 2006/09/15 21:58:23 jinwang noship $ */
3
4 -- type defined for header records
5
6 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
7 -- that the procedure fill_all_headers_attr is also changed to init
8 -- the table
9 TYPE headers_rec_type IS RECORD
10 (
11 -- attributes read from interface table
12 intf_header_id_tbl PO_TBL_NUMBER,
13 draft_id_tbl PO_TBL_NUMBER,
14 po_header_id_tbl PO_TBL_NUMBER,
15 action_tbl PO_TBL_VARCHAR30,
16 document_num_tbl PO_TBL_VARCHAR30,
17 doc_type_tbl PO_TBL_VARCHAR30,
18 doc_subtype_tbl PO_TBL_VARCHAR30,
19 rate_type_tbl PO_TBL_VARCHAR30,
20 rate_type_code_tbl PO_TBL_VARCHAR30,
21 rate_date_tbl PO_TBL_DATE,
22 rate_tbl PO_TBL_NUMBER,
23 agent_id_tbl PO_TBL_NUMBER,
24 agent_name_tbl PO_TBL_VARCHAR2000,
25 ship_to_loc_id_tbl PO_TBL_NUMBER,
26 ship_to_loc_tbl PO_TBL_VARCHAR100,
27 bill_to_loc_id_tbl PO_TBL_NUMBER,
28 bill_to_loc_tbl PO_TBL_VARCHAR100,
29 payment_terms_tbl PO_TBL_VARCHAR100,
30 terms_id_tbl PO_TBL_NUMBER,
31 vendor_name_tbl PO_TBL_VARCHAR2000,
32 vendor_num_tbl PO_TBL_VARCHAR30,
33 vendor_id_tbl PO_TBL_NUMBER,
34 vendor_site_code_tbl PO_TBL_VARCHAR30,
35 vendor_site_id_tbl PO_TBL_NUMBER,
36 vendor_contact_tbl PO_TBL_VARCHAR2000,
37 vendor_contact_id_tbl PO_TBL_NUMBER,
38 from_rfq_num_tbl PO_TBL_VARCHAR30,
39 from_header_id_tbl PO_TBL_NUMBER,
40 fob_tbl PO_TBL_VARCHAR30,
41 freight_carrier_tbl PO_TBL_VARCHAR30,
42 freight_term_tbl PO_TBL_VARCHAR30,
43 pay_on_code_tbl PO_TBL_VARCHAR30,
44 shipping_control_tbl PO_TBL_VARCHAR30,
45 currency_code_tbl PO_TBL_VARCHAR30,
46 quote_warning_delay_tbl PO_TBL_NUMBER,
47 approval_required_flag_tbl PO_TBL_VARCHAR1,
48 reply_date_tbl PO_TBL_DATE,
49 approval_status_tbl PO_TBL_VARCHAR30,
50 approved_date_tbl PO_TBL_DATE,
51 from_type_lookup_code_tbl PO_TBL_VARCHAR30,
52 revision_num_tbl PO_TBL_NUMBER,
53 confirming_order_flag_tbl PO_TBL_VARCHAR1,
54 acceptance_required_flag_tbl PO_TBL_VARCHAR1,
55 min_release_amount_tbl PO_TBL_NUMBER,
56 closed_code_tbl PO_TBL_VARCHAR30,
57 print_count_tbl PO_TBL_NUMBER,
58 frozen_flag_tbl PO_TBL_VARCHAR1,
59 encumbrance_required_flag_tbl PO_TBL_VARCHAR1,
60 vendor_doc_num_tbl PO_TBL_VARCHAR30,
61 org_id_tbl PO_TBL_NUMBER,
62 acceptance_due_date_tbl PO_TBL_DATE,
63 amount_to_encumber_tbl PO_TBL_NUMBER,
64 effective_date_tbl PO_TBL_DATE,
65 expiration_date_tbl PO_TBL_DATE,
66 po_release_id_tbl PO_TBL_NUMBER,
67 release_num_tbl PO_TBL_NUMBER,
68 release_date_tbl PO_TBL_DATE,
69 revised_date_tbl PO_TBL_DATE,
70 printed_date_tbl PO_TBL_DATE,
71 closed_date_tbl PO_TBL_DATE,
72 amount_agreed_tbl PO_TBL_NUMBER,
73 amount_limit_tbl PO_TBL_NUMBER, -- bug5352625
74 firm_flag_tbl PO_TBL_VARCHAR30,
75 gl_encumbered_date_tbl PO_TBL_DATE,
76 gl_encumbered_period_tbl PO_TBL_VARCHAR30,
77 budget_account_id_tbl PO_TBL_NUMBER,
78 budget_account_tbl PO_TBL_VARCHAR2000,
79 budget_account_segment1_tbl PO_TBL_VARCHAR30,
80 budget_account_segment2_tbl PO_TBL_VARCHAR30,
81 budget_account_segment3_tbl PO_TBL_VARCHAR30,
82 budget_account_segment4_tbl PO_TBL_VARCHAR30,
83 budget_account_segment5_tbl PO_TBL_VARCHAR30,
84 budget_account_segment6_tbl PO_TBL_VARCHAR30,
85 budget_account_segment7_tbl PO_TBL_VARCHAR30,
86 budget_account_segment8_tbl PO_TBL_VARCHAR30,
87 budget_account_segment9_tbl PO_TBL_VARCHAR30,
88 budget_account_segment10_tbl PO_TBL_VARCHAR30,
89 budget_account_segment11_tbl PO_TBL_VARCHAR30,
90 budget_account_segment12_tbl PO_TBL_VARCHAR30,
91 budget_account_segment13_tbl PO_TBL_VARCHAR30,
92 budget_account_segment14_tbl PO_TBL_VARCHAR30,
93 budget_account_segment15_tbl PO_TBL_VARCHAR30,
94 budget_account_segment16_tbl PO_TBL_VARCHAR30,
95 budget_account_segment17_tbl PO_TBL_VARCHAR30,
96 budget_account_segment18_tbl PO_TBL_VARCHAR30,
97 budget_account_segment19_tbl PO_TBL_VARCHAR30,
98 budget_account_segment20_tbl PO_TBL_VARCHAR30,
99 budget_account_segment21_tbl PO_TBL_VARCHAR30,
100 budget_account_segment22_tbl PO_TBL_VARCHAR30,
101 budget_account_segment23_tbl PO_TBL_VARCHAR30,
102 budget_account_segment24_tbl PO_TBL_VARCHAR30,
103 budget_account_segment25_tbl PO_TBL_VARCHAR30,
104 budget_account_segment26_tbl PO_TBL_VARCHAR30,
105 budget_account_segment27_tbl PO_TBL_VARCHAR30,
106 budget_account_segment28_tbl PO_TBL_VARCHAR30,
107 budget_account_segment29_tbl PO_TBL_VARCHAR30,
108 budget_account_segment30_tbl PO_TBL_VARCHAR30,
109 created_language_tbl PO_TBL_VARCHAR5,
110 style_id_tbl PO_TBL_NUMBER,
111 style_display_name_tbl PO_TBL_VARCHAR2000,
112 global_agreement_flag_tbl PO_TBL_VARCHAR1,
113
114 -- standard who columns
115 last_update_date_tbl PO_TBL_DATE,
116 last_updated_by_tbl PO_TBL_NUMBER,
117 last_update_login_tbl PO_TBL_NUMBER,
118 creation_date_tbl PO_TBL_DATE,
119 created_by_tbl PO_TBL_NUMBER,
120 request_id_tbl PO_TBL_NUMBER,
121 program_application_id_tbl PO_TBL_NUMBER,
122 program_id_tbl PO_TBL_NUMBER,
123 program_update_date_tbl PO_TBL_DATE,
124
125 -- attributes not read from interface table but exist in txn table
126 status_lookup_code_tbl PO_TBL_VARCHAR30,
127 cancel_flag_tbl PO_TBL_VARCHAR1,
128 vendor_order_num_tbl PO_TBL_VARCHAR30,
129 quote_vendor_quote_num_tbl PO_TBL_VARCHAR30,
130 doc_creation_method_tbl PO_TBL_VARCHAR30,
131 quotation_class_code_tbl PO_TBL_VARCHAR30,
132 approved_flag_tbl PO_TBL_VARCHAR1,
133 tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
134 po_dist_id_tbl PO_TBL_NUMBER,
135
136 -- attributes added for processing purpose
137 error_flag_tbl PO_TBL_VARCHAR1,
138 rec_count NUMBER,
139 intf_id_index_tbl DBMS_SQL.NUMBER_TABLE
140
141 -- ATTENTION: If you are adding new attributes to this record type, see
142 -- the message above first.
143 );
144
145
146 -- type defined for line records
147
148 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
149 -- that the procedure fill_all_lines_attr is also changed to init
150 -- the table
151 TYPE lines_rec_type IS RECORD
152 (
153 -- attributes read from line interface records
154 intf_line_id_tbl PO_TBL_NUMBER,
155 intf_header_id_tbl PO_TBL_NUMBER,
156 po_header_id_tbl PO_TBL_NUMBER,
157 po_line_id_tbl PO_TBL_NUMBER,
158 action_tbl PO_TBL_VARCHAR30,
159 document_num_tbl PO_TBL_VARCHAR30,
160 item_tbl PO_TBL_VARCHAR2000,
161 vendor_product_num_tbl PO_TBL_VARCHAR30,
162 supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
163 item_id_tbl PO_TBL_NUMBER,
164 item_revision_tbl PO_TBL_VARCHAR5,
165 job_business_group_name_tbl PO_TBL_VARCHAR2000,
166 job_business_group_id_tbl PO_TBL_NUMBER,
167 job_name_tbl PO_TBL_VARCHAR2000,
168 job_id_tbl PO_TBL_NUMBER,
169 category_tbl PO_TBL_VARCHAR2000,
170 category_id_tbl PO_TBL_NUMBER,
171 ip_category_tbl PO_TBL_VARCHAR2000,
172 ip_category_id_tbl PO_TBL_NUMBER,
173 uom_code_tbl PO_TBL_VARCHAR5,
174 unit_of_measure_tbl PO_TBL_VARCHAR30,
175 line_type_tbl PO_TBL_VARCHAR30,
176 line_type_id_tbl PO_TBL_NUMBER,
177 un_number_tbl PO_TBL_VARCHAR30,
178 un_number_id_tbl PO_TBL_NUMBER,
179 hazard_class_tbl PO_TBL_VARCHAR100,
180 hazard_class_id_tbl PO_TBL_NUMBER,
181 template_name_tbl PO_TBL_VARCHAR30,
182 template_id_tbl PO_TBL_NUMBER,
183 item_desc_tbl PO_TBL_VARCHAR2000,
184 unit_price_tbl PO_TBL_NUMBER,
185 base_unit_price_tbl PO_TBL_NUMBER,
186 from_header_id_tbl PO_TBL_NUMBER,
187 from_line_id_tbl PO_TBL_NUMBER,
188 list_price_per_unit_tbl PO_TBL_NUMBER,
189 market_price_tbl PO_TBL_NUMBER,
190 capital_expense_flag_tbl PO_TBL_VARCHAR1,
191 min_release_amount_tbl PO_TBL_NUMBER,
192 allow_price_override_flag_tbl PO_TBL_VARCHAR1,
193 price_type_tbl PO_TBL_VARCHAR30,
194 price_break_lookup_code_tbl PO_TBL_VARCHAR30,
195 closed_code_tbl PO_TBL_VARCHAR30,
196 quantity_tbl PO_TBL_NUMBER,
197 line_num_tbl PO_TBL_NUMBER,
198 shipment_num_tbl PO_TBL_NUMBER,
199 price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
200 effective_date_tbl PO_TBL_DATE,
201 expiration_date_tbl PO_TBL_DATE,
202 attribute14_tbl PO_TBL_VARCHAR2000,
203 price_update_tolerance_tbl PO_TBL_NUMBER,
204 line_loc_populated_flag_tbl PO_TBL_VARCHAR1,
205 negotiated_flag_tbl PO_TBL_VARCHAR1,
206 amount_tbl PO_TBL_NUMBER,
207 contractor_last_name_tbl PO_TBL_VARCHAR2000,
208 contractor_first_name_tbl PO_TBL_VARCHAR2000,
209 over_tolerance_err_flag_tbl PO_TBL_VARCHAR30,
210 not_to_exceed_price_tbl PO_TBL_NUMBER,
211 po_release_id_tbl PO_TBL_NUMBER,
212 release_num_tbl PO_TBL_NUMBER,
213 source_shipment_id_tbl PO_TBL_NUMBER,
214 contract_num_tbl PO_TBL_VARCHAR30,
215 contract_id_tbl PO_TBL_NUMBER,
216 type_1099_tbl PO_TBL_VARCHAR30,
217 closed_by_tbl PO_TBL_NUMBER,
218 closed_date_tbl PO_TBL_DATE,
219 committed_amount_tbl PO_TBL_NUMBER,
220 qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
221 weight_uom_code_tbl PO_TBL_VARCHAR5,
222 volume_uom_code_tbl PO_TBL_VARCHAR5,
223 secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
224 secondary_quantity_tbl PO_TBL_NUMBER,
225 preferred_grade_tbl PO_TBL_VARCHAR2000,
226 process_code_tbl PO_TBL_VARCHAR30,
227 parent_interface_line_id_tbl PO_TBL_NUMBER, -- bug5149827
228 file_line_language_tbl PO_TBL_VARCHAR5, -- bug 5489942
229
230 -- standard who columns
231 last_updated_by_tbl PO_TBL_NUMBER,
232 last_update_date_tbl PO_TBL_DATE,
233 last_update_login_tbl PO_TBL_NUMBER,
234 creation_date_tbl PO_TBL_DATE,
235 created_by_tbl PO_TBL_NUMBER,
236 request_id_tbl PO_TBL_NUMBER,
237 program_application_id_tbl PO_TBL_NUMBER,
238 program_id_tbl PO_TBL_NUMBER,
239 program_update_date_tbl PO_TBL_DATE,
240
241 -- attributes that are in line txn table but not in interface table
242 order_type_lookup_code_tbl PO_TBL_VARCHAR30,
243 purchase_basis_tbl PO_TBL_VARCHAR30,
244 matching_basis_tbl PO_TBL_VARCHAR30,
245 unordered_flag_tbl PO_TBL_VARCHAR1,
246 cancel_flag_tbl PO_TBL_VARCHAR1,
247 quantity_committed_tbl PO_TBL_NUMBER,
248 tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
249
250 -- attributes read from the header interface record
251 draft_id_tbl PO_TBL_NUMBER,
252 hd_action_tbl PO_TBL_VARCHAR30,
253 hd_po_header_id_tbl PO_TBL_NUMBER,
254 hd_vendor_id_tbl PO_TBL_NUMBER,
255 hd_min_release_amount_tbl PO_TBL_NUMBER,
256 hd_start_date_tbl PO_TBL_DATE,
257 hd_end_date_tbl PO_TBL_DATE,
258 hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
259 hd_currency_code_tbl PO_TBL_VARCHAR30,
260 hd_created_language_tbl PO_TBL_VARCHAR5,
261 hd_style_id_tbl PO_TBL_NUMBER,
262 hd_rate_type_tbl PO_TBL_VARCHAR30,
263
264 -- attributes added for location processing
265 create_line_loc_tbl PO_TBL_VARCHAR1,
266
267 -- attributes added for uniqueness checking
268 origin_line_num_tbl PO_TBL_NUMBER,
269 group_num_tbl PO_TBL_NUMBER,
270 match_line_found_tbl PO_TBL_VARCHAR1,
271 line_num_unique_tbl PO_TBL_VARCHAR1,
272
273 -- attributes added for processing purpose
274 error_flag_tbl PO_TBL_VARCHAR1,
275 need_to_reject_flag_tbl PO_TBL_VARCHAR1,
276 allow_desc_update_flag_tbl PO_TBL_VARCHAR1,
277 rec_count NUMBER,
278 intf_id_index_tbl DBMS_SQL.NUMBER_TABLE
279
280 -- ATTENTION: If you are adding new attributes to this record type, see
281 -- the message above first.
282 );
283
284 -- type defined for line location records
285
286 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
287 -- that the procedure fill_all_line_locs_attr is also changed to init
288 -- the table
289 TYPE line_locs_rec_type IS RECORD
290 (
291 -- attributes read from line location interface records
292 intf_line_loc_id_tbl PO_TBL_NUMBER,
293 intf_line_id_tbl PO_TBL_NUMBER,
294 intf_header_id_tbl PO_TBL_NUMBER,
295 shipment_num_tbl PO_TBL_NUMBER,
299 ship_to_org_id_tbl PO_TBL_NUMBER,
296 shipment_type_tbl PO_TBL_VARCHAR30,
297 line_loc_id_tbl PO_TBL_NUMBER,
298 ship_to_org_code_tbl PO_TBL_VARCHAR5,
300 ship_to_loc_tbl PO_TBL_VARCHAR100,
301 ship_to_loc_id_tbl PO_TBL_NUMBER,
302 payment_terms_tbl PO_TBL_VARCHAR100,
303 terms_id_tbl PO_TBL_NUMBER,
304 receiving_routing_tbl PO_TBL_VARCHAR30,
305 receiving_routing_id_tbl PO_TBL_NUMBER,
306 inspection_required_flag_tbl PO_TBL_VARCHAR1,
307 receipt_required_flag_tbl PO_TBL_VARCHAR1,
308 price_override_tbl PO_TBL_NUMBER,
309 qty_rcv_tolerance_tbl PO_TBL_NUMBER,
310 qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
311 enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
312 allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
313 days_early_receipt_allowed_tbl PO_TBL_NUMBER,
314 days_late_receipt_allowed_tbl PO_TBL_NUMBER,
315 receipt_days_except_code_tbl PO_TBL_VARCHAR30,
316 invoice_close_tolerance_tbl PO_TBL_NUMBER,
317 receive_close_tolerance_tbl PO_TBL_NUMBER,
318 accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
319 firm_flag_tbl PO_TBL_VARCHAR30,
320 fob_tbl PO_TBL_VARCHAR30,
321 freight_carrier_tbl PO_TBL_VARCHAR30,
322 freight_term_tbl PO_TBL_VARCHAR30,
323 need_by_date_tbl PO_TBL_DATE,
324 promised_date_tbl PO_TBL_DATE,
325 quantity_tbl PO_TBL_NUMBER,
326 start_date_tbl PO_TBL_DATE,
327 end_date_tbl PO_TBL_DATE,
328 note_to_receiver_tbl PO_TBL_VARCHAR2000,
329 price_discount_tbl PO_TBL_NUMBER,
330 secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
331 secondary_quantity_tbl PO_TBL_NUMBER,
332 preferred_grade_tbl PO_TBL_VARCHAR2000,
333 tax_code_id_tbl PO_TBL_NUMBER,
334 tax_name_tbl PO_TBL_VARCHAR30,
335 taxable_flag_tbl PO_TBL_VARCHAR1,
336 unit_of_measure_tbl PO_TBL_VARCHAR30,
337 value_basis_tbl PO_TBL_VARCHAR30,
338 matching_basis_tbl PO_TBL_VARCHAR30,
339
340 -- attributes in txn table but not in interface table
341 match_option_tbl PO_TBL_VARCHAR30,
342 txn_flow_header_id_tbl PO_TBL_NUMBER,
343 outsourced_assembly_tbl PO_TBL_NUMBER,
344 tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
345
346 -- standard who columns
347 last_updated_by_tbl PO_TBL_NUMBER,
348 last_update_date_tbl PO_TBL_DATE,
349 last_update_login_tbl PO_TBL_NUMBER,
350 creation_date_tbl PO_TBL_DATE,
351 created_by_tbl PO_TBL_NUMBER,
352 request_id_tbl PO_TBL_NUMBER,
353 program_application_id_tbl PO_TBL_NUMBER,
354 program_id_tbl PO_TBL_NUMBER,
355 program_update_date_tbl PO_TBL_DATE,
356
357 -- attributes read from the line interface record
358 ln_po_line_id_tbl PO_TBL_NUMBER,
359 ln_item_id_tbl PO_TBL_NUMBER,
360 ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
361 ln_action_tbl PO_TBL_VARCHAR30,
362 ln_unit_price_tbl PO_TBL_NUMBER,
363 ln_line_type_id_tbl PO_TBL_NUMBER,
364 ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
365 ln_closed_code_tbl PO_TBL_VARCHAR30,
366 ln_purchase_basis_tbl PO_TBL_VARCHAR30,
367 ln_matching_basis_tbl PO_TBL_VARCHAR30,
368 ln_item_revision_tbl PO_TBL_VARCHAR5,
369 ln_expiration_date_tbl PO_TBL_DATE,
370 ln_government_context_tbl PO_TBL_VARCHAR30,
371 ln_closed_reason_tbl PO_TBL_VARCHAR2000,
372 ln_closed_date_tbl PO_TBL_DATE,
373 ln_closed_by_tbl PO_TBL_NUMBER,
374 ln_from_header_id_tbl PO_TBL_NUMBER,
375 ln_from_line_id_tbl PO_TBL_NUMBER,
376 ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30, -- bug5016163
377
378 -- attributes read from the header interface record
379 draft_id_tbl PO_TBL_NUMBER,
380 hd_po_header_id_tbl PO_TBL_NUMBER,
381 hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
382 hd_vendor_id_tbl PO_TBL_NUMBER,
383 hd_vendor_site_id_tbl PO_TBL_NUMBER,
384 hd_terms_id_tbl PO_TBL_NUMBER,
385 hd_fob_tbl PO_TBL_VARCHAR30,
386 hd_freight_carrier_tbl PO_TBL_VARCHAR30,
387 hd_freight_term_tbl PO_TBL_VARCHAR30,
388 hd_approved_flag_tbl PO_TBL_VARCHAR1,
389 hd_effective_date_tbl PO_TBL_DATE,
390 hd_expiration_date_tbl PO_TBL_DATE,
391 hd_style_id_tbl PO_TBL_NUMBER,
392
393 -- attributes added for item processing(read from line)
394 --ln_qty_rcv_tolerance_tbl PO_TBL_NUMBER,
395 ln_unit_weight_tbl PO_TBL_NUMBER,
396 ln_unit_volume_tbl PO_TBL_NUMBER,
397 ln_item_attribute_category_tbl PO_TBL_VARCHAR2000,
398 ln_item_attribute1_tbl PO_TBL_VARCHAR2000,
399 ln_item_attribute2_tbl PO_TBL_VARCHAR2000,
400 ln_item_attribute3_tbl PO_TBL_VARCHAR2000,
401 ln_item_attribute4_tbl PO_TBL_VARCHAR2000,
402 ln_item_attribute5_tbl PO_TBL_VARCHAR2000,
403 ln_item_attribute6_tbl PO_TBL_VARCHAR2000,
404 ln_item_attribute7_tbl PO_TBL_VARCHAR2000,
405 ln_item_attribute8_tbl PO_TBL_VARCHAR2000,
409 ln_item_attribute12_tbl PO_TBL_VARCHAR2000,
406 ln_item_attribute9_tbl PO_TBL_VARCHAR2000,
407 ln_item_attribute10_tbl PO_TBL_VARCHAR2000,
408 ln_item_attribute11_tbl PO_TBL_VARCHAR2000,
410 ln_item_attribute13_tbl PO_TBL_VARCHAR2000,
411 ln_item_attribute14_tbl PO_TBL_VARCHAR2000,
412 ln_item_attribute15_tbl PO_TBL_VARCHAR2000,
413 ln_item_tbl PO_TBL_VARCHAR2000,
414 ln_item_desc_tbl PO_TBL_VARCHAR2000,
415 ln_list_price_per_unit_tbl PO_TBL_NUMBER,
416 ln_market_price_tbl PO_TBL_NUMBER,
417 ln_un_number_id_tbl PO_TBL_NUMBER,
418 ln_hazard_class_id_tbl PO_TBL_NUMBER,
419 ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
420 ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
421 ln_volume_uom_code_tbl PO_TBL_VARCHAR5,
422 ln_template_id_tbl PO_TBL_NUMBER,
423 ln_category_id_tbl PO_TBL_NUMBER,
424 line_ref_index_tbl PO_TBL_NUMBER,
425
426 -- attributes added for processing purpose
427 shipment_num_unique_tbl PO_TBL_VARCHAR1,
428 error_flag_tbl PO_TBL_VARCHAR1,
429 rec_count NUMBER,
430 intf_id_index_tbl DBMS_SQL.NUMBER_TABLE
431
432 -- ATTENTION: If you are adding new attributes to this record type, see
433 -- the message above first.
434 );
435
436 -- type defined for distribution record
437
438 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
439 -- that the procedure fill_all_dists_attr is also changed to init
440 -- the table
441 TYPE distributions_rec_type IS RECORD
442 (
443 intf_dist_id_tbl PO_TBL_NUMBER,
444 intf_header_id_tbl PO_TBL_NUMBER,
445 intf_line_id_tbl PO_TBL_NUMBER,
446 intf_line_loc_id_tbl PO_TBL_NUMBER,
447 po_dist_id_tbl PO_TBL_NUMBER,
448 dist_num_tbl PO_TBL_NUMBER,
449 deliver_to_loc_tbl PO_TBL_VARCHAR100,
450 deliver_to_loc_id_tbl PO_TBL_NUMBER,
451 deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
452 deliver_to_person_id_tbl PO_TBL_NUMBER,
453 dest_type_tbl PO_TBL_VARCHAR30,
454 dest_type_code_tbl PO_TBL_VARCHAR30,
455 dest_org_tbl PO_TBL_VARCHAR100,
456 dest_org_id_tbl PO_TBL_NUMBER,
457 wip_entity_tbl PO_TBL_VARCHAR2000,
458 wip_entity_id_tbl PO_TBL_NUMBER,
459 wip_line_code_tbl PO_TBL_VARCHAR30,
460 wip_line_id_tbl PO_TBL_NUMBER,
461 bom_resource_code_tbl PO_TBL_VARCHAR30,
462 bom_resource_id_tbl PO_TBL_NUMBER,
463 charge_account_tbl PO_TBL_VARCHAR2000,
464 charge_account_id_tbl PO_TBL_NUMBER,
465 dest_charge_account_id_tbl PO_TBL_NUMBER,
466 project_accounting_context_tbl PO_TBL_VARCHAR30,
467 award_num_tbl PO_TBL_VARCHAR30,
468 award_id_tbl PO_TBL_NUMBER,
469 project_tbl PO_TBL_VARCHAR30,
470 project_id_tbl PO_TBL_NUMBER,
471 task_tbl PO_TBL_VARCHAR30,
472 task_id_tbl PO_TBL_NUMBER,
473 expenditure_tbl PO_TBL_VARCHAR100,
474 expenditure_type_tbl PO_TBL_VARCHAR30,
475 expenditure_org_tbl PO_TBL_VARCHAR100,
476 expenditure_org_id_tbl PO_TBL_NUMBER,
477 expenditure_item_date_tbl PO_TBL_DATE,
478 end_item_unit_number_tbl PO_TBL_VARCHAR30,
479 dest_context_tbl PO_TBL_VARCHAR30,
480 gl_encumbered_date_tbl PO_TBL_DATE,
481 gl_encumbered_period_tbl PO_TBL_VARCHAR30,
482 variance_account_id_tbl PO_TBL_NUMBER,
483 accrual_account_id_tbl PO_TBL_NUMBER,
484 budget_account_id_tbl PO_TBL_NUMBER,
485 dest_variance_account_id_tbl PO_TBL_NUMBER,
486 dest_subinventory_tbl PO_TBL_VARCHAR30,
487 amount_ordered_tbl PO_TBL_NUMBER,
488 quantity_ordered_tbl PO_TBL_NUMBER,
489 wip_rep_schedule_id_tbl PO_TBL_NUMBER,
490 wip_operation_seq_num_tbl PO_TBL_NUMBER,
491 wip_resource_seq_num_tbl PO_TBL_NUMBER,
492 prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
493 recovery_rate_tbl PO_TBL_NUMBER,
494 tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
495 account_segment1_tbl PO_TBL_VARCHAR30,
496 account_segment2_tbl PO_TBL_VARCHAR30,
497 account_segment3_tbl PO_TBL_VARCHAR30,
498 account_segment4_tbl PO_TBL_VARCHAR30,
499 account_segment5_tbl PO_TBL_VARCHAR30,
500 account_segment6_tbl PO_TBL_VARCHAR30,
501 account_segment7_tbl PO_TBL_VARCHAR30,
502 account_segment8_tbl PO_TBL_VARCHAR30,
503 account_segment9_tbl PO_TBL_VARCHAR30,
504 account_segment10_tbl PO_TBL_VARCHAR30,
505 account_segment11_tbl PO_TBL_VARCHAR30,
506 account_segment12_tbl PO_TBL_VARCHAR30,
507 account_segment13_tbl PO_TBL_VARCHAR30,
508 account_segment14_tbl PO_TBL_VARCHAR30,
509 account_segment15_tbl PO_TBL_VARCHAR30,
510 account_segment16_tbl PO_TBL_VARCHAR30,
511 account_segment17_tbl PO_TBL_VARCHAR30,
512 account_segment18_tbl PO_TBL_VARCHAR30,
513 account_segment19_tbl PO_TBL_VARCHAR30,
514 account_segment20_tbl PO_TBL_VARCHAR30,
515 account_segment21_tbl PO_TBL_VARCHAR30,
516 account_segment22_tbl PO_TBL_VARCHAR30,
517 account_segment23_tbl PO_TBL_VARCHAR30,
518 account_segment24_tbl PO_TBL_VARCHAR30,
519 account_segment25_tbl PO_TBL_VARCHAR30,
523 account_segment29_tbl PO_TBL_VARCHAR30,
520 account_segment26_tbl PO_TBL_VARCHAR30,
521 account_segment27_tbl PO_TBL_VARCHAR30,
522 account_segment28_tbl PO_TBL_VARCHAR30,
524 account_segment30_tbl PO_TBL_VARCHAR30,
525 dist_attribute1_tbl PO_TBL_VARCHAR2000,
526 dist_attribute2_tbl PO_TBL_VARCHAR2000,
527 dist_attribute3_tbl PO_TBL_VARCHAR2000,
528 dist_attribute4_tbl PO_TBL_VARCHAR2000,
529 dist_attribute5_tbl PO_TBL_VARCHAR2000,
530 dist_attribute6_tbl PO_TBL_VARCHAR2000,
531 dist_attribute7_tbl PO_TBL_VARCHAR2000,
532 dist_attribute8_tbl PO_TBL_VARCHAR2000,
533 dist_attribute9_tbl PO_TBL_VARCHAR2000,
534 dist_attribute10_tbl PO_TBL_VARCHAR2000,
535 dist_attribute11_tbl PO_TBL_VARCHAR2000,
536 dist_attribute12_tbl PO_TBL_VARCHAR2000,
537 dist_attribute13_tbl PO_TBL_VARCHAR2000,
538 dist_attribute14_tbl PO_TBL_VARCHAR2000,
539 dist_attribute15_tbl PO_TBL_VARCHAR2000,
540
541 -- standard who columns
542 last_updated_by_tbl PO_TBL_NUMBER,
543 last_update_date_tbl PO_TBL_DATE,
544 last_update_login_tbl PO_TBL_NUMBER,
545 creation_date_tbl PO_TBL_DATE,
546 created_by_tbl PO_TBL_NUMBER,
547 request_id_tbl PO_TBL_NUMBER,
548 program_application_id_tbl PO_TBL_NUMBER,
549 program_id_tbl PO_TBL_NUMBER,
550 program_update_date_tbl PO_TBL_DATE,
551
552 -- attributes exist in txn table but not in interface table
553 tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
554 award_set_id_tbl PO_TBL_NUMBER, -- bug5201306
555
556 -- attributes read from line location record
557 loc_ship_to_org_id_tbl PO_TBL_NUMBER,
558 loc_line_loc_id_tbl PO_TBL_NUMBER,
559 loc_shipment_type_tbl PO_TBL_VARCHAR30,
560 loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
561 loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
562 loc_need_by_date_tbl PO_TBL_DATE,
563 loc_promised_date_tbl PO_TBL_DATE,
564 loc_price_override_tbl PO_TBL_NUMBER,
565 loc_outsourced_assembly_tbl PO_TBL_NUMBER,
566 loc_attribute1_tbl PO_TBL_VARCHAR2000,
567 loc_attribute2_tbl PO_TBL_VARCHAR2000,
568 loc_attribute3_tbl PO_TBL_VARCHAR2000,
569 loc_attribute4_tbl PO_TBL_VARCHAR2000,
570 loc_attribute5_tbl PO_TBL_VARCHAR2000,
571 loc_attribute6_tbl PO_TBL_VARCHAR2000,
572 loc_attribute7_tbl PO_TBL_VARCHAR2000,
573 loc_attribute8_tbl PO_TBL_VARCHAR2000,
574 loc_attribute9_tbl PO_TBL_VARCHAR2000,
575 loc_attribute10_tbl PO_TBL_VARCHAR2000,
576 loc_attribute11_tbl PO_TBL_VARCHAR2000,
577 loc_attribute12_tbl PO_TBL_VARCHAR2000,
578 loc_attribute13_tbl PO_TBL_VARCHAR2000,
579 loc_attribute14_tbl PO_TBL_VARCHAR2000,
580 loc_attribute15_tbl PO_TBL_VARCHAR2000,
581
582 -- attributes read from line record
583 ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
584 ln_purchase_basis_tbl PO_TBL_VARCHAR30,
585 ln_item_id_tbl PO_TBL_NUMBER,
586 ln_category_id_tbl PO_TBL_NUMBER,
587 ln_line_type_id_tbl PO_TBL_NUMBER,
588 ln_po_line_id_tbl PO_TBL_NUMBER,
589 ln_attribute1_tbl PO_TBL_VARCHAR2000,
590 ln_attribute2_tbl PO_TBL_VARCHAR2000,
591 ln_attribute3_tbl PO_TBL_VARCHAR2000,
592 ln_attribute4_tbl PO_TBL_VARCHAR2000,
593 ln_attribute5_tbl PO_TBL_VARCHAR2000,
594 ln_attribute6_tbl PO_TBL_VARCHAR2000,
595 ln_attribute7_tbl PO_TBL_VARCHAR2000,
596 ln_attribute8_tbl PO_TBL_VARCHAR2000,
597 ln_attribute9_tbl PO_TBL_VARCHAR2000,
598 ln_attribute10_tbl PO_TBL_VARCHAR2000,
599 ln_attribute11_tbl PO_TBL_VARCHAR2000,
600 ln_attribute12_tbl PO_TBL_VARCHAR2000,
601 ln_attribute13_tbl PO_TBL_VARCHAR2000,
602 ln_attribute14_tbl PO_TBL_VARCHAR2000,
603 ln_attribute15_tbl PO_TBL_VARCHAR2000,
604
605 -- attributes read from header record
606 draft_id_tbl PO_TBL_NUMBER,
607 hd_agent_id_tbl PO_TBL_NUMBER,
608 hd_po_header_id_tbl PO_TBL_NUMBER,
609 hd_rate_date_tbl PO_TBL_DATE,
610 hd_rate_tbl PO_TBL_NUMBER,
611 hd_type_lookup_code_tbl PO_TBL_VARCHAR30,
612 hd_vendor_id_tbl PO_TBL_NUMBER,
613 hd_attribute1_tbl PO_TBL_VARCHAR2000,
614 hd_attribute2_tbl PO_TBL_VARCHAR2000,
615 hd_attribute3_tbl PO_TBL_VARCHAR2000,
616 hd_attribute4_tbl PO_TBL_VARCHAR2000,
617 hd_attribute5_tbl PO_TBL_VARCHAR2000,
618 hd_attribute6_tbl PO_TBL_VARCHAR2000,
619 hd_attribute7_tbl PO_TBL_VARCHAR2000,
620 hd_attribute8_tbl PO_TBL_VARCHAR2000,
621 hd_attribute9_tbl PO_TBL_VARCHAR2000,
622 hd_attribute10_tbl PO_TBL_VARCHAR2000,
623 hd_attribute11_tbl PO_TBL_VARCHAR2000,
624 hd_attribute12_tbl PO_TBL_VARCHAR2000,
625 hd_attribute13_tbl PO_TBL_VARCHAR2000,
626 hd_attribute14_tbl PO_TBL_VARCHAR2000,
627 hd_attribute15_tbl PO_TBL_VARCHAR2000,
628
629 -- attributes added for processing
630 ship_to_ou_id_tbl PO_TBL_NUMBER,
631 ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
632 item_status_tbl PO_TBL_VARCHAR1,
633 gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
634 dist_num_unique_tbl PO_TBL_VARCHAR1,
638 -- ATTENTION: If you are adding new attributes to this record type, see
635 error_flag_tbl PO_TBL_VARCHAR1,
636 rec_count NUMBER
637
639 -- the message above first.
640 );
641
642 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
643 -- that the procedure fill_all_price_diffs_attr is also changed to
644 -- init the table
645 TYPE price_diffs_rec_type IS RECORD
646 (
647 intf_price_diff_id_tbl PO_TBL_NUMBER,
648 intf_line_id_tbl PO_TBL_NUMBER, -- bug 5215781
649 intf_header_id_tbl PO_TBL_NUMBER, -- bug 5215781
650 price_diff_num_tbl PO_TBL_NUMBER,
651 price_type_tbl PO_TBL_VARCHAR30,
652 entity_type_tbl PO_TBL_VARCHAR30,
653 entity_id_tbl PO_TBL_NUMBER,
654 multiplier_tbl PO_TBL_NUMBER,
655 min_multiplier_tbl PO_TBL_NUMBER,
656 max_multiplier_tbl PO_TBL_NUMBER,
657
658 -- attribute read from line location
659 loc_line_loc_id_tbl PO_TBL_NUMBER,
660
661 -- attributes read from line record
662 ln_po_line_id_tbl PO_TBL_NUMBER,
663
664 -- attributes read from header record
665 draft_id_tbl PO_TBL_NUMBER,
666 hd_style_id_tbl PO_TBL_NUMBER,
667
668 -- attributes added for processing
669 error_flag_tbl PO_TBL_VARCHAR1,
670 price_diff_num_unique_tbl PO_TBL_VARCHAR1,
671 rec_count NUMBER
672
673 -- ATTENTION: If you are adding new attributes to this record type, see
674 -- the message above first.
675 );
676
677 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
678 -- that the procedure fill_all_attr_values_attr is also changed to
682 -- attribute from attr_values table
679 -- init the table
680 TYPE attr_values_rec_type IS RECORD
681 (
683 intf_attr_values_id_tbl PO_TBL_NUMBER,
684 org_id_tbl PO_TBL_NUMBER,
685
686 -- attributes from line record
687 ln_po_line_id_tbl PO_TBL_NUMBER,
688 ln_ip_category_id_tbl PO_TBL_NUMBER,
689 ln_item_id_tbl PO_TBL_NUMBER,
690
691 -- attribute from header record
692 draft_id_tbl PO_TBL_NUMBER,
693
694 -- attributes added for processing purpose
695 attribute_values_id_tbl PO_TBL_NUMBER,
696 source_tbl DBMS_SQL.VARCHAR2_TABLE,
697 error_flag_tbl PO_TBL_VARCHAR1,
698
699 rec_count NUMBER
700
701 -- ATTENTION: If you are adding new attributes to this record type, see
702 -- the message above first.
703 );
704
705 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
706 -- that the procedure fill_all_attr_values_tlp_attr is also changed
707 -- to init the table
708 TYPE attr_values_tlp_rec_type IS RECORD
709 (
710 -- attribute from attr_values table
711 intf_attr_values_tlp_id_tbl PO_TBL_NUMBER,
712 language_tbl PO_TBL_VARCHAR5,
713 org_id_tbl PO_TBL_NUMBER,
714
715 -- attribute from line
716 ln_po_line_id_tbl PO_TBL_NUMBER,
717 ln_ip_category_id_tbl PO_TBL_NUMBER,
718 ln_item_id_tbl PO_TBL_NUMBER,
719 ln_item_desc_tbl PO_TBL_VARCHAR2000,
720
721 -- attribute from headers
722 draft_id_tbl PO_TBL_NUMBER,
723
724 -- attributes added for processing purpose
725 error_flag_tbl PO_TBL_VARCHAR1,
726 attribute_values_tlp_id_tbl PO_TBL_NUMBER,
727 source_tbl DBMS_SQL.VARCHAR2_TABLE,
728
729 rec_count NUMBER
730
731 -- ATTENTION: If you are adding new attributes to this record type, see
732 -- the message above first.
733 );
734
735 -- type defined for cursor variable
736 TYPE intf_cursor_type IS REF CURSOR;
737 TYPE varchar_index_tbl_type IS TABLE OF NUMBER INDEX BY VARCHAR2(30);
738
739
740 -- PROCEDURES that initialize the pl/sql tables within the record, allocating
741 -- memory for the tables indicated by the parameter that specifies
742 -- the number of records the structure will hold
743
744 -- bug5106386 START
745 PROCEDURE fill_all_headers_attr
746 ( p_num_records IN NUMBER,
747 x_headers IN OUT NOCOPY headers_rec_type
748 );
749
750 PROCEDURE fill_all_lines_attr
751 ( p_num_records IN NUMBER,
752 x_lines IN OUT NOCOPY lines_rec_type
753 );
754
755 PROCEDURE fill_all_line_locs_attr
756 ( p_num_records IN NUMBER,
757 x_line_locs IN OUT NOCOPY line_locs_rec_type
758 );
759
760 PROCEDURE fill_all_dists_attr
761 ( p_num_records IN NUMBER,
762 x_dists IN OUT NOCOPY distributions_rec_type
763 );
764
765 PROCEDURE fill_all_price_diffs_attr
766 ( p_num_records IN NUMBER,
767 x_price_diffs IN OUT NOCOPY price_diffs_rec_type
768 );
769
770 PROCEDURE fill_all_attr_values_attr
771 ( p_num_records IN NUMBER,
772 x_attr_values IN OUT NOCOPY attr_values_rec_type
773 );
774
775 PROCEDURE fill_all_attr_values_tlp_attr
776 ( p_num_records IN NUMBER,
777 x_attr_values_tlp IN OUT NOCOPY attr_values_tlp_rec_type
778 );
779
780 -- bug5106386 END
781
782 END PO_PDOI_TYPES;