APPS.OKL_BILL_UPFRONT_TAX_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 67: -- okl_trx_ar_invoices_b

63: --
64: -- Procedure Name : additional_tai_attr
65: -- Description : private procedure to populate additional hdr attr
66: -- Business Rules : populates all additional attributes for
67: -- okl_trx_ar_invoices_b
68: -- Parameters : p_taiv_rec
69: -- Version : 1.0
70: -- History : akrangan created
71: --

Line 88: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;

84: l_api_name CONSTANT VARCHAR2(30) := 'additional_tai_attr';
85: l_api_version CONSTANT NUMBER := 1.0;
86: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
87:
88: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;
89:
90: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
91: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
92: l_object1_id1 okc_rules_b.object1_id1%TYPE;

Line 164: l_term_id okl_trx_ar_invoices_b.irt_id%type; -- cklee 3/20/07

160: FROM RA_TERMS_TL T, RA_TERMS_B B
161: where T.name = 'IMMEDIATE' and T.LANGUAGE = userenv('LANG')
162: and B.TERM_ID = T.TERM_ID;
163:
164: l_term_id okl_trx_ar_invoices_b.irt_id%type; -- cklee 3/20/07
165:
166: CURSOR rcpt_method_csr(p_rct_method_id NUMBER) IS
167: SELECT c.creation_method_code
168: FROM ar_receipt_methods m,

Line 178: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;

174:
175: --Start code added by pgomes on 20-NOV-2002
176: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
177: l_khr_id khr_id_type;
178: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
179: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
180: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
181: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
182:

Line 179: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;

175: --Start code added by pgomes on 20-NOV-2002
176: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
177: l_khr_id khr_id_type;
178: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
179: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
180: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
181: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
182:
183: --Get currency conversion attributes for a contract

Line 180: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;

176: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
177: l_khr_id khr_id_type;
178: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
179: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
180: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
181: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
182:
183: --Get currency conversion attributes for a contract
184: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS

Line 181: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;

177: l_khr_id khr_id_type;
178: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
179: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
180: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
181: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
182:
183: --Get currency conversion attributes for a contract
184: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS
185: SELECT currency_code,