APPS.JAI_AP_TDS_CANCELLATION_PKG dependencies on GL_SETS_OF_BOOKS

Line 141: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

137: and threshold_grp_id is not null
138: and threshold_trx_id is null
139: group by threshold_grp_id, actual_tax_id;
140:
141: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
142: select currency_code
143: from gl_sets_of_books
144: where set_of_books_id = cp_set_of_books_id;
145:

Line 143: from gl_sets_of_books

139: group by threshold_grp_id, actual_tax_id;
140:
141: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
142: select currency_code
143: from gl_sets_of_books
144: where set_of_books_id = cp_set_of_books_id;
145:
146: /* Bug#5131075(5193852). Added by Lakshmi Gopalsami
147: | Changed the source of ld_accounting_date to refer to

Line 165: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

161:
162: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
163: r_ap_invoices_all c_ap_invoices_all%rowtype;
164: r_get_parent_inv_dtls c_get_parent_inv_dtls%rowtype;
165: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
166:
167: lv_code_path VARCHAR2(1996);
168: lv_process_flag varchar2(1);
169: lv_process_message varchar2(250);

Line 792: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);

788: open c_get_parent_inv_dtls(p_invoice_id);
789: fetch c_get_parent_inv_dtls into r_get_parent_inv_dtls;
790: close c_get_parent_inv_dtls;
791:
792: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);
793: fetch c_gl_sets_of_books into r_gl_sets_of_books;
794: close c_gl_sets_of_books;
795:
796: if r_gl_sets_of_books.currency_code <> r_get_parent_inv_dtls.invoice_currency_code then

Line 793: fetch c_gl_sets_of_books into r_gl_sets_of_books;

789: fetch c_get_parent_inv_dtls into r_get_parent_inv_dtls;
790: close c_get_parent_inv_dtls;
791:
792: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);
793: fetch c_gl_sets_of_books into r_gl_sets_of_books;
794: close c_gl_sets_of_books;
795:
796: if r_gl_sets_of_books.currency_code <> r_get_parent_inv_dtls.invoice_currency_code then
797: lv_codepath := jai_general_pkg.plot_codepath(21, lv_codepath); /* 21 */

Line 794: close c_gl_sets_of_books;

790: close c_get_parent_inv_dtls;
791:
792: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);
793: fetch c_gl_sets_of_books into r_gl_sets_of_books;
794: close c_gl_sets_of_books;
795:
796: if r_gl_sets_of_books.currency_code <> r_get_parent_inv_dtls.invoice_currency_code then
797: lv_codepath := jai_general_pkg.plot_codepath(21, lv_codepath); /* 21 */
798: /* Foreign currency invoice */

Line 796: if r_gl_sets_of_books.currency_code <> r_get_parent_inv_dtls.invoice_currency_code then

792: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);
793: fetch c_gl_sets_of_books into r_gl_sets_of_books;
794: close c_gl_sets_of_books;
795:
796: if r_gl_sets_of_books.currency_code <> r_get_parent_inv_dtls.invoice_currency_code then
797: lv_codepath := jai_general_pkg.plot_codepath(21, lv_codepath); /* 21 */
798: /* Foreign currency invoice */
799: ln_exchange_rate := r_get_parent_inv_dtls.exchange_rate;
800: end if;