APPS.JAI_PO_LA_TRIGGER_PKG dependencies on GL_SETS_OF_BOOKS

Line 16: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;

12: */
13: PROCEDURE ARD_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
14: ------------- added by Gsr 12-jul-01
15: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.ORG_ID;
16: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
17: v_currency_code gl_sets_of_books.currency_code%type;
18:
19: /* Bug 5243532. Added by Lakshmi Gopalsami
20: * Removed cursor Fetch_Book_Id_Cur

Line 17: v_currency_code gl_sets_of_books.currency_code%type;

13: PROCEDURE ARD_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
14: ------------- added by Gsr 12-jul-01
15: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.ORG_ID;
16: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
17: v_currency_code gl_sets_of_books.currency_code%type;
18:
19: /* Bug 5243532. Added by Lakshmi Gopalsami
20: * Removed cursor Fetch_Book_Id_Cur
21: * and implemented using caching logic.

Line 26: from gl_sets_of_books

22: */
23:
24: CURSOR Sob_Cur is
25: select Currency_code
26: from gl_sets_of_books
27: where set_of_books_id = v_gl_set_of_bks_id;
28: ------ End of addition by Gsri on 12-jul-01
29:
30:

Line 142: v_currency_code gl_sets_of_books.currency_code%type; --added by Gsr and Sriram on 21-03-2001

138: v_tax_ctg_id NUMBER;
139: v_uom_code VARCHAR2(3);
140:
141: -- found BOOLEAN;
142: v_currency_code gl_sets_of_books.currency_code%type; --added by Gsr and Sriram on 21-03-2001
143:
144: -- Vijay Shankar for Bug# 3466223
145: v_from_header_id NUMBER;
146: v_from_type_lookup_code PO_HEADERS_ALL.from_type_lookup_code%TYPE;

Line 486: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;

482: */
483: PROCEDURE ARU_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
484: ------------- added by Gsr 12-jul-01
485: v_operating_id number;--File.Sql.35 Cbabu :=pr_new.ORG_ID;
486: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
487: v_currency_code gl_sets_of_books.currency_code%type;
488:
489: /* Bug 5243532. Added by Lakshmi Gopalsami
490: * Removed cursor Fetch_Book_Id_Cur

Line 487: v_currency_code gl_sets_of_books.currency_code%type;

483: PROCEDURE ARU_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
484: ------------- added by Gsr 12-jul-01
485: v_operating_id number;--File.Sql.35 Cbabu :=pr_new.ORG_ID;
486: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
487: v_currency_code gl_sets_of_books.currency_code%type;
488:
489: /* Bug 5243532. Added by Lakshmi Gopalsami
490: * Removed cursor Fetch_Book_Id_Cur
491: * and implemented using caching logic.

Line 496: from gl_sets_of_books

492: */
493:
494: CURSOR Sob_Cur is
495: select Currency_code
496: from gl_sets_of_books
497: where set_of_books_id = v_gl_set_of_bks_id;
498: ------ End of addition by Gsri on 12-jul-01
499:
500: v_po_hdr_id NUMBER; --File.Sql.35 Cbabu := pr_new.Po_Header_Id;