DBA Data[Home] [Help]

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 219: open c_ap_invoice_lines_all

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

Line 221: fetch c_ap_invoice_lines_all into r_ap_invoice_lines_all;

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

Line 222: close c_ap_invoice_lines_all;

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

Line 225: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);

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

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

234: (cur_rec_invoice_line.invoice_id, cur_rec_invoice_line.invoice_line_number, cur_rec_invoice_line.distribution_line_number);
235: fetch c_ap_invoice_distributions_all into ln_distribution_amount;
236: close c_ap_invoice_distributions_all;
237:
238: ln_apportion_factor := ln_apportion_factor * (ln_distribution_amount / r_ap_invoice_lines_all.amount); /*rchandan for bug#4454657*/
239:
240: ln_no_of_tax_for_inv_line := 0;
241:
242: for cur_rec_taxes in