APPS.JAI_AP_DTC_CANCELLATION_PKG dependencies on GL_SETS_OF_BOOKS

Line 132: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

128: -------------------------------------------------------------------------------
129: -- Added by ChongLei for DTC Bug#13359892, End
130: group by threshold_grp_id;
131:
132: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
133: select currency_code
134: from gl_sets_of_books
135: where set_of_books_id = cp_set_of_books_id;
136: /*start-ETDS FVU3.1 11896260*/

Line 134: from gl_sets_of_books

130: group by threshold_grp_id;
131:
132: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
133: select currency_code
134: from gl_sets_of_books
135: where set_of_books_id = cp_set_of_books_id;
136: /*start-ETDS FVU3.1 11896260*/
137: cursor c_threshold_breach(p_invoice_id number) is
138: select jattt.invoice_id,

Line 214: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

210:
211: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
212: r_ap_invoices_all c_ap_invoices_all%rowtype;
213: r_get_parent_inv_dtls c_get_parent_inv_dtls%rowtype;
214: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
215:
216: lv_code_path VARCHAR2(1996);
217: lv_process_flag varchar2(1);
218: lv_process_message varchar2(250);

Line 963: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);

959: fetch c_get_parent_inv_dtls
960: into r_get_parent_inv_dtls;
961: close c_get_parent_inv_dtls;
962:
963: open c_gl_sets_of_books(r_get_parent_inv_dtls.set_of_books_id);
964: fetch c_gl_sets_of_books
965: into r_gl_sets_of_books;
966: close c_gl_sets_of_books;
967:

Line 964: fetch c_gl_sets_of_books

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

Line 965: into r_gl_sets_of_books;

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

Line 966: close c_gl_sets_of_books;

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

Line 968: if r_gl_sets_of_books.currency_code <>

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