DBA Data[Home] [Help]

APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_TRX_AR_INVOICES_V

Line 48: ( tai_id okl_trx_ar_invoices_v.id%TYPE

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

Line 49: ,contract_id okl_trx_ar_invoices_v.khr_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

Line 50: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%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

Line 51: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%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

Line 52: ,ixx_id okl_trx_ar_invoices_v.ixx_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

Line 53: ,irm_id okl_trx_ar_invoices_v.irm_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

Line 54: ,irt_id okl_trx_ar_invoices_v.irt_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
58: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE

Line 55: ,ibt_id okl_trx_ar_invoices_v.ibt_id%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

Line 56: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%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

Line 57: ,tai_description okl_trx_ar_invoices_v.description%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

Line 58: ,currency_code okl_trx_ar_invoices_v.currency_code%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

Line 59: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%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

Line 60: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%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
64: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE

Line 61: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%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

Line 62: ,org_id okl_trx_ar_invoices_v.org_id%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

Line 63: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006

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

Line 64: ,trx_number okl_trx_ar_invoices_v.trx_number%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

Line 82: ( tai_id okl_trx_ar_invoices_v.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

Line 83: ,contract_id okl_trx_ar_invoices_v.khr_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

Line 84: ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%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

Line 85: ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%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

Line 86: ,ixx_id okl_trx_ar_invoices_v.ixx_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

Line 87: ,irm_id okl_trx_ar_invoices_v.irm_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

Line 88: ,irt_id okl_trx_ar_invoices_v.irt_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
92: ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE

Line 89: ,ibt_id okl_trx_ar_invoices_v.ibt_id%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

Line 90: ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%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

Line 91: ,tai_description okl_trx_ar_invoices_v.description%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

Line 92: ,currency_code okl_trx_ar_invoices_v.currency_code%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

Line 93: ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%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

Line 94: ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%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
98: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE

Line 95: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%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

Line 96: ,org_id okl_trx_ar_invoices_v.org_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

Line 97: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006

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

Line 98: ,trx_number okl_trx_ar_invoices_v.trx_number%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

Line 111: ,qte_id okl_trx_ar_invoices_v.qte_id%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: