643: -- Start of Bug #3134082
644:
645: /*
646: || Code added by aiyer for the bug 4035566
647: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
648: */
649:
650: --File.Sql.35 Cbabu
651: v_header_id := pr_new.header_id;
920: (p_org_id => v_warehouse_id);
921:
922: v_set_of_books_id := l_func_curr_det.ledger_id;
923:
924: v_conv_factor := jai_cmn_utils_pkg.currency_conversion( v_set_of_books_id ,
925: v_currency_code ,
926: v_conv_date ,
927: v_conv_type_code ,
928: v_conv_rate
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
2833: , v_conv_type_code
2834: , v_conv_rate );
3007: (p_org_id => v_operating_id );
3008:
3009: v_set_of_books_id := l_func_curr_det.ledger_id;
3010:
3011: v_converted_rate :=jai_cmn_utils_pkg.currency_conversion
3012: ( v_set_of_books_id , v_currency_code , v_conv_date , v_conv_type_code, v_conv_rate );
3013: /*
3014: Code added by aiyer for the bug 3700249
3015: */
3649:
3650: v_set_of_books_id := l_func_curr_det.ledger_id;
3651:
3652:
3653: v_converted_rate :=jai_cmn_utils_pkg.currency_conversion (
3654: v_set_of_books_id ,
3655: v_currency_code ,
3656: v_conv_date ,
3657: v_conv_type_code,
5135: BEGIN
5136: pv_return_code := jai_constants.successful ;
5137: /*
5138: || Code added by aiyer for the bug 4035566
5139: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
5140: */
5141: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_OE_ORDER_LINES_AU_TRG' ,
5142: -- p_org_id => pr_new.org_id
5143: -- ) = FALSE
5137: /*
5138: || Code added by aiyer for the bug 4035566
5139: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
5140: */
5141: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_OE_ORDER_LINES_AU_TRG' ,
5142: -- p_org_id => pr_new.org_id
5143: -- ) = FALSE
5144: --THEN
5145: /*
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 ,
5233: v_currency_code ,
5234: v_conv_date ,
5235: v_conv_type_code ,
5236: v_conv_rate