eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_MTAX_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 965: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

961: /* Bug 5243532. Added by Lakshmi Gopalsami
962: * Removed cursors c_inv_set_of_books_id and c_opr_set_of_books_id
963: * and implemented caching logic.
964: */
965: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
966:
967:
968: -- add by Xiao for recording down the release version on 24-Jul-2009
969: lv_release_name VARCHAR2(30);

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

1866: /* Bug 5243532. Added by Lakshmi Gopalsami
1867: Removed the reference to cursor c_inv_set_of_books_id
1868: and implemented using caching logic.
1869: */
1870: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr (p_org_id => v_organization_id );
1871: v_sob_id := l_func_curr_det.ledger_id;
1872: v_func_curr := l_func_curr_det.currency_code;
1873: -- end for bug 5243532
1874:

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

1878: Removed the reference to cursor c_opr_set_of_books_id
1879: and implemented using caching logic.
1880:
1881: */
1882: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr (p_org_id => v_org_id );
1883: v_sob_id := l_func_curr_det.ledger_id;
1884: v_func_curr := l_func_curr_det.currency_code;
1885:
1886: END IF;

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

2461: /* Bug 5243532. Added by Lakshmi Gopalsami
2462: Implemented caching logic
2463: */
2464: <>
2465: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );
2466: v_sob_id := l_func_curr_det.ledger_id;
2467: v_func_curr := l_func_curr_det.currency_code;
2468:
2469: /* Bug 5243532. Added by Lakshmi Gopalsami

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

2471: and implemented using caching logic.
2472:
2473: */
2474: IF v_sob_id IS NULL THEN
2475: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );
2476: v_sob_id := l_func_curr_det.ledger_id;
2477: END IF;
2478:
2479: IF v_debug THEN

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

3043: /* Bug 5243532. Added by Lakshmi Gopalsami
3044: Implemented caching logic.
3045: */
3046:
3047: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );
3048: v_sob_id := l_func_curr_det.ledger_id;
3049: v_func_curr := l_func_curr_det.currency_code;
3050:
3051: /* Bug 5243532. Added by Lakshmi Gopalsami

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

3053: and implemented using caching logic.
3054:
3055: */
3056: IF v_sob_id IS NULL THEN
3057: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );
3058: v_sob_id := l_func_curr_det.ledger_id;
3059: v_func_curr := l_func_curr_det.currency_code;
3060: END IF;
3061:

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

3603: * and implemented caching logic.
3604: */
3605:
3606: IF v_organization_id IS NOT NULL THEN
3607: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );
3608: ELSE
3609: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );
3610: END IF;
3611:

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

3605:
3606: IF v_organization_id IS NOT NULL THEN
3607: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );
3608: ELSE
3609: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );
3610: END IF;
3611:
3612: v_sob_id := l_func_curr_det.ledger_id;
3613: v_func_curr := l_func_curr_det.currency_code;

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

4246: v_organization_id := boe_rec.organization_id;
4247:
4248:
4249: IF v_organization_id IS NOT NULL THEN
4250: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );
4251: ELSE
4252: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );
4253: END IF;
4254:

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

4248:
4249: IF v_organization_id IS NOT NULL THEN
4250: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_organization_id );
4251: ELSE
4252: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id );
4253: END IF;
4254:
4255: v_sob_id := l_func_curr_det.ledger_id;
4256: v_func_curr := l_func_curr_det.currency_code;