APPS.JAI_OPEN_API_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 5675: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

5671: /* Bug 5243532. Added by Lakshmi Gopalsami
5672: * Removed cursor set_of_books_cur
5673: * and implemented caching logic.
5674: */
5675: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
5676:
5677: ln_inv_curr_precision NUMBER;
5678:
5679: /* added by CSahoo - bug# 5364120*/

Line 5800: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id);

5796: end if;
5797:
5798: IF v_books_id IS NULL THEN
5799:
5800: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id);
5801: v_books_id := l_func_curr_det.ledger_id;
5802: END IF;
5803: v_converted_rate := jai_cmn_utils_pkg.currency_conversion(v_books_id,
5804: c_from_currency_code,

Line 6731: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

6727: c_conversion_type VARCHAR2(30);
6728: c_conversion_date DATE;
6729: c_conversion_rate NUMBER := 0;
6730: v_converted_rate NUMBER := 1;
6731: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
6732:
6733: CURSOR count_cur IS
6734: SELECT count(customer_trx_line_id)
6735: FROM JAI_AR_TRX_INS_LINES_T

Line 7422: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id);

7418: FETCH BOOKS_TRX_CUR
7419: INTO v_books_id, v_salesrep_id, c_from_currency_code, c_conversion_type, c_conversion_date, c_conversion_rate;
7420: CLOSE BOOKS_TRX_CUR;
7421: IF v_books_id IS NULL THEN
7422: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id);
7423: v_books_id := l_func_curr_det.ledger_id;
7424: END IF;
7425: v_converted_rate := jai_cmn_utils_pkg.currency_conversion(v_books_id,
7426: c_from_currency_code,

Line 7625: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id);

7621: FETCH BOOKS_TRX_CUR
7622: INTO v_books_id, v_salesrep_id, c_from_currency_code, c_conversion_type, c_conversion_date, c_conversion_rate;
7623: CLOSE BOOKS_TRX_CUR;
7624: IF v_books_id IS NULL THEN
7625: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id);
7626: v_books_id := l_func_curr_det.ledger_id;
7627: END IF;
7628: v_converted_rate := jai_cmn_utils_pkg.currency_conversion(v_books_id,
7629: c_from_currency_code,