APPS.JAI_CMN_MTAX_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 753: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

749: /* Bug 5243532. Added by Lakshmi Gopalsami
750: * Removed cursors c_inv_set_of_books_id and c_opr_set_of_books_id
751: * and implemented caching logic.
752: */
753: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
754:
755:
756:
757: --//~~~~~~~~~ Definitions of Functions and Procedures required for this Concurrent ~~~~~~~~~~//

Line 1467: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr (p_org_id => v_organization_id );

1463: /* Bug 5243532. Added by Lakshmi Gopalsami
1464: Removed the reference to cursor c_inv_set_of_books_id
1465: and implemented using caching logic.
1466: */
1467: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr (p_org_id => v_organization_id );
1468: v_sob_id := l_func_curr_det.ledger_id;
1469: v_func_curr := l_func_curr_det.currency_code;
1470: -- end for bug 5243532
1471:

Line 1479: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr (p_org_id => v_org_id );

1475: Removed the reference to cursor c_opr_set_of_books_id
1476: and implemented using caching logic.
1477:
1478: */
1479: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr (p_org_id => v_org_id );
1480: v_sob_id := l_func_curr_det.ledger_id;
1481: v_func_curr := l_func_curr_det.currency_code;
1482:
1483: END IF;

Line 2037: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );

2033: /* Bug 5243532. Added by Lakshmi Gopalsami
2034: Implemented caching logic
2035: */
2036: <>
2037: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );
2038: v_sob_id := l_func_curr_det.ledger_id;
2039: v_func_curr := l_func_curr_det.currency_code;
2040:
2041: /* Bug 5243532. Added by Lakshmi Gopalsami

Line 2047: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );

2043: and implemented using caching logic.
2044:
2045: */
2046: IF v_sob_id IS NULL THEN
2047: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );
2048: v_sob_id := l_func_curr_det.ledger_id;
2049: END IF;
2050:
2051: IF v_debug THEN

Line 2593: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );

2589: /* Bug 5243532. Added by Lakshmi Gopalsami
2590: Implemented caching logic.
2591: */
2592:
2593: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );
2594: v_sob_id := l_func_curr_det.ledger_id;
2595: v_func_curr := l_func_curr_det.currency_code;
2596:
2597: /* Bug 5243532. Added by Lakshmi Gopalsami

Line 2603: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );

2599: and implemented using caching logic.
2600:
2601: */
2602: IF v_sob_id IS NULL THEN
2603: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );
2604: v_sob_id := l_func_curr_det.ledger_id;
2605: v_func_curr := l_func_curr_det.currency_code;
2606: END IF;
2607:

Line 3129: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );

3125: * and implemented caching logic.
3126: */
3127:
3128: IF v_organization_id IS NOT NULL THEN
3129: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );
3130: ELSE
3131: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );
3132: END IF;
3133:

Line 3131: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );

3127:
3128: IF v_organization_id IS NOT NULL THEN
3129: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );
3130: ELSE
3131: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );
3132: END IF;
3133:
3134: v_sob_id := l_func_curr_det.ledger_id;
3135: v_func_curr := l_func_curr_det.currency_code;