APPS.JAI_OM_TAX_PROCESSING_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 583: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

579: c_source_line_id NUMBER;
580: v_so_tax_lines_count NUMBER;
581: v_tax_line_count NUMBER;
582: r_get_copy_order_line get_copy_order_line%ROWTYPE;
583: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
584: v_set_of_books_id NUMBER;
585: v_converted_rate NUMBER;
586:
587: BEGIN

Line 748: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => pr_order_line.ORG_ID);

744:
745: /*
746: || The variable r_get_copy_order_line has the details of the current line from JAI_OM_OE_SO_LINES table
747: */
748: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => pr_order_line.ORG_ID);
749: v_set_of_books_id := l_func_curr_det.ledger_id;
750: v_converted_rate := jai_cmn_utils_pkg.currency_conversion(v_set_of_books_id,
751: pr_header_info.currency_code,
752: pr_header_info.conv_date,

Line 869: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

865: l_tax_lines_exist VARCHAR2(10);
866: rec_cur_get_rma_entry_lines cur_get_rma_entry_lines%ROWTYPE;
867: l_exists VARCHAR2(1);
868: l_tax_exists VARCHAR2(2);
869: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
870: v_set_of_books_id NUMBER;
871: v_converted_rate NUMBER;
872: v_assessable_value NUMBER;
873: v_assessable_amount NUMBER;

Line 1021: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => pr_order_line.ORG_ID);

1017: END LOOP;
1018:
1019: IF l_tax_lines_exist = 'TRUE' THEN
1020:
1021: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => pr_order_line.ORG_ID);
1022: v_set_of_books_id := l_func_curr_det.ledger_id;
1023:
1024: v_converted_rate := jai_cmn_utils_pkg.currency_conversion(v_set_of_books_id,
1025: pr_header_info.currency_code,

Line 2757: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

2753: AND b.tax_type <> jai_constants.tax_type_tds
2754: AND NVL(b.inclusive_tax_flag, 'N') = 'N';
2755:
2756: v_transaction_name VARCHAR2(30);
2757: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
2758: v_set_of_books_id NUMBER;
2759: v_converted_rate NUMBER;
2760: v_assessable_value NUMBER;
2761: v_source_id NUMBER;

Line 2817: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => pr_order_line.ORG_ID);

2813: Removed the cursor set_of_books_cur and added the following check
2814: using plsql caching for performance issues reported.
2815: */
2816:
2817: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => pr_order_line.ORG_ID);
2818:
2819: v_set_of_books_id := l_func_curr_det.ledger_id;
2820:
2821: v_converted_rate := jai_cmn_utils_pkg.currency_conversion(v_set_of_books_id,

Line 4033: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

4029: v_address_id NUMBER;
4030: ln_inventory_item_id NUMBER;
4031: ln_line_id NUMBER;
4032:
4033: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
4034:
4035: CURSOR JAI_OM_OE_SO_LINES_cur(p_line_id NUMBER) IS
4036: SELECT quantity,
4037: assessable_value,

Line 4223: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_warehouse_id);

4219: /*
4220: Removed the cursor set_of_books_cur and added the following check
4221: using plsql caching for performance issues reported.
4222: */
4223: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_warehouse_id);
4224: v_set_of_books_id := l_func_curr_det.ledger_id;
4225:
4226: v_conv_factor := jai_cmn_utils_pkg.currency_conversion(v_set_of_books_id,
4227: v_currency_code,