Tuesday, October 28, 2008

Pricing an Order

Suppose you need to price an order then OE_ORDER_PUB.price_order does not help much. I do not know what this API does? OE_ORDER_ADJ_PVT.price_action does work correctly. Sample code to use OE_ORDER_ADJ_PVT.price_action is given below


DECLARE
l_return_status VARCHAR2(30);
l_msg_count NUMBER;
l_msg_data VARCHAR2(2000);
BEGIN
DBMS_APPLICATION_INFO.set_client_info('1');
FND_GLOBAL.apps_initialize(:user_id,21623,660);

OE_ORDER_ADJ_PVT.price_action
( p_Header_count => 1
, p_Header_list => :header_id_list
, p_line_count => NULL
, p_line_List => NULL
, P_price_level => 'ORDER'
, x_Return_Status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
) ;
DBMS_OUTPUT.put_line('Ret Status:' || l_return_status);
DBMS_OUTPUT.put_line('Message:' || l_msg_data);
END;

2 comments: