APPS.JAI_FA_MA_TRIGGER_PKG dependencies on GL_SETS_OF_BOOKS

Line 44: cursor c_gl_sets_of_books(p_set_of_books_id number) is

40: from ap_invoice_lines_all /*rchandan for bug#4428980*/
41: where invoice_id = p_invoice_id
42: and line_number = p_line_number;
43:
44: cursor c_gl_sets_of_books(p_set_of_books_id number) is
45: select currency_code
46: from gl_sets_of_books
47: where set_of_books_id = p_set_of_books_id;
48:

Line 46: from gl_sets_of_books

42: and line_number = p_line_number;
43:
44: cursor c_gl_sets_of_books(p_set_of_books_id number) is
45: select currency_code
46: from gl_sets_of_books
47: where set_of_books_id = p_set_of_books_id;
48:
49: cursor c_rcv_transactions(p_transaction_id number) is
50: select shipment_line_id,

Line 92: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

88:
89: r_ap_invoice_lines_all c_ap_invoice_lines_all%rowtype; /*rchandan for bug#4454657*/
90: r_rcv_transactions c_rcv_transactions%rowtype;
91: r_ja_in_receipt_tax_lines c_ja_in_receipt_tax_lines%rowtype;
92: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
93: ln_boe_3p_count number:=0;
94: lb_result boolean;
95: ln_req_id number;
96: ln_first_record number := 0;

Line 178: /* open c_gl_sets_of_books(r_ap_invoice_distributions_all.set_of_books_id);

174: --end if;
175:
176: /*The following code has been commented and added the above code instead - ssumaith - bug# 4037690*/
177:
178: /* open c_gl_sets_of_books(r_ap_invoice_distributions_all.set_of_books_id);
179: fetch c_gl_sets_of_books into r_gl_sets_of_books;
180: close c_gl_sets_of_books;
181: */
182: /* check if functional currency is INR, if not there is no need to process further */

Line 179: fetch c_gl_sets_of_books into r_gl_sets_of_books;

175:
176: /*The following code has been commented and added the above code instead - ssumaith - bug# 4037690*/
177:
178: /* open c_gl_sets_of_books(r_ap_invoice_distributions_all.set_of_books_id);
179: fetch c_gl_sets_of_books into r_gl_sets_of_books;
180: close c_gl_sets_of_books;
181: */
182: /* check if functional currency is INR, if not there is no need to process further */
183:

Line 180: close c_gl_sets_of_books;

176: /*The following code has been commented and added the above code instead - ssumaith - bug# 4037690*/
177:
178: /* open c_gl_sets_of_books(r_ap_invoice_distributions_all.set_of_books_id);
179: fetch c_gl_sets_of_books into r_gl_sets_of_books;
180: close c_gl_sets_of_books;
181: */
182: /* check if functional currency is INR, if not there is no need to process further */
183:
184: /*

Line 185: if nvl(r_gl_sets_of_books.currency_code, 'XXX') <> 'INR' then

181: */
182: /* check if functional currency is INR, if not there is no need to process further */
183:
184: /*
185: if nvl(r_gl_sets_of_books.currency_code, 'XXX') <> 'INR' then
186: return;
187: end if;
188: */
189:

Line 395: ln_set_of_books_id gl_sets_of_books.set_of_books_id%type;

391: c_get_receipt_details_rec c_get_receipt_details%ROWTYPE;
392: c_get_rcp_tax_details_rec c_get_rcp_tax_details%ROWTYPE;
393: dist_tax_rec dist_tax_cur % rowtype;
394: item_mod_rec item_mod_cur % rowtype;
395: ln_set_of_books_id gl_sets_of_books.set_of_books_id%type;
396:
397: --
398: -- Begin 5763527
399: --