DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on GL_SETS_OF_BOOKS

Line 17: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;

13: v_header_id Number;
14: v_line_id Number; --File.Sql.35 Cbabu := pr_old.line_id;
15: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.ORG_ID;
16: v_line_category_code varchar2(30); --File.Sql.35 Cbabu := pr_old.line_category_code;
17: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
18: v_currency_code gl_sets_of_books.currency_code%type;
19:
20: /* Bug 5095812. Added by Lakshmi Gopalsami */
21: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

Line 18: v_currency_code gl_sets_of_books.currency_code%type;

14: v_line_id Number; --File.Sql.35 Cbabu := pr_old.line_id;
15: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.ORG_ID;
16: v_line_category_code varchar2(30); --File.Sql.35 Cbabu := pr_old.line_category_code;
17: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
18: v_currency_code gl_sets_of_books.currency_code%type;
19:
20: /* Bug 5095812. Added by Lakshmi Gopalsami */
21: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
22: /* Bug 5095812. Added by Lakshmi Gopalsami

Line 331: v_gl_set_of_bks_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

327: v_so_lines_copy_count NUMBER;
328:
329: --2001/06/14 Gadde,Jagdish
330: v_operating_id NUMBER; --File.Sql.35 Cbabu := pr_new.ORG_ID;
331: v_gl_set_of_bks_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
332: v_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
333:
334: v_excise_exempt_type VARCHAR2(60);
335: v_excise_exempt_refno VARCHAR2(30);

Line 332: v_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;

328:
329: --2001/06/14 Gadde,Jagdish
330: v_operating_id NUMBER; --File.Sql.35 Cbabu := pr_new.ORG_ID;
331: v_gl_set_of_bks_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
332: v_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
333:
334: v_excise_exempt_type VARCHAR2(60);
335: v_excise_exempt_refno VARCHAR2(30);
336: v_excise_exempt_date DATE;

Line 3137: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%TYPE;

3133:
3134: v_count NUMBER;
3135:
3136: v_operating_id NUMBER; --File.Sql.35 Cbabu :=pr_new.ORG_ID;
3137: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%TYPE;
3138: v_currency_code gl_sets_of_books.currency_code%TYPE;
3139:
3140: v_excise_exempt_type varchar2(60); -- sriram - bug # 2672114
3141: v_excise_exempt_refno varchar2(30); -- sriram - bug # 2672114

Line 3138: v_currency_code gl_sets_of_books.currency_code%TYPE;

3134: v_count NUMBER;
3135:
3136: v_operating_id NUMBER; --File.Sql.35 Cbabu :=pr_new.ORG_ID;
3137: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%TYPE;
3138: v_currency_code gl_sets_of_books.currency_code%TYPE;
3139:
3140: v_excise_exempt_type varchar2(60); -- sriram - bug # 2672114
3141: v_excise_exempt_refno varchar2(30); -- sriram - bug # 2672114
3142: