APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 218: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

214:
215: /* Bug 5243532. Added by Lakshmi Gopalsami
216: * Defined variable for implementing caching logic.
217: */
218: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
219: -- End for bug 5243532
220:
221: BEGIN
222: pv_return_code := jai_constants.successful ;

Line 567: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

563: * Removed the cursor Fetch_Book_Id_Cur
564: * and implemented using caching logic.
565: */
566:
567: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
568: (p_org_id => v_dest_org_id );
569: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
570:
571: -- Start, cbabu for EnhancementBug# 2427465

Line 1131: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

1127:
1128: /* Bug 5243532. Added by Lakshmi Gopalsami
1129: * Defined variable for implementing caching logic.
1130: */
1131: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1132: v_requisition_header_id NUMBER;
1133: v_reqn_tax NUMBER; --Added by Bgowrava for Bug#8766851
1134:
1135: /* Bug 4513549. Fetch the line_focus_id.

Line 1331: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

1327: /* Bug 5243532. Added by Lakshmi Gopalsami
1328: * Removed cursors Fetch_Book_Id and Sob_cur
1329: * and implemented using caching logic.
1330: */
1331: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
1332: (p_org_id => v_dest_org_id );
1333: v_set_of_book_id := l_func_curr_det.ledger_id;
1334: v_currency_code := l_func_curr_det.currency_code;
1335: -- End of bug 5243532

Line 1918: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

1914:
1915: /* Bug 5243532. Added by Lakshmi Gopalsami
1916: * Defined variable for implementing caching logic.
1917: */
1918: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1919:
1920: CURSOR Fetch_Org_Id_Cur IS SELECT NVL(Operating_Unit,0)
1921: FROM Org_Organization_Definitions
1922: WHERE Organization_Id = v_dest_org_id;

Line 2368: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

2364: * Removed the cursor Fetch_Book_Id_Cur
2365: * and implemented using caching logic.
2366: */
2367:
2368: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
2369: (p_org_id => v_dest_org_id );
2370: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
2371:
2372:

Line 2757: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

2753:
2754: /* Bug 5243532. Added by Lakshmi Gopalsami
2755: * Defined variable for implementing caching logic.
2756: */
2757: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
2758:
2759: ------------------------------------------------------------------------------------------------
2760: CURSOR Fetch_Org_Id_Cur IS SELECT nvl(Operating_Unit,0)
2761: FROM Org_Organization_Definitions

Line 3093: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

3089: /* Bug 5243532. Added by Lakshmi Gopalsami
3090: * Removed the cursor Fetch_Book_Id_Cur
3091: * and implemented using caching logic.
3092: */
3093: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
3094: (p_org_id => v_dest_org_id );
3095: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
3096:
3097: