DBA Data[Home] [Help]

APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_EXT_SELL_INVS_V

Line 94: customer_id okl_ext_sell_invs_v.customer_id%TYPE,

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,

Line 95: currency okl_ext_sell_invs_v.currency_code%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,

Line 96: bill_to_site okl_ext_sell_invs_v.customer_address_id%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

Line 97: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,

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,

Line 98: private_label okl_ext_sell_invs_v.xtrx_private_label%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,

Line 99: date_consolidated okl_ext_sell_invs_v.TRX_DATE%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,

Line 105: org_id okl_ext_sell_invs_v.org_id%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,

Line 106: set_of_books_id okl_ext_sell_invs_v.set_of_books_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,

Line 109: xsi_id okl_ext_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

Line 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;

Line 120: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,

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,

Line 121: l_currency okl_ext_sell_invs_v.currency_code%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,

Line 122: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%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

Line 123: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,

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,

Line 124: l_private_label okl_ext_sell_invs_v.xtrx_private_label%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,

Line 125: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%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,