44: p_contract_number IN VARCHAR2 DEFAULT NULL
45: ); */
46:
47: TYPE ie_rec_type1 IS RECORD
48: ( tai_id okl_trx_ar_invoices_v.id%TYPE
49: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
50: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
51: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
52: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
45: ); */
46:
47: TYPE ie_rec_type1 IS RECORD
48: ( tai_id okl_trx_ar_invoices_v.id%TYPE
49: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
50: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
51: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
52: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
53: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
46:
47: TYPE ie_rec_type1 IS RECORD
48: ( tai_id okl_trx_ar_invoices_v.id%TYPE
49: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
50: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
51: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
52: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
53: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
54: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
47: TYPE ie_rec_type1 IS RECORD
48: ( tai_id okl_trx_ar_invoices_v.id%TYPE
49: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
50: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
51: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
52: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
53: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
54: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
55: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
48: ( tai_id okl_trx_ar_invoices_v.id%TYPE
49: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
50: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
51: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
52: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
53: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
54: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
55: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
56: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
49: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
50: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
51: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
52: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
53: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
54: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
55: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
56: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
57: ,tai_description okl_trx_ar_invoices_v.description%TYPE
50: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
51: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
52: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
53: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
54: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
55: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
56: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
57: ,tai_description okl_trx_ar_invoices_v.description%TYPE
58: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
51: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
52: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
53: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
54: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
55: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
56: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
57: ,tai_description okl_trx_ar_invoices_v.description%TYPE
58: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
59: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
52: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
53: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
54: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
55: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
56: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
57: ,tai_description okl_trx_ar_invoices_v.description%TYPE
58: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
59: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
60: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
53: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
54: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
55: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
56: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
57: ,tai_description okl_trx_ar_invoices_v.description%TYPE
58: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
59: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
60: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
61: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
54: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
55: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
56: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
57: ,tai_description okl_trx_ar_invoices_v.description%TYPE
58: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
59: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
60: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
61: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
62: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
55: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
56: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
57: ,tai_description okl_trx_ar_invoices_v.description%TYPE
58: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
59: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
60: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
61: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
62: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
63: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
56: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
57: ,tai_description okl_trx_ar_invoices_v.description%TYPE
58: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
59: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
60: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
61: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
62: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
63: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
64: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
57: ,tai_description okl_trx_ar_invoices_v.description%TYPE
58: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
59: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
60: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
61: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
62: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
63: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
64: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
65: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
58: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
59: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
60: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
61: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
62: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
63: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
64: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
65: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
66: ,til_description okl_txd_ar_ln_dtls_v.description%TYPE
59: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
60: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
61: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
62: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
63: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
64: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
65: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
66: ,til_description okl_txd_ar_ln_dtls_v.description%TYPE
67: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
60: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
61: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
62: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
63: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
64: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
65: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
66: ,til_description okl_txd_ar_ln_dtls_v.description%TYPE
67: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
68: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
78: TYPE ie_tbl_type1 IS TABLE OF ie_rec_type1
79: INDEX BY BINARY_INTEGER;
80:
81: TYPE ie_rec_type2 IS RECORD
82: ( tai_id okl_trx_ar_invoices_v.id%TYPE
83: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
84: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
85: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
86: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
79: INDEX BY BINARY_INTEGER;
80:
81: TYPE ie_rec_type2 IS RECORD
82: ( tai_id okl_trx_ar_invoices_v.id%TYPE
83: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
84: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
85: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
86: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
87: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
80:
81: TYPE ie_rec_type2 IS RECORD
82: ( tai_id okl_trx_ar_invoices_v.id%TYPE
83: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
84: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
85: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
86: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
87: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
88: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
81: TYPE ie_rec_type2 IS RECORD
82: ( tai_id okl_trx_ar_invoices_v.id%TYPE
83: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
84: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
85: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
86: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
87: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
88: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
89: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
82: ( tai_id okl_trx_ar_invoices_v.id%TYPE
83: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
84: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
85: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
86: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
87: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
88: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
89: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
90: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
83: ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
84: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
85: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
86: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
87: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
88: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
89: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
90: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
91: ,tai_description okl_trx_ar_invoices_v.description%TYPE
84: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
85: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
86: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
87: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
88: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
89: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
90: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
91: ,tai_description okl_trx_ar_invoices_v.description%TYPE
92: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
85: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
86: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
87: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
88: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
89: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
90: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
91: ,tai_description okl_trx_ar_invoices_v.description%TYPE
92: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
93: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
86: ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
87: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
88: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
89: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
90: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
91: ,tai_description okl_trx_ar_invoices_v.description%TYPE
92: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
93: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
94: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
87: ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
88: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
89: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
90: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
91: ,tai_description okl_trx_ar_invoices_v.description%TYPE
92: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
93: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
94: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
95: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
88: ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
89: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
90: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
91: ,tai_description okl_trx_ar_invoices_v.description%TYPE
92: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
93: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
94: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
95: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
96: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
89: ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
90: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
91: ,tai_description okl_trx_ar_invoices_v.description%TYPE
92: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
93: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
94: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
95: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
96: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
97: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
90: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
91: ,tai_description okl_trx_ar_invoices_v.description%TYPE
92: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
93: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
94: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
95: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
96: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
97: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
98: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
91: ,tai_description okl_trx_ar_invoices_v.description%TYPE
92: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
93: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
94: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
95: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
96: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
97: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
98: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
99: ,til_id okl_txl_ar_inv_lns_v.id%TYPE
92: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
93: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
94: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
95: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
96: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
97: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
98: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
99: ,til_id okl_txl_ar_inv_lns_v.id%TYPE
100: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
93: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
94: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
95: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
96: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
97: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
98: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
99: ,til_id okl_txl_ar_inv_lns_v.id%TYPE
100: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
101: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
94: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
95: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
96: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
97: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
98: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
99: ,til_id okl_txl_ar_inv_lns_v.id%TYPE
100: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
101: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
102: ,til_description okl_txl_ar_inv_lns_v.description%TYPE
107: ,taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE
108: ,inventory_item_id okl_txl_ar_inv_lns_v.inventory_item_id%TYPE
109: ,inventory_org_id okl_txl_ar_inv_lns_v.inventory_org_id%TYPE
110: ,bank_acct_id okl_txl_ar_inv_lns_v.bank_acct_id%TYPE
111: ,qte_id okl_trx_ar_invoices_v.qte_id%TYPE
112: );
113: TYPE ie_tbl_type2 IS TABLE OF ie_rec_type2
114: INDEX BY BINARY_INTEGER;
115: