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_CMN_UTILS_PKG dependencies on GL_SETS_OF_BOOKS

Line 123: ln_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

119: Removed the cursor c_set_of_books and c_sob_currency
120: and implemented using caching logic.
121: */
122:
123: ln_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
124: lv_sob_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
125:
126: /* Bug 5243532. Added by Lakshmi Gopalsami.
127: Defined local variable for implementing caching logic.

Line 124: lv_sob_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;

120: and implemented using caching logic.
121: */
122:
123: ln_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
124: lv_sob_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
125:
126: /* Bug 5243532. Added by Lakshmi Gopalsami.
127: Defined local variable for implementing caching logic.
128: */

Line 148: p_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL ,

144:
145: FUNCTION check_jai_exists(p_calling_object VARCHAR2 ,
146: p_inventory_orgn_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE DEFAULT NULL ,
147: p_org_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE DEFAULT NULL ,
148: p_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL ,
149: p_value_string VARCHAR2 DEFAULT NULL ,
150: p_format_string VARCHAR2 DEFAULT NULL
151: ) RETURN BOOLEAN
152: IS

Line 157: Replaced gl_sets_of_books with gl_ledgers

153: /* Bug 5243532. Added by Lakshmi Gopalsami
154: Removed the cursor c_set_of_books and c_operating_unit
155: which is referring to hr_operating_units
156: and org_organization_definitions. Replaced the same with caching logic.
157: Replaced gl_sets_of_books with gl_ledgers
158: */
159: CURSOR c_sob_currency (cp_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE) IS
160: SELECT currency_code
161: FROM gl_ledgers

Line 159: CURSOR c_sob_currency (cp_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE) IS

155: which is referring to hr_operating_units
156: and org_organization_definitions. Replaced the same with caching logic.
157: Replaced gl_sets_of_books with gl_ledgers
158: */
159: CURSOR c_sob_currency (cp_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE) IS
160: SELECT currency_code
161: FROM gl_ledgers
162: WHERE ledger_id = cp_set_of_books_id;
163:

Line 164: lv_sob_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;

160: SELECT currency_code
161: FROM gl_ledgers
162: WHERE ledger_id = cp_set_of_books_id;
163:
164: lv_sob_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
165: lv_calling_object VARCHAR2(50);
166: lv_message_text VARCHAR2(3000);
167:
168: /* Bug 5243235. Added by Lakshmi Gopalsami

Line 189: set of books id is passed. Get the currency code from the gl_sets_of_books and return true or false

185: return (false);
186: END IF;
187:
188: /*
189: set of books id is passed. Get the currency code from the gl_sets_of_books and return true or false
190: depending on the curreny code = 'INR' or not.
191: */
192: IF p_set_of_books_id IS NOT NULL THEN
193: OPEN c_sob_currency(p_set_of_books_id);

Line 387: Select currency_code from gl_sets_of_books

383: v_func_curr varchar2(15);
384: ret_value number;
385:
386: Cursor currency_code_cur IS
387: Select currency_code from gl_sets_of_books
388: where set_of_books_id = c_set_of_books_id;
389:
390: /* Added by Ramananda for bug#4407165 */
391: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_utils_pkg.currency_conversion';