APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 1862: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

1858:
1859: /* Bug 5243532. Added by Lakshmi Gopalsami
1860: Implemented caching logic.
1861: */
1862: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1863:
1864:
1865: BEGIN
1866: pv_return_code := jai_constants.successful ;

Line 2359: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

2355: Removed the reference to cursor sob_cur and implemented using
2356: caching logic.
2357: */
2358:
2359: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
2360: (p_org_id => pr_new.org_id);
2361: v_currency_code := l_func_curr_det.currency_code;
2362: v_set_of_books_id := l_func_curr_det.ledger_id;
2363: -- end for bug 5243532

Line 3740: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

3736: lv_reference_25 varchar2(100) := 'delivery_id';
3737: lv_regime_code VARCHAR2(100) := 'EXCISE';
3738: lv_source_table VARCHAR2(100) := 'wsh_delivery_details';
3739:
3740: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3741:
3742: BEGIN
3743:
3744: OPEN c_get_il_setup;

Line 3748: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

3744: OPEN c_get_il_setup;
3745: FETCH c_get_il_setup INTO r_il_setup;
3746: CLOSE c_get_il_setup;
3747:
3748: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
3749: (p_org_id => pr_trig_row.organization_id);
3750: v_set_of_books_id := l_func_curr_det.ledger_id;
3751: v_currency_code := l_func_curr_det.currency_code;
3752: IF Nvl(r_il_setup.trading,'N')='Y' AND Nvl(r_il_setup.excise_in_rg23d,'N')='Y' /*reversing to be done only if this setup is present. not necessary otherwise*/