APPS.OKL_BILL_UPFRONT_TAX_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 58: -- okl_trx_ar_invoices_b

54: --
55: -- Procedure Name : additional_tai_attr
56: -- Description : private procedure to populate additional hdr attr
57: -- Business Rules : populates all additional attributes for
58: -- okl_trx_ar_invoices_b
59: -- Parameters : p_taiv_rec
60: -- Version : 1.0
61: -- History : akrangan created
62: --

Line 79: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;

75: l_api_name CONSTANT VARCHAR2(30) := 'additional_tai_attr';
76: l_api_version CONSTANT NUMBER := 1.0;
77: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
78:
79: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;
80:
81: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
82: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
83: l_object1_id1 okc_rules_b.object1_id1%TYPE;

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

151: FROM RA_TERMS_TL T, RA_TERMS_B B
152: where T.name = 'IMMEDIATE' and T.LANGUAGE = userenv('LANG')
153: and B.TERM_ID = T.TERM_ID;
154:
155: l_term_id okl_trx_ar_invoices_b.irt_id%type; -- cklee 3/20/07
156:
157: CURSOR rcpt_method_csr(p_rct_method_id NUMBER) IS
158: SELECT c.creation_method_code
159: FROM ar_receipt_methods m,

Line 169: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;

165:
166: --Start code added by pgomes on 20-NOV-2002
167: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
168: l_khr_id khr_id_type;
169: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
170: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
171: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
172: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
173:

Line 170: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;

166: --Start code added by pgomes on 20-NOV-2002
167: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
168: l_khr_id khr_id_type;
169: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
170: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
171: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
172: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
173:
174: --Get currency conversion attributes for a contract

Line 171: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;

167: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
168: l_khr_id khr_id_type;
169: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
170: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
171: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
172: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
173:
174: --Get currency conversion attributes for a contract
175: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS

Line 172: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;

168: l_khr_id khr_id_type;
169: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
170: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
171: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
172: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
173:
174: --Get currency conversion attributes for a contract
175: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS
176: SELECT currency_code,