APPS.JAI_OM_RG_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 312: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

308: /* Bug 5243532. Added by Lakshmi Gopalsami
309: Removed the cursors c_get_sob_currency and currency
310: c_currency_precision and implemented the same using caching logic.
311: */
312: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
313:
314:
315: v_precision fnd_currencies.precision%type;
316: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;

Line 364: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

360: /* Bug 5243532. Added by Lakshmi Gopalsami
361: Removed the reference to cursors c_get_sob_currency
362: and implemented using caching logic.
363: */
364: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
365: (p_org_id => v_org_id );
366: v_currency_code := l_func_curr_det.currency_code;
367: --v_precision := l_func_curr_det.precision;
368: v_precision := 0; /*bug 8537295 - for excise invoice, amount should be rounded to nearest rupee*/

Line 1817: l_func_curr_det jai_plsql_cache_pkg.func_curr_details; /*Added by nprashar for bug # 11812969 */

1813: v_to_other_fact_n_pay_ed_val NUMBER;
1814:
1815: v_converted_rate number := 1; /*Added by nprashar for bug # 11812969 */
1816:
1817: l_func_curr_det jai_plsql_cache_pkg.func_curr_details; /*Added by nprashar for bug # 11812969 */
1818:
1819: v_set_of_books_id NUMBER; /*Added by nprashar for bug # 11812969 */
1820:
1821: v_order_header_id oe_order_headers_all.header_id%type; /*Added by nprashar for bug # 11812969 */

Line 2148: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr (p_org_id);

2144: END IF;
2145: END IF;
2146:
2147: /*Addition of code starts for bug # 11812969 */
2148: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr (p_org_id);
2149: v_set_of_books_id := l_func_curr_det.ledger_id;
2150:
2151: Open get_order_info (p_header_id);
2152: Fetch get_order_info into v_order_header_id, v_order_line_id;