APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 21: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

17: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
18: v_currency_code gl_sets_of_books.currency_code%type;
19:
20: /* Bug 5095812. Added by Lakshmi Gopalsami */
21: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
22: /* Bug 5095812. Added by Lakshmi Gopalsami
23: Removed the cursors Fetch_Book_Id_Cur and
24: Sob_Cur as this is not used anywhere.
25: */

Line 42: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

38: the following and implemented the same using cache.
39: Removed the existing commented codes.
40: */
41:
42: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
43: (p_org_id => v_operating_id );
44:
45: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
46: v_currency_code := l_func_curr_det.currency_code;

Line 161: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

157: -- additions by sriram - ATO - LMW - ends here
158:
159:
160: /* Bug 5095812. Added by Lakshmi Gopalsami */
161: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
162: v_service_type_code varchar2(30);/*bduvarag for the bug#5694855*/
163: CURSOR bind_cur(p_header_id NUMBER) IS
164: SELECT rowid, nvl(org_id,0), sold_to_org_id,
165: source_document_id, order_number, price_list_id,

Line 1886: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

1882: added the following check using plsql caching for performance
1883: issues reported.
1884: */
1885:
1886: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
1887: (p_org_id => v_operating_id );
1888:
1889: v_set_of_books_id := l_func_curr_det.ledger_id;
1890:

Line 2497: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

2493: Removed the cursor set_of_books_cur and added the following check
2494: using plsql caching for performance issues reported.
2495: */
2496:
2497: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
2498: (p_org_id => v_operating_id);
2499:
2500: v_set_of_books_id := l_func_curr_det.ledger_id;
2501:

Line 3044: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

3040: v_customer_id NUMBER;
3041: v_address_id NUMBER;
3042:
3043: /* Bug 5095812. Added by Lakshmi Gopalsami */
3044: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3045:
3046: CURSOR JAI_OM_OE_SO_LINES_cur(p_line_id NUMBER) IS
3047: SELECT quantity,
3048: --selling_price,

Line 3252: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

3248: Bug 5095812. Added by Lakshmi Gopalsami
3249: Removed the cursor set_of_books_cur and added the following check
3250: using plsql caching for performance issues reported.
3251: */
3252: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
3253: (p_org_id => v_warehouse_id);
3254: v_set_of_books_id := l_func_curr_det.ledger_id;
3255:
3256: v_conv_factor := jai_cmn_utils_pkg.currency_conversion( v_set_of_books_id ,