eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 50: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;

46: v_po_line_loc_id NUMBER;--File.Sql.35 Cbabu := pr_old.Line_Location_Id;
47:
48: ------------- added by Gsr 12-jul-01
49: v_operating_id number;--File.Sql.35 Cbabu :=pr_new.ORG_ID;
50: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
51: v_currency_code gl_sets_of_books.currency_code%type;
52:
53: /*
54: || Commented the following two cursors as they are not used in the trigger

Line 51: v_currency_code gl_sets_of_books.currency_code%type;

47:
48: ------------- added by Gsr 12-jul-01
49: v_operating_id number;--File.Sql.35 Cbabu :=pr_new.ORG_ID;
50: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
51: v_currency_code gl_sets_of_books.currency_code%type;
52:
53: /*
54: || Commented the following two cursors as they are not used in the trigger
55: || Ramananada for bug#4703617

Line 64: from gl_sets_of_books

60: WHERE Operating_unit = v_operating_id; -- Modified by Ramananda for removal of SQL LITERALs
61: --WHERE NVL(Operating_unit,0) = v_operating_id;
62: CURSOR Sob_Cur is
63: select Currency_code
64: from gl_sets_of_books
65: where set_of_books_id = v_gl_set_of_bks_id; */
66:
67: ------ End of addition by Gsri on 12-jul-01
68:

Line 225: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;

221: FROM Po_Lines_All
222: WHERE Po_Line_Id = v_po_line_id;
223:
224: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.ORG_ID;
225: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
226: v_currency_code gl_sets_of_books.currency_code%type;
227:
228:
229: /*

Line 226: v_currency_code gl_sets_of_books.currency_code%type;

222: WHERE Po_Line_Id = v_po_line_id;
223:
224: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.ORG_ID;
225: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
226: v_currency_code gl_sets_of_books.currency_code%type;
227:
228:
229: /*
230: || Commented the following two cursors as they are not used in the trigger

Line 241: from gl_sets_of_books

237: WHERE Operating_unit = v_operating_id; -- Modified by Ramananda for removal of SQL LITERALs
238: --WHERE NVL(Operating_unit,0) = v_operating_id;
239: CURSOR Sob_Cur is
240: select Currency_code
241: from gl_sets_of_books
242: where set_of_books_id = v_gl_set_of_bks_id; */
243:
244: CURSOR tax_cur IS
245: SELECT a.Po_Line_Id, a.tax_line_no lno, a.tax_id,

Line 1075: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type ;

1071:
1072: ------------- added by Gsr 12-jul-01
1073:
1074: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.org_id ;
1075: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type ;
1076: v_currency_code gl_sets_of_books.currency_code%type ;
1077:
1078:
1079: /*

Line 1076: v_currency_code gl_sets_of_books.currency_code%type ;

1072: ------------- added by Gsr 12-jul-01
1073:
1074: v_operating_id number; --File.Sql.35 Cbabu :=pr_new.org_id ;
1075: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type ;
1076: v_currency_code gl_sets_of_books.currency_code%type ;
1077:
1078:
1079: /*
1080: || Commented the following two cursors and added the cur_get_curr_code cursor

Line 1092: FROM gl_sets_of_books

1088: WHERE operating_unit = v_operating_id; -- Modified by Ramananda for removal of SQL LITERALs
1089: --nvl(operating_unit,0) = v_operating_id;
1090: CURSOR sob_cur IS
1091: SELECT currency_code
1092: FROM gl_sets_of_books
1093: WHERE
1094: set_of_books_id = v_gl_set_of_bks_id; */
1095:
1096: /*

Line 1104: financials_system_params_all FSP, gl_sets_of_books SOB

1100: CURSOR cur_get_curr_code IS
1101: SELECT
1102: sob.currency_code
1103: FROM
1104: financials_system_params_all FSP, gl_sets_of_books SOB
1105: WHERE
1106: FSP.set_of_books_id = SOB.set_of_books_id
1107: AND FSP.org_id = v_operating_id ;
1108: