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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
260: group_line_id_tbl PO_TBL_NUMBER,
261: line_num_display_tbl PO_TBL_VARCHAR100,
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,
260: group_line_id_tbl PO_TBL_NUMBER,
261: line_num_display_tbl PO_TBL_VARCHAR100,
262: clm_info_flag_tbl PO_TBL_VARCHAR1,
263: clm_option_indicator_tbl PO_TBL_VARCHAR1,
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,
260: group_line_id_tbl PO_TBL_NUMBER,
261: line_num_display_tbl PO_TBL_VARCHAR100,
262: clm_info_flag_tbl PO_TBL_VARCHAR1,
263: clm_option_indicator_tbl PO_TBL_VARCHAR1,
264: clm_base_line_num_tbl PO_TBL_NUMBER,
260: group_line_id_tbl PO_TBL_NUMBER,
261: line_num_display_tbl PO_TBL_VARCHAR100,
262: clm_info_flag_tbl PO_TBL_VARCHAR1,
263: clm_option_indicator_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,
261: line_num_display_tbl PO_TBL_VARCHAR100,
262: clm_info_flag_tbl PO_TBL_VARCHAR1,
263: clm_option_indicator_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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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:
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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.
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,
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,
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:
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:
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,
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,
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,
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,
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,
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,
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:
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,
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,
387: group_num_tbl PO_TBL_NUMBER,
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,
387: group_num_tbl PO_TBL_NUMBER,
388: match_line_found_tbl PO_TBL_VARCHAR1,
389: line_num_unique_tbl PO_TBL_VARCHAR1,
390:
383: line_loc_id_tbl po_tbl_number,
384:
385: -- attributes added for uniqueness checking
386: origin_line_num_tbl PO_TBL_NUMBER,
387: group_num_tbl PO_TBL_NUMBER,
388: match_line_found_tbl PO_TBL_VARCHAR1,
389: line_num_unique_tbl PO_TBL_VARCHAR1,
390:
391: -- attributes added for processing purpose
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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,
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
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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:
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
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,
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,
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,
503: ln_line_type_id_tbl PO_TBL_NUMBER,
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,
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,
506: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
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,
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,
506: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
507: ln_matching_basis_tbl PO_TBL_VARCHAR30,
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:
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
617: end_item_unit_number_tbl PO_TBL_VARCHAR30,
618: dest_context_tbl PO_TBL_VARCHAR30,
619: encumbered_flag_tbl PO_TBL_VARCHAR1,
618: dest_context_tbl PO_TBL_VARCHAR30,
619: encumbered_flag_tbl PO_TBL_VARCHAR1,
620: gl_encumbered_date_tbl PO_TBL_DATE,
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,
619: encumbered_flag_tbl PO_TBL_VARCHAR1,
620: gl_encumbered_date_tbl PO_TBL_DATE,
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,
620: gl_encumbered_date_tbl PO_TBL_DATE,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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
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,
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:
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
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,
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,
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,
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,
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,
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,
728:
729: -- attributes read from line record
730: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
731: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
732: ln_item_id_tbl PO_TBL_NUMBER,
733: ln_category_id_tbl PO_TBL_NUMBER,
734: ln_line_type_id_tbl PO_TBL_NUMBER,
735: ln_po_line_id_tbl PO_TBL_NUMBER,
736: ln_attribute1_tbl PO_TBL_VARCHAR2000,
729: -- attributes read from line record
730: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
731: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
732: ln_item_id_tbl PO_TBL_NUMBER,
733: ln_category_id_tbl PO_TBL_NUMBER,
734: ln_line_type_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,
730: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
731: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
732: ln_item_id_tbl PO_TBL_NUMBER,
733: ln_category_id_tbl PO_TBL_NUMBER,
734: ln_line_type_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,
731: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
732: ln_item_id_tbl PO_TBL_NUMBER,
733: ln_category_id_tbl PO_TBL_NUMBER,
734: ln_line_type_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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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
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:
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,
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,
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,
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,
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,
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
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,
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:
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,
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
866:
867: TYPE attr_values_tlp_rec_type IS RECORD
868: (
869: -- attribute from attr_values table
870: intf_attr_values_tlp_id_tbl PO_TBL_NUMBER,
871: language_tbl PO_TBL_VARCHAR5,
872: org_id_tbl PO_TBL_NUMBER,
873:
874: -- attribute from line
868: (
869: -- attribute from attr_values table
870: intf_attr_values_tlp_id_tbl PO_TBL_NUMBER,
871: language_tbl PO_TBL_VARCHAR5,
872: org_id_tbl PO_TBL_NUMBER,
873:
874: -- attribute from line
875: ln_po_line_id_tbl PO_TBL_NUMBER,
876: ln_ip_category_id_tbl PO_TBL_NUMBER,
871: language_tbl PO_TBL_VARCHAR5,
872: org_id_tbl PO_TBL_NUMBER,
873:
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,
872: org_id_tbl PO_TBL_NUMBER,
873:
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:
873:
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
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,
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: