Monday, March 8, 2010
How to do UOM Conversions through api? ( inv_convert.inv_um_convert_new )
We have an api named inv_convert.inv_um_convert_new that can be used for UOM conversions
The parameter precision can be varied from NULL to value supported by your receiving variable.
Note : This code has been tested in R12.1.1 instance.
set serveroutput on;
Declare
v_Rate Number(30,23);
v_suom varchar2(20) default 'BK';
v_puom varchar2(20) default 'KG';
v_itemid number default '12345';
Begin
v_rate := inv_convert.inv_um_convert_new (
item_id => v_itemid
,precision => NULL
,from_quantity => 1
,from_unit => v_suom
,to_unit => v_puom
,from_name => NULL
,to_name => NULL
,capacity_type => 'U'
);
dbms_output.put_line('Rate :' ||v_rate);
end;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
4 Responses to “How to do UOM Conversions through api? ( inv_convert.inv_um_convert_new )”
June 6, 2013 at 5:04 AM
I think very useful, but I have a problem.
This Api don´t work when I use a user alternative to APPS.
Do you can help-me?
Regards,
Evandro Kramer
June 20, 2013 at 1:39 PM
Excellent article. Really helped me out. Thanks Sandeep!
December 9, 2013 at 7:13 AM
After executing this API, where do I see the change in the front-end screen? Kindly let me know.
January 26, 2017 at 3:28 AM
what are the other values in Capacity type
Post a Comment