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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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:
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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:
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
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,
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,
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,
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,
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,
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,
298: hd_rate_tbl PO_TBL_NUMBER, -- bug 9194215
299:
300: -- attributes added for location processing
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,
298: hd_rate_tbl PO_TBL_NUMBER, -- bug 9194215
299:
300: -- attributes added for location processing
301: create_line_loc_tbl PO_TBL_VARCHAR1,
302:
300: -- attributes added for location processing
301: create_line_loc_tbl PO_TBL_VARCHAR1,
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 */
301: create_line_loc_tbl PO_TBL_VARCHAR1,
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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: );
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
415: payment_type_tbl PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
416:
417: -- attributes in txn table but not in interface table
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
416:
417: -- attributes in txn table but not in interface table
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,
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,
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,
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,
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:
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
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,
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,
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 >
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,
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,
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,
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,
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,
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:
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
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,
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>
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
528: -- that the procedure fill_all_dists_attr is also changed to init
529: -- the table
530: TYPE distributions_rec_type IS RECORD
531: (
532: intf_dist_id_tbl PO_TBL_NUMBER,
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,
529: -- the table
530: TYPE distributions_rec_type IS RECORD
531: (
532: intf_dist_id_tbl PO_TBL_NUMBER,
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,
530: TYPE distributions_rec_type IS RECORD
531: (
532: intf_dist_id_tbl PO_TBL_NUMBER,
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,
531: (
532: intf_dist_id_tbl PO_TBL_NUMBER,
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,
532: intf_dist_id_tbl PO_TBL_NUMBER,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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,
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,
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,
645: program_id_tbl PO_TBL_NUMBER,
646: program_update_date_tbl PO_TBL_DATE,
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,
645: program_id_tbl PO_TBL_NUMBER,
646: program_update_date_tbl PO_TBL_DATE,
647:
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,
645: program_id_tbl PO_TBL_NUMBER,
646: program_update_date_tbl PO_TBL_DATE,
647:
648: -- attributes exist in txn table but not in interface table
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,
645: program_id_tbl PO_TBL_NUMBER,
646: program_update_date_tbl PO_TBL_DATE,
647:
648: -- attributes exist in txn table but not in interface table
649: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
646: program_update_date_tbl PO_TBL_DATE,
647:
648: -- attributes exist in txn table but not in interface table
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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.
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: );
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,
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,
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,
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,
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,
764: max_multiplier_tbl PO_TBL_NUMBER,
765:
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,
764: max_multiplier_tbl PO_TBL_NUMBER,
765:
766: -- attribute read from line location
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,
764: max_multiplier_tbl PO_TBL_NUMBER,
765:
766: -- attribute read from line location
767: loc_line_loc_id_tbl PO_TBL_NUMBER,
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,
764: max_multiplier_tbl PO_TBL_NUMBER,
765:
766: -- attribute read from line location
767: loc_line_loc_id_tbl PO_TBL_NUMBER,
768:
763: min_multiplier_tbl PO_TBL_NUMBER,
764: max_multiplier_tbl PO_TBL_NUMBER,
765:
766: -- attribute read from line location
767: loc_line_loc_id_tbl PO_TBL_NUMBER,
768:
769: -- attributes read from line record
770: ln_po_line_id_tbl PO_TBL_NUMBER,
771:
766: -- attribute read from line location
767: loc_line_loc_id_tbl PO_TBL_NUMBER,
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,
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,
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,
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,
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,
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
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,
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:
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,
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
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
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,
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
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:
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
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,
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: