90: -- -------------------------------------------------------------------------
91: -- Consolidated Billing data structure
92: -- -------------------------------------------------------------------------
93: TYPE cons_bill_rec_type IS RECORD (
94: customer_id okl_ext_sell_invs_v.customer_id%TYPE,
95: currency okl_ext_sell_invs_v.currency_code%TYPE,
96: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
97: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
98: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
91: -- Consolidated Billing data structure
92: -- -------------------------------------------------------------------------
93: TYPE cons_bill_rec_type IS RECORD (
94: customer_id okl_ext_sell_invs_v.customer_id%TYPE,
95: currency okl_ext_sell_invs_v.currency_code%TYPE,
96: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
97: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
98: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
99: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
92: -- -------------------------------------------------------------------------
93: TYPE cons_bill_rec_type IS RECORD (
94: customer_id okl_ext_sell_invs_v.customer_id%TYPE,
95: currency okl_ext_sell_invs_v.currency_code%TYPE,
96: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
97: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
98: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
99: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
100: ity_id okl_invoice_types_b.id%TYPE, -- bug 5138822
93: TYPE cons_bill_rec_type IS RECORD (
94: customer_id okl_ext_sell_invs_v.customer_id%TYPE,
95: currency okl_ext_sell_invs_v.currency_code%TYPE,
96: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
97: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
98: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
99: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
100: ity_id okl_invoice_types_b.id%TYPE, -- bug 5138822
101: inf_id okl_invoice_formats_b.id%TYPE,
94: customer_id okl_ext_sell_invs_v.customer_id%TYPE,
95: currency okl_ext_sell_invs_v.currency_code%TYPE,
96: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
97: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
98: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
99: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
100: ity_id okl_invoice_types_b.id%TYPE, -- bug 5138822
101: inf_id okl_invoice_formats_b.id%TYPE,
102: contract_id okc_k_headers_b.id%TYPE,
95: currency okl_ext_sell_invs_v.currency_code%TYPE,
96: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
97: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
98: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
99: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
100: ity_id okl_invoice_types_b.id%TYPE, -- bug 5138822
101: inf_id okl_invoice_formats_b.id%TYPE,
102: contract_id okc_k_headers_b.id%TYPE,
103: contract_number okc_k_headers_b.contract_number%TYPE,
101: inf_id okl_invoice_formats_b.id%TYPE,
102: contract_id okc_k_headers_b.id%TYPE,
103: contract_number okc_k_headers_b.contract_number%TYPE,
104: prev_cons_invoice_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,
105: org_id okl_ext_sell_invs_v.org_id%TYPE,
106: set_of_books_id okl_ext_sell_invs_v.set_of_books_id%TYPE,
107: kle_id okc_k_lines_b.id%TYPE,
108: sty_id okl_strm_type_v.id%TYPE,
109: xsi_id okl_ext_sell_invs_v.id%TYPE,
102: contract_id okc_k_headers_b.id%TYPE,
103: contract_number okc_k_headers_b.contract_number%TYPE,
104: prev_cons_invoice_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,
105: org_id okl_ext_sell_invs_v.org_id%TYPE,
106: set_of_books_id okl_ext_sell_invs_v.set_of_books_id%TYPE,
107: kle_id okc_k_lines_b.id%TYPE,
108: sty_id okl_strm_type_v.id%TYPE,
109: xsi_id okl_ext_sell_invs_v.id%TYPE,
110: xls_id okl_xtl_sell_invs_v.id%TYPE,
105: org_id okl_ext_sell_invs_v.org_id%TYPE,
106: set_of_books_id okl_ext_sell_invs_v.set_of_books_id%TYPE,
107: kle_id okc_k_lines_b.id%TYPE,
108: sty_id okl_strm_type_v.id%TYPE,
109: xsi_id okl_ext_sell_invs_v.id%TYPE,
110: xls_id okl_xtl_sell_invs_v.id%TYPE,
111: amount okl_xtl_sell_invs_v.amount%TYPE,
112: sel_id okl_xtl_sell_invs_v.sel_id%TYPE,
113: legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
109: xsi_id okl_ext_sell_invs_v.id%TYPE,
110: xls_id okl_xtl_sell_invs_v.id%TYPE,
111: amount okl_xtl_sell_invs_v.amount%TYPE,
112: sel_id okl_xtl_sell_invs_v.sel_id%TYPE,
113: legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
114: );
115:
116: TYPE cons_bill_tbl_type IS TABLE OF cons_bill_rec_type
117: INDEX BY BINARY_INTEGER;
116: TYPE cons_bill_tbl_type IS TABLE OF cons_bill_rec_type
117: INDEX BY BINARY_INTEGER;
118:
119: TYPE saved_bill_rec_type IS RECORD (
120: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
121: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
122: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
123: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
124: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
117: INDEX BY BINARY_INTEGER;
118:
119: TYPE saved_bill_rec_type IS RECORD (
120: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
121: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
122: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
123: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
124: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
125: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
118:
119: TYPE saved_bill_rec_type IS RECORD (
120: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
121: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
122: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
123: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
124: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
125: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
126: l_saved_ity_id okl_invoice_types_b.id%TYPE, -- bug 5138822
119: TYPE saved_bill_rec_type IS RECORD (
120: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
121: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
122: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
123: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
124: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
125: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
126: l_saved_ity_id okl_invoice_types_b.id%TYPE, -- bug 5138822
127: l_saved_format_id okl_invoice_formats_v.id%TYPE,
120: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
121: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
122: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
123: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
124: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
125: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
126: l_saved_ity_id okl_invoice_types_b.id%TYPE, -- bug 5138822
127: l_saved_format_id okl_invoice_formats_v.id%TYPE,
128: l_saved_prev_cons_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,
121: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
122: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
123: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
124: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
125: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
126: l_saved_ity_id okl_invoice_types_b.id%TYPE, -- bug 5138822
127: l_saved_format_id okl_invoice_formats_v.id%TYPE,
128: l_saved_prev_cons_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,
129: l_prev_khr_id okc_k_headers_b.id%TYPE,