APPS.JAI_AP_TDS_CANCELLATION_PKG dependencies on GL_SETS_OF_BOOKS

Line 184: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

180: and threshold_grp_id is not null
181: and threshold_trx_id is null
182: group by threshold_grp_id, actual_tax_id;
183:
184: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
185: select currency_code
186: from gl_sets_of_books
187: where set_of_books_id = cp_set_of_books_id;
188: /*start-ETDS FVU3.1 11896260*/

Line 186: from gl_sets_of_books

182: group by threshold_grp_id, actual_tax_id;
183:
184: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
185: select currency_code
186: from gl_sets_of_books
187: where set_of_books_id = cp_set_of_books_id;
188: /*start-ETDS FVU3.1 11896260*/
189: cursor c_threshold_breach(p_invoice_id number) is
190: select jattt.invoice_id,jattt.tds_event,jattt.invoice_to_tds_authority_id from jai_ap_tds_inv_taxes jatit,jai_ap_tds_thhold_trxs jattt

Line 261: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

257:
258: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
259: r_ap_invoices_all c_ap_invoices_all%rowtype;
260: r_get_parent_inv_dtls c_get_parent_inv_dtls%rowtype;
261: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
262:
263: lv_code_path VARCHAR2(1996);
264: lv_process_flag varchar2(1);
265: lv_process_message varchar2(250);

Line 964: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);

960: open c_get_parent_inv_dtls(p_invoice_id);
961: fetch c_get_parent_inv_dtls into r_get_parent_inv_dtls;
962: close c_get_parent_inv_dtls;
963:
964: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);
965: fetch c_gl_sets_of_books into r_gl_sets_of_books;
966: close c_gl_sets_of_books;
967:
968: if r_gl_sets_of_books.currency_code <> r_get_parent_inv_dtls.invoice_currency_code then

Line 965: fetch c_gl_sets_of_books into r_gl_sets_of_books;

961: fetch c_get_parent_inv_dtls into r_get_parent_inv_dtls;
962: close c_get_parent_inv_dtls;
963:
964: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);
965: fetch c_gl_sets_of_books into r_gl_sets_of_books;
966: close c_gl_sets_of_books;
967:
968: if r_gl_sets_of_books.currency_code <> r_get_parent_inv_dtls.invoice_currency_code then
969: lv_codepath := jai_general_pkg.plot_codepath(21, lv_codepath); /* 21 */

Line 966: close c_gl_sets_of_books;

962: close c_get_parent_inv_dtls;
963:
964: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);
965: fetch c_gl_sets_of_books into r_gl_sets_of_books;
966: close c_gl_sets_of_books;
967:
968: if r_gl_sets_of_books.currency_code <> r_get_parent_inv_dtls.invoice_currency_code then
969: lv_codepath := jai_general_pkg.plot_codepath(21, lv_codepath); /* 21 */
970: /* Foreign currency invoice */

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

964: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);
965: fetch c_gl_sets_of_books into r_gl_sets_of_books;
966: close c_gl_sets_of_books;
967:
968: if r_gl_sets_of_books.currency_code <> r_get_parent_inv_dtls.invoice_currency_code then
969: lv_codepath := jai_general_pkg.plot_codepath(21, lv_codepath); /* 21 */
970: /* Foreign currency invoice */
971: ln_exchange_rate := r_get_parent_inv_dtls.exchange_rate;
972: end if;