APPS.JAI_FA_ASSETS_PKG dependencies on AP_INVOICE_LINES_ALL

Line 20: The ap_invoice_lines_all is used instead of ap_invoice_distributions_all while querying wherever applicable.

16:
17: 24-Jun-2005 rchandan for bug#4454657, Version 116.4
18: Modified the object as a part of AP LINES Impact Uptake
19: A column invoice_line_number ie added to jai_fa_mass_additions.
20: The ap_invoice_lines_all is used instead of ap_invoice_distributions_all while querying wherever applicable.
21: While calculating the apportion factor the distribution amount is taken instead of line amount.
22:
23: 10 07/12/2005 Hjujjuru for the bug 4866533 File version 120.2
24: added the who columns in the insert into table JAI_RCV_CENVAT_CLAIM_T

Line 62: cursor c_ap_invoice_lines_all

58: from ap_invoice_distributions_all
59: where invoice_id = p_invoice_id
60: and distribution_line_number = p_distribution_line_number;*/ /*rchandan for bug#4454657 commented AND the following two CURSORs have been added */
61:
62: cursor c_ap_invoice_lines_all
63: (p_invoice_id number, p_line_number number) is
64: select po_distribution_id,
65: rcv_transaction_id,
66: set_of_books_id,

Line 68: from ap_invoice_lines_all

64: select po_distribution_id,
65: rcv_transaction_id,
66: set_of_books_id,
67: amount
68: from ap_invoice_lines_all
69: where invoice_id = p_invoice_id
70: and line_number = p_line_number;
71:
72: CURSOR c_exchange_rate

Line 122: r_ap_invoice_lines_all c_ap_invoice_lines_all%rowtype;

118: cursor c_get_fa_mass_addition_id is
119: select fa_mass_additions_s.nextval
120: from dual;
121:
122: r_ap_invoice_lines_all c_ap_invoice_lines_all%rowtype;
123: r_rcv_transactions c_rcv_transactions%rowtype;
124: r_ja_in_receipt_tax_lines c_ja_in_receipt_tax_lines%rowtype;
125: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
126: ln_no_of_tax_for_inv_line number;

Line 220: open c_ap_invoice_lines_all

216:
217:
218: begin
219:
220: open c_ap_invoice_lines_all
221: (cur_rec_invoice_line.invoice_id, cur_rec_invoice_line.invoice_line_number);
222: fetch c_ap_invoice_lines_all into r_ap_invoice_lines_all;
223: close c_ap_invoice_lines_all;
224:

Line 222: fetch c_ap_invoice_lines_all into r_ap_invoice_lines_all;

218: begin
219:
220: open c_ap_invoice_lines_all
221: (cur_rec_invoice_line.invoice_id, cur_rec_invoice_line.invoice_line_number);
222: fetch c_ap_invoice_lines_all into r_ap_invoice_lines_all;
223: close c_ap_invoice_lines_all;
224:
225:
226: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);

Line 223: close c_ap_invoice_lines_all;

219:
220: open c_ap_invoice_lines_all
221: (cur_rec_invoice_line.invoice_id, cur_rec_invoice_line.invoice_line_number);
222: fetch c_ap_invoice_lines_all into r_ap_invoice_lines_all;
223: close c_ap_invoice_lines_all;
224:
225:
226: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);
227: fetch c_rcv_transactions into r_rcv_transactions;

Line 226: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);

222: fetch c_ap_invoice_lines_all into r_ap_invoice_lines_all;
223: close c_ap_invoice_lines_all;
224:
225:
226: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);
227: fetch c_rcv_transactions into r_rcv_transactions;
228: close c_rcv_transactions;
229:
230: /* Appotion factor between receipt and invoice */

Line 240: if ln_distribution_amount=0 or r_ap_invoice_lines_all.amount=0 then

236: fetch c_ap_invoice_distributions_all into ln_distribution_amount;
237: close c_ap_invoice_distributions_all;
238:
239: /* Bug 14322048 -added below if condition */
240: if ln_distribution_amount=0 or r_ap_invoice_lines_all.amount=0 then
241: ln_apportion_factor :=1;
242: else
243:
244: ln_apportion_factor := ln_apportion_factor * (ln_distribution_amount / r_ap_invoice_lines_all.amount); /*rchandan for bug#4454657*/

Line 244: ln_apportion_factor := ln_apportion_factor * (ln_distribution_amount / r_ap_invoice_lines_all.amount); /*rchandan for bug#4454657*/

240: if ln_distribution_amount=0 or r_ap_invoice_lines_all.amount=0 then
241: ln_apportion_factor :=1;
242: else
243:
244: ln_apportion_factor := ln_apportion_factor * (ln_distribution_amount / r_ap_invoice_lines_all.amount); /*rchandan for bug#4454657*/
245: end if;
246: ln_no_of_tax_for_inv_line := 0;
247:
248: for cur_rec_taxes in