APPS.JAI_PO_CMN_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 327: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

323:
324: /* Bug 5243532. Added by Lakshmi Gopalsami
325: * Defined variable for implementing caching logic.
326: */
327: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
328: /*------------------------------------------------------------------------------------------------------------*/
329: FUNCTION Ja_In_Po_Get_Loc_Id( p_po_header_id IN NUMBER ) RETURN NUMBER IS
330:
331: CURSOR Fetch_Location_Id_Cur IS SELECT Ship_To_Location_Id

Line 364: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

360: /* Bug 5243532. Added by Lakshmi Gopalsami
361: * Removed cursors Get_Set_Of_Book_Cur and Get_Func_Curr_Cur
362: * and implemented caching logic to get the sob and sob currency.
363: */
364: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
365: (p_org_id => v_inv_org_id );
366: v_set_of_books_id := l_func_curr_det.ledger_id;
367: v_func_curr := l_func_curr_det.currency_code;
368:

Line 411: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

407:
408: /* Bug 5243532. Added by Lakshmi Gopalsami
409: * Defined variable for implementing caching logic.
410: */
411: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
412:
413: FUNCTION Ja_In_Po_Get_Org_Id RETURN NUMBER IS
414:
415: CURSOR Fetch_Org_Id_Cur IS SELECT NVL( Org_Id, -99 )

Line 441: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

437: /* Bug 5243532. Added by Lakshmi Gopalsami
438: * Removed cursor Fetch_SET_Of_Books_Id_Cur
439: * and used caching logic for getting SOB
440: */
441: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
442: (p_org_id => v_inv_org_id );
443: v_bookid := l_func_curr_det.ledger_id;
444: v_conv_rate := jai_cmn_utils_pkg.currency_conversion
445: ( v_bookid, p_doc_curr, v_rate_date, v_rate_type, 1 );

Line 847: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

843: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.get_functional_curr';
844: /* Bug 5243532. Added by Lakshmi Gopalsami
845: * Defined variable for implementing caching logic.
846: */
847: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
848: BEGIN
849: /* Bug 5243532. Added by Lakshmi Gopalsami
850: * Removed cursors Get_Set_Of_Book_Cur and Get_Func_Curr_Cur
851: * and implemented caching logic

Line 853: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

849: /* Bug 5243532. Added by Lakshmi Gopalsami
850: * Removed cursors Get_Set_Of_Book_Cur and Get_Func_Curr_Cur
851: * and implemented caching logic
852: */
853: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
854: (p_org_id => v_inv_org_id );
855: v_set_of_books_id := l_func_curr_det.ledger_id;
856: v_func_curr := l_func_curr_det.currency_code;
857: