APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 212: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

208:
209: /* Bug 5243532. Added by Lakshmi Gopalsami
210: * Defined variable for implementing caching logic.
211: */
212: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
213: -- End for bug 5243532
214:
215: BEGIN
216: pv_return_code := jai_constants.successful ;

Line 551: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

547: * Removed the cursor Fetch_Book_Id_Cur
548: * and implemented using caching logic.
549: */
550:
551: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
552: (p_org_id => v_dest_org_id );
553: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
554:
555: -- Start, cbabu for EnhancementBug# 2427465

Line 1044: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

1040:
1041: /* Bug 5243532. Added by Lakshmi Gopalsami
1042: * Defined variable for implementing caching logic.
1043: */
1044: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1045: v_requisition_header_id NUMBER;
1046:
1047: /* Bug 4513549. Fetch the line_focus_id.
1048: This is used when we are inserting taxes from

Line 1230: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

1226: /* Bug 5243532. Added by Lakshmi Gopalsami
1227: * Removed cursors Fetch_Book_Id and Sob_cur
1228: * and implemented using caching logic.
1229: */
1230: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
1231: (p_org_id => v_dest_org_id );
1232: v_set_of_book_id := l_func_curr_det.ledger_id;
1233: v_currency_code := l_func_curr_det.currency_code;
1234: -- End of bug 5243532

Line 1787: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

1783:
1784: /* Bug 5243532. Added by Lakshmi Gopalsami
1785: * Defined variable for implementing caching logic.
1786: */
1787: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1788:
1789: CURSOR Fetch_Org_Id_Cur IS SELECT NVL(Operating_Unit,0)
1790: FROM Org_Organization_Definitions
1791: WHERE Organization_Id = v_dest_org_id;

Line 2234: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

2230: * Removed the cursor Fetch_Book_Id_Cur
2231: * and implemented using caching logic.
2232: */
2233:
2234: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
2235: (p_org_id => v_dest_org_id );
2236: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
2237:
2238:

Line 2534: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

2530:
2531: /* Bug 5243532. Added by Lakshmi Gopalsami
2532: * Defined variable for implementing caching logic.
2533: */
2534: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
2535:
2536: ------------------------------------------------------------------------------------------------
2537: CURSOR Fetch_Org_Id_Cur IS SELECT nvl(Operating_Unit,0)
2538: FROM Org_Organization_Definitions

Line 2869: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

2865: /* Bug 5243532. Added by Lakshmi Gopalsami
2866: * Removed the cursor Fetch_Book_Id_Cur
2867: * and implemented using caching logic.
2868: */
2869: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
2870: (p_org_id => v_dest_org_id );
2871: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
2872:
2873: