APPS.JAI_PO_LLA_TRIGGER_PKG dependencies on GL_SETS_OF_BOOKS

Line 8: To get the currency code from GL_SETS_OF_BOOKS table,

4:
5: /********************************************************************************
6:
7: 1. Ramananada for bug#4703617. File Version 120.1
8: To get the currency code from GL_SETS_OF_BOOKS table,
9: ORG_ORGANIZATION_DEFINITIONS table is referred to get the Set_Of_Books_Id.
10: But using this table has a performance impact. Hence using the table
11: FINANCIALS_SYSTEM_PARAMS_ALL along with GL_SETS_OF_BOOKS talbe to get the
12: currency code.

Line 11: FINANCIALS_SYSTEM_PARAMS_ALL along with GL_SETS_OF_BOOKS talbe to get the

7: 1. Ramananada for bug#4703617. File Version 120.1
8: To get the currency code from GL_SETS_OF_BOOKS table,
9: ORG_ORGANIZATION_DEFINITIONS table is referred to get the Set_Of_Books_Id.
10: But using this table has a performance impact. Hence using the table
11: FINANCIALS_SYSTEM_PARAMS_ALL along with GL_SETS_OF_BOOKS talbe to get the
12: currency code.
13: Removed the references of ORG_ORGANIZATION_DEFINITIONS and instead used
14: FINANCIALS_SYSTEM_PARAMS_ALL table
15:

Line 33: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;

29: v_po_line_loc_id NUMBER;--File.Sql.35 Cbabu := pr_old.Line_Location_Id;
30:
31: ------------- added by Gsr 12-jul-01
32: v_operating_id number;--File.Sql.35 Cbabu :=pr_new.ORG_ID;
33: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
34: v_currency_code gl_sets_of_books.currency_code%type;
35:
36: /*
37: || Commented the following two cursors as they are not used in the trigger

Line 34: v_currency_code gl_sets_of_books.currency_code%type;

30:
31: ------------- added by Gsr 12-jul-01
32: v_operating_id number;--File.Sql.35 Cbabu :=pr_new.ORG_ID;
33: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
34: v_currency_code gl_sets_of_books.currency_code%type;
35:
36: /*
37: || Commented the following two cursors as they are not used in the trigger
38: || Ramananada for bug#4703617

Line 47: from gl_sets_of_books

43: WHERE Operating_unit = v_operating_id; -- Modified by Ramananda for removal of SQL LITERALs
44: --WHERE NVL(Operating_unit,0) = v_operating_id;
45: CURSOR Sob_Cur is
46: select Currency_code
47: from gl_sets_of_books
48: where set_of_books_id = v_gl_set_of_bks_id; */
49:
50: ------ End of addition by Gsri on 12-jul-01
51:

Line 207: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;

203: FROM Po_Lines_All
204: WHERE Po_Line_Id = v_po_line_id;
205:
206: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.ORG_ID;
207: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
208: v_currency_code gl_sets_of_books.currency_code%type;
209:
210:
211: /*

Line 208: v_currency_code gl_sets_of_books.currency_code%type;

204: WHERE Po_Line_Id = v_po_line_id;
205:
206: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.ORG_ID;
207: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
208: v_currency_code gl_sets_of_books.currency_code%type;
209:
210:
211: /*
212: || Commented the following two cursors as they are not used in the trigger

Line 223: from gl_sets_of_books

219: WHERE Operating_unit = v_operating_id; -- Modified by Ramananda for removal of SQL LITERALs
220: --WHERE NVL(Operating_unit,0) = v_operating_id;
221: CURSOR Sob_Cur is
222: select Currency_code
223: from gl_sets_of_books
224: where set_of_books_id = v_gl_set_of_bks_id; */
225:
226: CURSOR tax_cur IS
227: SELECT a.Po_Line_Id, a.tax_line_no lno, a.tax_id,

Line 924: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type ;

920:
921: ------------- added by Gsr 12-jul-01
922:
923: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.org_id ;
924: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type ;
925: v_currency_code gl_sets_of_books.currency_code%type ;
926:
927:
928: /*

Line 925: v_currency_code gl_sets_of_books.currency_code%type ;

921: ------------- added by Gsr 12-jul-01
922:
923: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.org_id ;
924: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type ;
925: v_currency_code gl_sets_of_books.currency_code%type ;
926:
927:
928: /*
929: || Commented the following two cursors and added the cur_get_curr_code cursor

Line 941: FROM gl_sets_of_books

937: WHERE operating_unit = v_operating_id; -- Modified by Ramananda for removal of SQL LITERALs
938: --nvl(operating_unit,0) = v_operating_id;
939: CURSOR sob_cur IS
940: SELECT currency_code
941: FROM gl_sets_of_books
942: WHERE
943: set_of_books_id = v_gl_set_of_bks_id; */
944:
945: /*

Line 953: financials_system_params_all FSP, gl_sets_of_books SOB

949: CURSOR cur_get_curr_code IS
950: SELECT
951: sob.currency_code
952: FROM
953: financials_system_params_all FSP, gl_sets_of_books SOB
954: WHERE
955: FSP.set_of_books_id = SOB.set_of_books_id
956: AND FSP.org_id = v_operating_id ;
957: