APPS.JAI_FA_ASSETS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_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 51: /* cursor c_ap_invoice_distributions_all

47: where (p_parent_request_id IS NULL OR create_batch_id = p_parent_request_id)
48: and process_flag <> 'Y'
49: FOR UPDATE OF process_flag;
50:
51: /* cursor c_ap_invoice_distributions_all
52: (p_invoice_id number, p_distribution_line_number number) is
53: select po_distribution_id,
54: rcv_transaction_id,
55: invoice_distribution_id,

Line 58: from ap_invoice_distributions_all

54: rcv_transaction_id,
55: invoice_distribution_id,
56: set_of_books_id,
57: exchange_rate
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

Line 78: cursor c_ap_invoice_distributions_all(p_invoice_id number, p_invoice_line_number number, p_distribution_line_number number) is /*rchandan for bug#4428980*/

74: SELECT exchange_rate
75: FROM ap_invoices_all
76: WHERE invoice_id = p_invoice_id;
77:
78: cursor c_ap_invoice_distributions_all(p_invoice_id number, p_invoice_line_number number, p_distribution_line_number number) is /*rchandan for bug#4428980*/
79: select amount
80: from ap_invoice_distributions_all
81: where invoice_id = p_invoice_id
82: and invoice_line_number = p_invoice_line_number

Line 80: from ap_invoice_distributions_all

76: WHERE invoice_id = p_invoice_id;
77:
78: cursor c_ap_invoice_distributions_all(p_invoice_id number, p_invoice_line_number number, p_distribution_line_number number) is /*rchandan for bug#4428980*/
79: select amount
80: from ap_invoice_distributions_all
81: where invoice_id = p_invoice_id
82: and invoice_line_number = p_invoice_line_number
83: and distribution_line_number = p_distribution_line_number;
84:

Line 233: open c_ap_invoice_distributions_all /*rchandan for bug#4454657*/

229: /* Appotion factor between receipt and invoice */
230: ln_apportion_factor :=
231: jai_ap_utils_pkg.get_apportion_factor(cur_rec_invoice_line.invoice_id, cur_rec_invoice_line.invoice_line_number); /*rchandan for bug#4454657*/
232:
233: open c_ap_invoice_distributions_all /*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:

Line 235: fetch c_ap_invoice_distributions_all into ln_distribution_amount;

231: jai_ap_utils_pkg.get_apportion_factor(cur_rec_invoice_line.invoice_id, cur_rec_invoice_line.invoice_line_number); /*rchandan for bug#4454657*/
232:
233: open c_ap_invoice_distributions_all /*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:

Line 236: close c_ap_invoice_distributions_all;

232:
233: open c_ap_invoice_distributions_all /*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;