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 98: ln_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

94: Removed the cursor c_set_of_books and c_sob_currency
95: and implemented using caching logic.
96: */
97:
98: ln_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
99: lv_sob_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
100:
101: /* Bug 5243532. Added by Lakshmi Gopalsami.
102: Defined local variable for implementing caching logic.

Line 99: lv_sob_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;

95: and implemented using caching logic.
96: */
97:
98: ln_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
99: lv_sob_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
100:
101: /* Bug 5243532. Added by Lakshmi Gopalsami.
102: Defined local variable for implementing caching logic.
103: */

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

119:
120: FUNCTION check_jai_exists(p_calling_object VARCHAR2 ,
121: p_inventory_orgn_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE DEFAULT NULL ,
122: p_org_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE DEFAULT NULL ,
123: p_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL ,
124: p_value_string VARCHAR2 DEFAULT NULL ,
125: p_format_string VARCHAR2 DEFAULT NULL
126: ) RETURN BOOLEAN
127: IS

Line 132: Replaced gl_sets_of_books with gl_ledgers

128: /* Bug 5243532. Added by Lakshmi Gopalsami
129: Removed the cursor c_set_of_books and c_operating_unit
130: which is referring to hr_operating_units
131: and org_organization_definitions. Replaced the same with caching logic.
132: Replaced gl_sets_of_books with gl_ledgers
133: */
134: CURSOR c_sob_currency (cp_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE) IS
135: SELECT currency_code
136: FROM gl_ledgers

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

130: which is referring to hr_operating_units
131: and org_organization_definitions. Replaced the same with caching logic.
132: Replaced gl_sets_of_books with gl_ledgers
133: */
134: CURSOR c_sob_currency (cp_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE) IS
135: SELECT currency_code
136: FROM gl_ledgers
137: WHERE ledger_id = cp_set_of_books_id;
138:

Line 139: lv_sob_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;

135: SELECT currency_code
136: FROM gl_ledgers
137: WHERE ledger_id = cp_set_of_books_id;
138:
139: lv_sob_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
140: lv_calling_object VARCHAR2(50);
141: lv_message_text VARCHAR2(3000);
142:
143: /* Bug 5243235. Added by Lakshmi Gopalsami

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

155: return(false);
156: END IF;
157:
158: /*
159: set of books id is passed. Get the currency code from the gl_sets_of_books and return true or false
160: depending on the curreny code = 'INR' or not.
161: */
162: IF p_set_of_books_id IS NOT NULL THEN
163: OPEN c_sob_currency(p_set_of_books_id);

Line 357: Select currency_code from gl_sets_of_books

353: v_func_curr varchar2(15);
354: ret_value number;
355:
356: Cursor currency_code_cur IS
357: Select currency_code from gl_sets_of_books
358: where set_of_books_id = c_set_of_books_id;
359:
360: /* Added by Ramananda for bug#4407165 */
361: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_utils_pkg.currency_conversion';