[Home] [Help]
17: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
18: v_currency_code gl_sets_of_books.currency_code%type;
19:
20: /* Bug 5095812. Added by Lakshmi Gopalsami */
21: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
22: /* Bug 5095812. Added by Lakshmi Gopalsami
23: Removed the cursors Fetch_Book_Id_Cur and
24: Sob_Cur as this is not used anywhere.
25: */
38: the following and implemented the same using cache.
39: Removed the existing commented codes.
40: */
41:
42: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
43: (p_org_id => v_operating_id );
44:
45: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
46: v_currency_code := l_func_curr_det.currency_code;
176: lv_shippable_flag VARCHAR2(1);
177: -- added by Allen Yang for bug 9666476 28-apr-2010, end
178:
179: /* Bug 5095812. Added by Lakshmi Gopalsami */
180: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
181: v_service_type_code varchar2(30);/*bduvarag for the bug#5694855*/
182: CURSOR bind_cur(p_header_id NUMBER) IS
183: SELECT rowid, nvl(org_id,0), sold_to_org_id,
184: source_document_id, order_number, price_list_id,
915: -- Start of changed by bgowrava for forward porting bug#4895477 to recalculate VAT taxes in case of copying order.
916:
917: /*Start by mmurtuza for bug 14675557*/
918:
919: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
920: (p_org_id => v_warehouse_id);
921:
922: v_set_of_books_id := l_func_curr_det.ledger_id;
923:
2824: -- added a call to the procedure ja_in_calc_taxes_ato - bgowrava for forward porting bug#4895477 so that tax recalculation can happen.
2825:
2826: -- added by Allen Yang for bug #9722577 27-May-2010, begin
2827: --------------------------------------------------------------------------------------
2828: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr( p_org_id => v_operating_id );
2829: v_set_of_books_id := l_func_curr_det.ledger_id;
2830: v_converted_rate :=jai_cmn_utils_pkg.currency_conversion( v_set_of_books_id
2831: , v_currency_code
2832: , v_conv_date
3002: added the following check using plsql caching for performance
3003: issues reported.
3004: */
3005:
3006: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
3007: (p_org_id => v_operating_id );
3008:
3009: v_set_of_books_id := l_func_curr_det.ledger_id;
3010:
3643: Removed the cursor set_of_books_cur and added the following check
3644: using plsql caching for performance issues reported.
3645: */
3646:
3647: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
3648: (p_org_id => v_operating_id);
3649:
3650: v_set_of_books_id := l_func_curr_det.ledger_id;
3651:
4942: ln_line_id NUMBER; --added for bug#9067808
4943:
4944:
4945: /* Bug 5095812. Added by Lakshmi Gopalsami */
4946: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
4947:
4948: CURSOR JAI_OM_OE_SO_LINES_cur(p_line_id NUMBER) IS
4949: SELECT quantity,
4950: --selling_price,
5224: Bug 5095812. Added by Lakshmi Gopalsami
5225: Removed the cursor set_of_books_cur and added the following check
5226: using plsql caching for performance issues reported.
5227: */
5228: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
5229: (p_org_id => v_warehouse_id);
5230: v_set_of_books_id := l_func_curr_det.ledger_id;
5231:
5232: v_conv_factor := jai_cmn_utils_pkg.currency_conversion( v_set_of_books_id ,