[Home] [Help]
PACKAGE: APPS.PO_PDOI_TYPES
Source
1 PACKAGE PO_PDOI_TYPES AUTHID CURRENT_USER AS
2 /* $Header: PO_PDOI_TYPES.pls 120.31.12020000.4 2013/03/22 14:36:58 sbontala ship $ */
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 --attributes added for CLM PDOI Integration
142 clm_document_format_tbl PO_TBL_VARCHAR2000,
143 clm_standard_form_tbl PO_TBL_VARCHAR2000,
144 clm_award_type_tbl PO_TBL_VARCHAR30,
145 clm_source_document_id_tbl PO_TBL_NUMBER,
146 clm_external_idv_tbl PO_TBL_VARCHAR2000,
147 clm_vendor_offer_number_tbl PO_TBL_VARCHAR2000,
148 clm_award_administrator_tbl PO_TBL_VARCHAR2000,
149 comments_tbl PO_TBL_VARCHAR2000,
150 no_signed_copies_to_return_tbl PO_TBL_NUMBER,
151 umbrella_program_id_tbl PO_TBL_NUMBER,
152 note_to_vendor_tbl PO_TBL_VARCHAR2000,
153 note_to_receiver_tbl PO_TBL_VARCHAR2000,
154 clm_effective_date_tbl PO_TBL_DATE,
155 clm_min_guar_award_amt_tbl PO_TBL_NUMBER,
156 clm_min_guar_award_amt_per_tbl PO_TBL_NUMBER,
157 clm_min_order_amount_tbl PO_TBL_NUMBER,
158 clm_max_order_amount_tbl PO_TBL_NUMBER,
159 clm_amount_released_tbl PO_TBL_NUMBER,
160 fon_ref_id_tbl PO_TBL_NUMBER,
161 clm_award_type_disp_tbl PO_TBL_VARCHAR240,
162 clm_award_admin_disp_tbl PO_TBL_VARCHAR240,
163 clm_contract_officer_disp_tbl PO_TBL_VARCHAR240,
164 clm_contract_officer_tbl PO_TBL_NUMBER,
165 clm_source_document_disp_tbl PO_TBL_VARCHAR240,
166 draft_type_tbl PO_TBL_VARCHAR30
167
168
169 -- ATTENTION: If you are adding new attributes to this record type, see
170 -- the message above first.
171 );
172
173
174 -- type defined for line records
175
176 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
177 -- that the procedure fill_all_lines_attr is also changed to init
178 -- the table
179 TYPE lines_rec_type IS RECORD
180 (
181 -- attributes read from line interface records
182 intf_line_id_tbl PO_TBL_NUMBER,
183 intf_header_id_tbl PO_TBL_NUMBER,
184 po_header_id_tbl PO_TBL_NUMBER,
185 po_line_id_tbl PO_TBL_NUMBER,
186 action_tbl PO_TBL_VARCHAR30,
187 document_num_tbl PO_TBL_VARCHAR30,
188 item_tbl PO_TBL_VARCHAR2000,
189 vendor_product_num_tbl PO_TBL_VARCHAR30,
190 supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
191 item_id_tbl PO_TBL_NUMBER,
192 item_revision_tbl PO_TBL_VARCHAR5,
193 job_business_group_name_tbl PO_TBL_VARCHAR2000,
194 job_business_group_id_tbl PO_TBL_NUMBER,
195 job_name_tbl PO_TBL_VARCHAR2000,
196 job_id_tbl PO_TBL_NUMBER,
197 category_tbl PO_TBL_VARCHAR2000,
198 category_id_tbl PO_TBL_NUMBER,
199 ip_category_tbl PO_TBL_VARCHAR2000,
200 ip_category_id_tbl PO_TBL_NUMBER,
201 uom_code_tbl PO_TBL_VARCHAR5,
202 unit_of_measure_tbl PO_TBL_VARCHAR30,
203 line_type_tbl PO_TBL_VARCHAR30,
204 line_type_id_tbl PO_TBL_NUMBER,
205 un_number_tbl PO_TBL_VARCHAR30,
206 un_number_id_tbl PO_TBL_NUMBER,
207 hazard_class_tbl PO_TBL_VARCHAR100,
208 hazard_class_id_tbl PO_TBL_NUMBER,
209 template_name_tbl PO_TBL_VARCHAR30,
210 template_id_tbl PO_TBL_NUMBER,
211 item_desc_tbl PO_TBL_VARCHAR2000,
212 unit_price_tbl PO_TBL_NUMBER,
213 base_unit_price_tbl PO_TBL_NUMBER,
214 from_header_id_tbl PO_TBL_NUMBER,
215 from_line_id_tbl PO_TBL_NUMBER,
216 list_price_per_unit_tbl PO_TBL_NUMBER,
217 market_price_tbl PO_TBL_NUMBER,
218 capital_expense_flag_tbl PO_TBL_VARCHAR1,
219 min_release_amount_tbl PO_TBL_NUMBER,
220 allow_price_override_flag_tbl PO_TBL_VARCHAR1,
221 price_type_tbl PO_TBL_VARCHAR30,
222 price_break_lookup_code_tbl PO_TBL_VARCHAR30,
223 closed_code_tbl PO_TBL_VARCHAR30,
224 quantity_tbl PO_TBL_NUMBER,
225 line_num_tbl PO_TBL_NUMBER,
226 shipment_num_tbl PO_TBL_NUMBER,
227 price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
228 effective_date_tbl PO_TBL_DATE,
229 expiration_date_tbl PO_TBL_DATE,
230 attribute14_tbl PO_TBL_VARCHAR2000,
231 price_update_tolerance_tbl PO_TBL_NUMBER,
232 line_loc_populated_flag_tbl PO_TBL_VARCHAR1,
233 -- PDOI for Complex PO Project
234 retainage_rate_tbl PO_TBL_NUMBER,
235 max_retainage_amount_tbl PO_TBL_NUMBER,
236 progress_payment_rate_tbl PO_TBL_NUMBER,
237 recoupment_rate_tbl PO_TBL_NUMBER,
238 advance_amount_tbl PO_TBL_NUMBER,
239
240 negotiated_flag_tbl PO_TBL_VARCHAR1,
241 amount_tbl PO_TBL_NUMBER,
242 contractor_last_name_tbl PO_TBL_VARCHAR2000,
243 contractor_first_name_tbl PO_TBL_VARCHAR2000,
244 over_tolerance_err_flag_tbl PO_TBL_VARCHAR30,
245 not_to_exceed_price_tbl PO_TBL_NUMBER,
246 po_release_id_tbl PO_TBL_NUMBER,
247 release_num_tbl PO_TBL_NUMBER,
248 source_shipment_id_tbl PO_TBL_NUMBER,
249 contract_num_tbl PO_TBL_VARCHAR30,
250 contract_id_tbl PO_TBL_NUMBER,
251 type_1099_tbl PO_TBL_VARCHAR30,
252 closed_by_tbl PO_TBL_NUMBER,
253 closed_date_tbl PO_TBL_DATE,
254 committed_amount_tbl PO_TBL_NUMBER,
255 qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
256 weight_uom_code_tbl PO_TBL_VARCHAR5,
257 volume_uom_code_tbl PO_TBL_VARCHAR5,
258 secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
259 secondary_quantity_tbl PO_TBL_NUMBER,
260 preferred_grade_tbl PO_TBL_VARCHAR2000,
261 process_code_tbl PO_TBL_VARCHAR30,
262 parent_interface_line_id_tbl PO_TBL_NUMBER, -- bug5149827
263 file_line_language_tbl PO_TBL_VARCHAR5, -- bug 5489942
264
265 -- standard who columns
266 last_updated_by_tbl PO_TBL_NUMBER,
267 last_update_date_tbl PO_TBL_DATE,
268 last_update_login_tbl PO_TBL_NUMBER,
269 creation_date_tbl PO_TBL_DATE,
270 created_by_tbl PO_TBL_NUMBER,
271 request_id_tbl PO_TBL_NUMBER,
272 program_application_id_tbl PO_TBL_NUMBER,
273 program_id_tbl PO_TBL_NUMBER,
274 program_update_date_tbl PO_TBL_DATE,
275
276 -- attributes that are in line txn table but not in interface table
277 order_type_lookup_code_tbl PO_TBL_VARCHAR30,
278 purchase_basis_tbl PO_TBL_VARCHAR30,
279 matching_basis_tbl PO_TBL_VARCHAR30,
280 unordered_flag_tbl PO_TBL_VARCHAR1,
281 cancel_flag_tbl PO_TBL_VARCHAR1,
282 quantity_committed_tbl PO_TBL_NUMBER,
283 tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
284
285 -- attributes read from the header interface record
286 draft_id_tbl PO_TBL_NUMBER,
287 hd_action_tbl PO_TBL_VARCHAR30,
288 hd_po_header_id_tbl PO_TBL_NUMBER,
289 hd_vendor_id_tbl PO_TBL_NUMBER,
290 hd_min_release_amount_tbl PO_TBL_NUMBER,
291 hd_start_date_tbl PO_TBL_DATE,
292 hd_end_date_tbl PO_TBL_DATE,
293 hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
294 hd_currency_code_tbl PO_TBL_VARCHAR30,
295 hd_created_language_tbl PO_TBL_VARCHAR5,
296 hd_style_id_tbl PO_TBL_NUMBER,
297 hd_rate_type_tbl PO_TBL_VARCHAR30,
301 create_line_loc_tbl PO_TBL_VARCHAR1,
298 hd_rate_tbl PO_TBL_NUMBER, -- bug 9194215
299
300 -- attributes added for location processing
302
303 -- attributes added for uniqueness checking
304 origin_line_num_tbl PO_TBL_NUMBER,
305 group_num_tbl PO_TBL_NUMBER,
306 match_line_found_tbl PO_TBL_VARCHAR1,
307 line_num_unique_tbl PO_TBL_VARCHAR1,
308 clm_info_flag_tbl PO_TBL_VARCHAR1, /* 10354034 */
309
310
311 -- attributes added for processing purpose
312 error_flag_tbl PO_TBL_VARCHAR1,
313 need_to_reject_flag_tbl PO_TBL_VARCHAR1,
314 allow_desc_update_flag_tbl PO_TBL_VARCHAR1,
315 rec_count NUMBER,
316 intf_id_index_tbl DBMS_SQL.NUMBER_TABLE,
317
318 --attributes added for pdoi clm integration project
319 contract_type_tbl PO_TBL_VARCHAR240,
320 cost_constraint_tbl PO_TBL_VARCHAR30,
321 note_to_vendor_tbl PO_TBL_VARCHAR2000,
322 oke_contract_version_id_tbl PO_TBL_NUMBER,
323 oke_contract_header_id_tbl PO_TBL_VARCHAR240,
324 clm_option_indicator_tbl PO_TBL_VARCHAR1,
325 clm_base_line_num_tbl PO_TBL_NUMBER,
326 clm_option_num_tbl PO_TBL_NUMBER,
327 clm_option_from_date_tbl PO_TBL_DATE,
328 clm_option_to_date_tbl PO_TBL_DATE,
329 clm_idc_type_tbl PO_TBL_VARCHAR240,
330 line_num_display_tbl PO_TBL_VARCHAR100,
331 clm_funded_flag_tbl PO_TBL_VARCHAR1,
332 user_document_status_tbl PO_TBL_VARCHAR30,
333 clm_exercised_flag_tbl PO_TBL_VARCHAR1,
334 clm_exercised_date_tbl PO_TBL_DATE,
335 clm_min_total_amount_tbl PO_TBL_NUMBER,
336 clm_max_total_amount_tbl PO_TBL_NUMBER,
337 clm_min_total_quantity_tbl PO_TBL_NUMBER,
338 clm_max_total_quantity_tbl PO_TBL_NUMBER,
339 clm_min_order_amount_tbl PO_TBL_NUMBER,
340 clm_max_order_amount_tbl PO_TBL_NUMBER,
341 clm_min_order_quantity_tbl PO_TBL_NUMBER,
342 clm_max_order_quantity_tbl PO_TBL_NUMBER,
343 clm_total_amount_ordered_tbl PO_TBL_NUMBER,
344 clm_total_quantity_ordered_tbl PO_TBL_NUMBER,
345 clm_period_perf_end_date_tbl PO_TBL_DATE,
346 clm_period_perf_start_date_tbl PO_TBL_DATE,
347 contract_type_display_tbl PO_TBL_VARCHAR240,
348 cost_constraint_display_tbl PO_TBL_VARCHAR240,
349 clm_idc_type_display_tbl PO_TBL_VARCHAR240,
350 clm_base_line_num_disp_tbl PO_TBL_VARCHAR240,
351 from_header_disp_tbl PO_TBL_VARCHAR240,
352 from_line_disp_tbl PO_TBL_VARCHAR240,
353 group_line_id_tbl PO_TBL_NUMBER
354
355 -- ATTENTION: If you are adding new attributes to this record type, see
356 -- the message above first.
357 );
358
359 -- type defined for line location records
360
361 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
362 -- that the procedure fill_all_line_locs_attr is also changed to init
363 -- the table
364 TYPE line_locs_rec_type IS RECORD
365 (
366 -- attributes read from line location interface records
367 intf_line_loc_id_tbl PO_TBL_NUMBER,
368 intf_line_id_tbl PO_TBL_NUMBER,
369 intf_header_id_tbl PO_TBL_NUMBER,
370 shipment_num_tbl PO_TBL_NUMBER,
371 shipment_type_tbl PO_TBL_VARCHAR30,
372 line_loc_id_tbl PO_TBL_NUMBER,
373 ship_to_org_code_tbl PO_TBL_VARCHAR5,
374 ship_to_org_id_tbl PO_TBL_NUMBER,
375 ship_to_loc_tbl PO_TBL_VARCHAR100,
376 ship_to_loc_id_tbl PO_TBL_NUMBER,
377 payment_terms_tbl PO_TBL_VARCHAR100,
378 terms_id_tbl PO_TBL_NUMBER,
379 receiving_routing_tbl PO_TBL_VARCHAR30,
380 receiving_routing_id_tbl PO_TBL_NUMBER,
381 inspection_required_flag_tbl PO_TBL_VARCHAR1,
382 receipt_required_flag_tbl PO_TBL_VARCHAR1,
383 price_override_tbl PO_TBL_NUMBER,
384 qty_rcv_tolerance_tbl PO_TBL_NUMBER,
385 qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
386 enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
387 allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
388 days_early_receipt_allowed_tbl PO_TBL_NUMBER,
389 days_late_receipt_allowed_tbl PO_TBL_NUMBER,
390 receipt_days_except_code_tbl PO_TBL_VARCHAR30,
391 invoice_close_tolerance_tbl PO_TBL_NUMBER,
392 receive_close_tolerance_tbl PO_TBL_NUMBER,
393 accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
394 firm_flag_tbl PO_TBL_VARCHAR30,
395 fob_tbl PO_TBL_VARCHAR30,
396 freight_carrier_tbl PO_TBL_VARCHAR30,
397 freight_term_tbl PO_TBL_VARCHAR30,
398 need_by_date_tbl PO_TBL_DATE,
399 promised_date_tbl PO_TBL_DATE,
400 quantity_tbl PO_TBL_NUMBER,
401 amount_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
402 start_date_tbl PO_TBL_DATE,
403 end_date_tbl PO_TBL_DATE,
404 note_to_receiver_tbl PO_TBL_VARCHAR2000,
405 price_discount_tbl PO_TBL_NUMBER,
406 secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
407 secondary_quantity_tbl PO_TBL_NUMBER,
408 preferred_grade_tbl PO_TBL_VARCHAR2000,
409 tax_code_id_tbl PO_TBL_NUMBER,
410 tax_name_tbl PO_TBL_VARCHAR30,
411 taxable_flag_tbl PO_TBL_VARCHAR1,
412 unit_of_measure_tbl PO_TBL_VARCHAR30,
413 value_basis_tbl PO_TBL_VARCHAR30,
417 -- attributes in txn table but not in interface table
414 matching_basis_tbl PO_TBL_VARCHAR30,
415 payment_type_tbl PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
416
418 match_option_tbl PO_TBL_VARCHAR30,
419 txn_flow_header_id_tbl PO_TBL_NUMBER,
420 outsourced_assembly_tbl PO_TBL_NUMBER,
421 tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
422
423 -- standard who columns
424 last_updated_by_tbl PO_TBL_NUMBER,
425 last_update_date_tbl PO_TBL_DATE,
426 last_update_login_tbl PO_TBL_NUMBER,
427 creation_date_tbl PO_TBL_DATE,
428 created_by_tbl PO_TBL_NUMBER,
429 request_id_tbl PO_TBL_NUMBER,
430 program_application_id_tbl PO_TBL_NUMBER,
431 program_id_tbl PO_TBL_NUMBER,
432 program_update_date_tbl PO_TBL_DATE,
433
434 -- attributes read from the line interface record
435 ln_po_line_id_tbl PO_TBL_NUMBER,
436 ln_item_id_tbl PO_TBL_NUMBER,
437
438 --< Shared Proc 14223789 Start >
439 ln_item_category_id_tbl PO_TBL_NUMBER,
440 --< Shared Proc 14223789 End >
441
442 ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
443 ln_action_tbl PO_TBL_VARCHAR30,
444 ln_unit_price_tbl PO_TBL_NUMBER,
445 ln_quantity_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
446 ln_amount_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
447 ln_line_type_id_tbl PO_TBL_NUMBER,
448 ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
449 ln_closed_code_tbl PO_TBL_VARCHAR30,
450 ln_purchase_basis_tbl PO_TBL_VARCHAR30,
451 ln_matching_basis_tbl PO_TBL_VARCHAR30,
452 ln_item_revision_tbl PO_TBL_VARCHAR5,
453 ln_expiration_date_tbl PO_TBL_DATE,
454 ln_government_context_tbl PO_TBL_VARCHAR30,
455 ln_closed_reason_tbl PO_TBL_VARCHAR2000,
456 ln_closed_date_tbl PO_TBL_DATE,
457 ln_closed_by_tbl PO_TBL_NUMBER,
458 ln_from_header_id_tbl PO_TBL_NUMBER,
459 ln_from_line_id_tbl PO_TBL_NUMBER,
460 ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30, -- bug5016163
461
462 -- attributes read from the header interface record
463 draft_id_tbl PO_TBL_NUMBER,
464 hd_po_header_id_tbl PO_TBL_NUMBER,
465 --< Shared Proc 14223789 Start>
466 hd_doc_type_tbl PO_TBL_VARCHAR30,
467 --< Shared Proc 14223789 End>
468 hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
469 hd_vendor_id_tbl PO_TBL_NUMBER,
470 hd_vendor_site_id_tbl PO_TBL_NUMBER,
471 hd_terms_id_tbl PO_TBL_NUMBER,
472 hd_fob_tbl PO_TBL_VARCHAR30,
473 hd_freight_carrier_tbl PO_TBL_VARCHAR30,
474 hd_freight_term_tbl PO_TBL_VARCHAR30,
475 hd_approved_flag_tbl PO_TBL_VARCHAR1,
476 hd_effective_date_tbl PO_TBL_DATE,
477 hd_expiration_date_tbl PO_TBL_DATE,
478 hd_style_id_tbl PO_TBL_NUMBER,
479 hd_currency_code_tbl PO_TBL_VARCHAR30, -- 9294987 bug
480
481 -- attributes added for item processing(read from line)
482 --ln_qty_rcv_tolerance_tbl PO_TBL_NUMBER,
483 ln_unit_weight_tbl PO_TBL_NUMBER,
484 ln_unit_volume_tbl PO_TBL_NUMBER,
485 ln_item_attribute_category_tbl PO_TBL_VARCHAR2000,
486 ln_item_attribute1_tbl PO_TBL_VARCHAR2000,
487 ln_item_attribute2_tbl PO_TBL_VARCHAR2000,
488 ln_item_attribute3_tbl PO_TBL_VARCHAR2000,
489 ln_item_attribute4_tbl PO_TBL_VARCHAR2000,
490 ln_item_attribute5_tbl PO_TBL_VARCHAR2000,
491 ln_item_attribute6_tbl PO_TBL_VARCHAR2000,
492 ln_item_attribute7_tbl PO_TBL_VARCHAR2000,
493 ln_item_attribute8_tbl PO_TBL_VARCHAR2000,
494 ln_item_attribute9_tbl PO_TBL_VARCHAR2000,
495 ln_item_attribute10_tbl PO_TBL_VARCHAR2000,
496 ln_item_attribute11_tbl PO_TBL_VARCHAR2000,
497 ln_item_attribute12_tbl PO_TBL_VARCHAR2000,
498 ln_item_attribute13_tbl PO_TBL_VARCHAR2000,
499 ln_item_attribute14_tbl PO_TBL_VARCHAR2000,
500 ln_item_attribute15_tbl PO_TBL_VARCHAR2000,
501 ln_item_tbl PO_TBL_VARCHAR2000,
502 ln_item_desc_tbl PO_TBL_VARCHAR2000,
503 ln_list_price_per_unit_tbl PO_TBL_NUMBER,
504 ln_market_price_tbl PO_TBL_NUMBER,
505 ln_un_number_id_tbl PO_TBL_NUMBER,
506 ln_hazard_class_id_tbl PO_TBL_NUMBER,
507 ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
508 ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
509 ln_volume_uom_code_tbl PO_TBL_VARCHAR5,
510 ln_template_id_tbl PO_TBL_NUMBER,
511 ln_category_id_tbl PO_TBL_NUMBER,
512 line_ref_index_tbl PO_TBL_NUMBER,
513
514 -- attributes added for processing purpose
515 shipment_num_unique_tbl PO_TBL_VARCHAR1,
516 error_flag_tbl PO_TBL_VARCHAR1,
517 rec_count NUMBER,
518 intf_id_index_tbl DBMS_SQL.NUMBER_TABLE
519
520
521 -- ATTENTION: If you are adding new attributes to this record type, see
522 -- the message above first.
523 );
524
525 -- type defined for distribution record
526
527 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
528 -- that the procedure fill_all_dists_attr is also changed to init
532 intf_dist_id_tbl PO_TBL_NUMBER,
529 -- the table
530 TYPE distributions_rec_type IS RECORD
531 (
533 intf_header_id_tbl PO_TBL_NUMBER,
534 intf_line_id_tbl PO_TBL_NUMBER,
535 intf_line_loc_id_tbl PO_TBL_NUMBER,
536 po_dist_id_tbl PO_TBL_NUMBER,
537 dist_num_tbl PO_TBL_NUMBER,
538 deliver_to_loc_tbl PO_TBL_VARCHAR100,
539 deliver_to_loc_id_tbl PO_TBL_NUMBER,
540 deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
541 deliver_to_person_id_tbl PO_TBL_NUMBER,
542 dest_type_tbl PO_TBL_VARCHAR30,
543 dest_type_code_tbl PO_TBL_VARCHAR30,
544 dest_org_tbl PO_TBL_VARCHAR100,
545 dest_org_id_tbl PO_TBL_NUMBER,
546 wip_entity_tbl PO_TBL_VARCHAR2000,
547 wip_entity_id_tbl PO_TBL_NUMBER,
548 wip_line_code_tbl PO_TBL_VARCHAR30,
549 wip_line_id_tbl PO_TBL_NUMBER,
550 bom_resource_code_tbl PO_TBL_VARCHAR30,
551 bom_resource_id_tbl PO_TBL_NUMBER,
552 charge_account_tbl PO_TBL_VARCHAR2000,
553 charge_account_id_tbl PO_TBL_NUMBER,
554 dest_charge_account_id_tbl PO_TBL_NUMBER,
555 project_accounting_context_tbl PO_TBL_VARCHAR30,
556 award_num_tbl PO_TBL_VARCHAR30,
557 award_id_tbl PO_TBL_NUMBER,
558 project_tbl PO_TBL_VARCHAR30,
559 project_id_tbl PO_TBL_NUMBER,
560 task_tbl PO_TBL_VARCHAR2000, --- Bug#16505809
561 task_id_tbl PO_TBL_NUMBER,
562 expenditure_tbl PO_TBL_VARCHAR100,
563 expenditure_type_tbl PO_TBL_VARCHAR30,
564 expenditure_org_tbl PO_TBL_VARCHAR100,
565 expenditure_org_id_tbl PO_TBL_NUMBER,
566 expenditure_item_date_tbl PO_TBL_DATE,
567 end_item_unit_number_tbl PO_TBL_VARCHAR30,
568 dest_context_tbl PO_TBL_VARCHAR30,
569 gl_encumbered_date_tbl PO_TBL_DATE,
570 gl_encumbered_period_tbl PO_TBL_VARCHAR30,
571 variance_account_id_tbl PO_TBL_NUMBER,
572 accrual_account_id_tbl PO_TBL_NUMBER,
573 budget_account_id_tbl PO_TBL_NUMBER,
574 dest_variance_account_id_tbl PO_TBL_NUMBER,
575 dest_subinventory_tbl PO_TBL_VARCHAR30,
576 amount_ordered_tbl PO_TBL_NUMBER,
577 quantity_ordered_tbl PO_TBL_NUMBER,
578 wip_rep_schedule_id_tbl PO_TBL_NUMBER,
579 wip_operation_seq_num_tbl PO_TBL_NUMBER,
580 wip_resource_seq_num_tbl PO_TBL_NUMBER,
581 prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
582 recovery_rate_tbl PO_TBL_NUMBER,
583 tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
584 account_segment1_tbl PO_TBL_VARCHAR30,
585 account_segment2_tbl PO_TBL_VARCHAR30,
586 account_segment3_tbl PO_TBL_VARCHAR30,
587 account_segment4_tbl PO_TBL_VARCHAR30,
588 account_segment5_tbl PO_TBL_VARCHAR30,
589 account_segment6_tbl PO_TBL_VARCHAR30,
590 account_segment7_tbl PO_TBL_VARCHAR30,
591 account_segment8_tbl PO_TBL_VARCHAR30,
592 account_segment9_tbl PO_TBL_VARCHAR30,
593 account_segment10_tbl PO_TBL_VARCHAR30,
594 account_segment11_tbl PO_TBL_VARCHAR30,
595 account_segment12_tbl PO_TBL_VARCHAR30,
596 account_segment13_tbl PO_TBL_VARCHAR30,
597 account_segment14_tbl PO_TBL_VARCHAR30,
598 account_segment15_tbl PO_TBL_VARCHAR30,
599 account_segment16_tbl PO_TBL_VARCHAR30,
600 account_segment17_tbl PO_TBL_VARCHAR30,
601 account_segment18_tbl PO_TBL_VARCHAR30,
602 account_segment19_tbl PO_TBL_VARCHAR30,
603 account_segment20_tbl PO_TBL_VARCHAR30,
604 account_segment21_tbl PO_TBL_VARCHAR30,
605 account_segment22_tbl PO_TBL_VARCHAR30,
606 account_segment23_tbl PO_TBL_VARCHAR30,
607 account_segment24_tbl PO_TBL_VARCHAR30,
608 account_segment25_tbl PO_TBL_VARCHAR30,
609 account_segment26_tbl PO_TBL_VARCHAR30,
610 account_segment27_tbl PO_TBL_VARCHAR30,
611 account_segment28_tbl PO_TBL_VARCHAR30,
612 account_segment29_tbl PO_TBL_VARCHAR30,
613 account_segment30_tbl PO_TBL_VARCHAR30,
614 dist_attribute1_tbl PO_TBL_VARCHAR2000,
615 dist_attribute2_tbl PO_TBL_VARCHAR2000,
616 dist_attribute3_tbl PO_TBL_VARCHAR2000,
617 dist_attribute4_tbl PO_TBL_VARCHAR2000,
618 dist_attribute5_tbl PO_TBL_VARCHAR2000,
619 dist_attribute6_tbl PO_TBL_VARCHAR2000,
620 dist_attribute7_tbl PO_TBL_VARCHAR2000,
621 dist_attribute8_tbl PO_TBL_VARCHAR2000,
622 dist_attribute9_tbl PO_TBL_VARCHAR2000,
623 dist_attribute10_tbl PO_TBL_VARCHAR2000,
624 dist_attribute11_tbl PO_TBL_VARCHAR2000,
625 dist_attribute12_tbl PO_TBL_VARCHAR2000,
626 dist_attribute13_tbl PO_TBL_VARCHAR2000,
627 dist_attribute14_tbl PO_TBL_VARCHAR2000,
628 dist_attribute15_tbl PO_TBL_VARCHAR2000,
629
630 -- CLM Partial Funding Changes
631 partial_funded_flag_tbl PO_TBL_VARCHAR1,
632 funded_value_tbl PO_TBL_NUMBER,
633
634 -- ACRN proj
635 ACRN_tbl PO_TBL_VARCHAR30,
636
637 -- standard who columns
638 last_updated_by_tbl PO_TBL_NUMBER,
639 last_update_date_tbl PO_TBL_DATE,
640 last_update_login_tbl PO_TBL_NUMBER,
641 creation_date_tbl PO_TBL_DATE,
642 created_by_tbl PO_TBL_NUMBER,
643 request_id_tbl PO_TBL_NUMBER,
644 program_application_id_tbl PO_TBL_NUMBER,
648 -- attributes exist in txn table but not in interface table
645 program_id_tbl PO_TBL_NUMBER,
646 program_update_date_tbl PO_TBL_DATE,
647
649 tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
650 award_set_id_tbl PO_TBL_NUMBER, -- bug5201306
651
652 -- attributes read from line location record
653 loc_ship_to_org_id_tbl PO_TBL_NUMBER,
654 loc_line_loc_id_tbl PO_TBL_NUMBER,
655 loc_shipment_type_tbl PO_TBL_VARCHAR30,
656 loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
657 loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
658 loc_need_by_date_tbl PO_TBL_DATE,
659 loc_promised_date_tbl PO_TBL_DATE,
660 loc_price_override_tbl PO_TBL_NUMBER,
661 loc_outsourced_assembly_tbl PO_TBL_NUMBER,
662 loc_attribute1_tbl PO_TBL_VARCHAR2000,
663 loc_attribute2_tbl PO_TBL_VARCHAR2000,
664 loc_attribute3_tbl PO_TBL_VARCHAR2000,
665 loc_attribute4_tbl PO_TBL_VARCHAR2000,
666 loc_attribute5_tbl PO_TBL_VARCHAR2000,
667 loc_attribute6_tbl PO_TBL_VARCHAR2000,
668 loc_attribute7_tbl PO_TBL_VARCHAR2000,
669 loc_attribute8_tbl PO_TBL_VARCHAR2000,
670 loc_attribute9_tbl PO_TBL_VARCHAR2000,
671 loc_attribute10_tbl PO_TBL_VARCHAR2000,
672 loc_attribute11_tbl PO_TBL_VARCHAR2000,
673 loc_attribute12_tbl PO_TBL_VARCHAR2000,
674 loc_attribute13_tbl PO_TBL_VARCHAR2000,
675 loc_attribute14_tbl PO_TBL_VARCHAR2000,
676 loc_attribute15_tbl PO_TBL_VARCHAR2000,
677
678 -- attributes read from line record
679 ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
680 ln_purchase_basis_tbl PO_TBL_VARCHAR30,
681 ln_item_id_tbl PO_TBL_NUMBER,
682 ln_category_id_tbl PO_TBL_NUMBER,
683 ln_line_type_id_tbl PO_TBL_NUMBER,
684 ln_po_line_id_tbl PO_TBL_NUMBER,
685 ln_attribute1_tbl PO_TBL_VARCHAR2000,
686 ln_attribute2_tbl PO_TBL_VARCHAR2000,
687 ln_attribute3_tbl PO_TBL_VARCHAR2000,
688 ln_attribute4_tbl PO_TBL_VARCHAR2000,
689 ln_attribute5_tbl PO_TBL_VARCHAR2000,
690 ln_attribute6_tbl PO_TBL_VARCHAR2000,
691 ln_attribute7_tbl PO_TBL_VARCHAR2000,
692 ln_attribute8_tbl PO_TBL_VARCHAR2000,
693 ln_attribute9_tbl PO_TBL_VARCHAR2000,
694 ln_attribute10_tbl PO_TBL_VARCHAR2000,
695 ln_attribute11_tbl PO_TBL_VARCHAR2000,
696 ln_attribute12_tbl PO_TBL_VARCHAR2000,
697 ln_attribute13_tbl PO_TBL_VARCHAR2000,
698 ln_attribute14_tbl PO_TBL_VARCHAR2000,
699 ln_attribute15_tbl PO_TBL_VARCHAR2000,
700
701 -- attributes read from header record
702 draft_id_tbl PO_TBL_NUMBER,
703 hd_agent_id_tbl PO_TBL_NUMBER,
704 hd_po_header_id_tbl PO_TBL_NUMBER,
705 hd_rate_date_tbl PO_TBL_DATE,
706 hd_rate_tbl PO_TBL_NUMBER,
707 hd_type_lookup_code_tbl PO_TBL_VARCHAR30,
708 hd_vendor_id_tbl PO_TBL_NUMBER,
709 hd_attribute1_tbl PO_TBL_VARCHAR2000,
710 hd_attribute2_tbl PO_TBL_VARCHAR2000,
711 hd_attribute3_tbl PO_TBL_VARCHAR2000,
712 hd_attribute4_tbl PO_TBL_VARCHAR2000,
713 hd_attribute5_tbl PO_TBL_VARCHAR2000,
714 hd_attribute6_tbl PO_TBL_VARCHAR2000,
715 hd_attribute7_tbl PO_TBL_VARCHAR2000,
716 hd_attribute8_tbl PO_TBL_VARCHAR2000,
717 hd_attribute9_tbl PO_TBL_VARCHAR2000,
718 hd_attribute10_tbl PO_TBL_VARCHAR2000,
719 hd_attribute11_tbl PO_TBL_VARCHAR2000,
720 hd_attribute12_tbl PO_TBL_VARCHAR2000,
721 hd_attribute13_tbl PO_TBL_VARCHAR2000,
722 hd_attribute14_tbl PO_TBL_VARCHAR2000,
723 hd_attribute15_tbl PO_TBL_VARCHAR2000,
724
725 -- CLM Partial Funding Changes
726 hd_style_id_tbl PO_TBL_NUMBER,
727
728 -- attributes added for processing
729 ship_to_ou_id_tbl PO_TBL_NUMBER,
730 ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
731 item_status_tbl PO_TBL_VARCHAR1,
732 gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
733 dist_num_unique_tbl PO_TBL_VARCHAR1,
734 error_flag_tbl PO_TBL_VARCHAR1,
735 rec_count NUMBER,
736
737 --attributes added for pdoi clm integration
738 clm_defence_funding_tbl PO_TBL_VARCHAR30,
739 clm_fms_case_number_tbl PO_TBL_VARCHAR240,
740 clm_agency_acct_identifier_tbl PO_TBL_VARCHAR100,
741 clm_misc_loa_tbl PO_TBL_VARCHAR240,
742 group_line_id_tbl PO_TBL_NUMBER,
743 quantity_funded_tbl PO_TBL_NUMBER,
744 amount_funded_tbl PO_TBL_NUMBER
745
746 -- ATTENTION: If you are adding new attributes to this record type, see
747 -- the message above first.
748 );
749
750 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
751 -- that the procedure fill_all_price_diffs_attr is also changed to
752 -- init the table
753 TYPE price_diffs_rec_type IS RECORD
754 (
755 intf_price_diff_id_tbl PO_TBL_NUMBER,
756 intf_line_id_tbl PO_TBL_NUMBER, -- bug 5215781
757 intf_header_id_tbl PO_TBL_NUMBER, -- bug 5215781
758 price_diff_num_tbl PO_TBL_NUMBER,
759 price_type_tbl PO_TBL_VARCHAR30,
760 entity_type_tbl PO_TBL_VARCHAR30,
761 entity_id_tbl PO_TBL_NUMBER,
762 multiplier_tbl PO_TBL_NUMBER,
763 min_multiplier_tbl PO_TBL_NUMBER,
767 loc_line_loc_id_tbl PO_TBL_NUMBER,
764 max_multiplier_tbl PO_TBL_NUMBER,
765
766 -- attribute read from line location
768
769 -- attributes read from line record
770 ln_po_line_id_tbl PO_TBL_NUMBER,
771
772 -- attributes read from header record
773 draft_id_tbl PO_TBL_NUMBER,
774 hd_style_id_tbl PO_TBL_NUMBER,
775
776 -- attributes added for processing
777 error_flag_tbl PO_TBL_VARCHAR1,
778 price_diff_num_unique_tbl PO_TBL_VARCHAR1,
779 rec_count NUMBER
780
781 -- ATTENTION: If you are adding new attributes to this record type, see
782 -- the message above first.
783 );
784
785 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
786 -- that the procedure fill_all_attr_values_attr is also changed to
787 -- init the table
788 TYPE attr_values_rec_type IS RECORD
789 (
790 -- attribute from attr_values table
791 intf_attr_values_id_tbl PO_TBL_NUMBER,
792 org_id_tbl PO_TBL_NUMBER,
793
794 -- attributes from line record
795 ln_po_line_id_tbl PO_TBL_NUMBER,
796 ln_ip_category_id_tbl PO_TBL_NUMBER,
797 ln_item_id_tbl PO_TBL_NUMBER,
798
799 -- attribute from header record
800 draft_id_tbl PO_TBL_NUMBER,
801
802 -- attributes added for processing purpose
803 attribute_values_id_tbl PO_TBL_NUMBER,
804 source_tbl DBMS_SQL.VARCHAR2_TABLE,
805 error_flag_tbl PO_TBL_VARCHAR1,
806
807 rec_count NUMBER
808
809 -- ATTENTION: If you are adding new attributes to this record type, see
810 -- the message above first.
811 );
812
813 -- ATTENTION: Whenever a new attribute is added to this record type, make sure
814 -- that the procedure fill_all_attr_values_tlp_attr is also changed
815 -- to init the table
816 TYPE attr_values_tlp_rec_type IS RECORD
817 (
818 -- attribute from attr_values table
819 intf_attr_values_tlp_id_tbl PO_TBL_NUMBER,
820 language_tbl PO_TBL_VARCHAR5,
821 org_id_tbl PO_TBL_NUMBER,
822
823 -- attribute from line
824 ln_po_line_id_tbl PO_TBL_NUMBER,
825 ln_ip_category_id_tbl PO_TBL_NUMBER,
826 ln_item_id_tbl PO_TBL_NUMBER,
827 ln_item_desc_tbl PO_TBL_VARCHAR2000,
828 ln_item_long_desc_tbl PO_TBL_VARCHAR2000, -- Bug7722053
829
830 -- attribute from headers
831 draft_id_tbl PO_TBL_NUMBER,
832
833 -- attributes added for processing purpose
834 error_flag_tbl PO_TBL_VARCHAR1,
835 attribute_values_tlp_id_tbl PO_TBL_NUMBER,
836 source_tbl DBMS_SQL.VARCHAR2_TABLE,
837
838 rec_count NUMBER
839
840 -- ATTENTION: If you are adding new attributes to this record type, see
841 -- the message above first.
842 );
843
844 -- type defined for cursor variable
845 TYPE intf_cursor_type IS REF CURSOR;
846 TYPE varchar_index_tbl_type IS TABLE OF NUMBER INDEX BY VARCHAR2(30);
847
848
849 -- PROCEDURES that initialize the pl/sql tables within the record, allocating
850 -- memory for the tables indicated by the parameter that specifies
851 -- the number of records the structure will hold
852
853 -- bug5106386 START
854 PROCEDURE fill_all_headers_attr
855 ( p_num_records IN NUMBER,
856 x_headers IN OUT NOCOPY headers_rec_type
857 );
858
859 PROCEDURE fill_all_lines_attr
860 ( p_num_records IN NUMBER,
861 x_lines IN OUT NOCOPY lines_rec_type
862 );
863
864 PROCEDURE fill_all_line_locs_attr
865 ( p_num_records IN NUMBER,
866 x_line_locs IN OUT NOCOPY line_locs_rec_type
867 );
868
869 PROCEDURE fill_all_dists_attr
870 ( p_num_records IN NUMBER,
871 x_dists IN OUT NOCOPY distributions_rec_type
872 );
873
874 PROCEDURE fill_all_price_diffs_attr
875 ( p_num_records IN NUMBER,
876 x_price_diffs IN OUT NOCOPY price_diffs_rec_type
877 );
878
879 PROCEDURE fill_all_attr_values_attr
880 ( p_num_records IN NUMBER,
881 x_attr_values IN OUT NOCOPY attr_values_rec_type
882 );
883
884 PROCEDURE fill_all_attr_values_tlp_attr
885 ( p_num_records IN NUMBER,
886 x_attr_values_tlp IN OUT NOCOPY attr_values_tlp_rec_type
887 );
888
889 -- bug5106386 END
890
891 END PO_PDOI_TYPES;