Oracle API(Splite Delivery line)代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】 Oracle API(Splite Delivery line)

作者:bingo / 发布于2012/9/13/ 1384

Oracle API(Splite Delivery line)

<div>
SELECT * FROM OE_ORDER_HEADERS_ALL
WHERE ORDER_NUMBER ='110024565'

SELECT * FROM WSH_DELIVERY_DETAILS
WHERE SOURCE_HEADER_ID =925313
declare
        v_api_version      NUMBER :=  1.0;
 v_init_msg_list     VARCHAR2(30);
 v_commit            VARCHAR2(30);
 v_validation_level  NUMBER;
 x_return_status     VARCHAR2(1000);
        x_msg_count         NUMBER;
        x_msg_data          VARCHAR2(1000);
        p_from_detail_id   NUMBER :=  1676819;
        x_new_detail_id     NUMBER;
        x_split_quantity   NUMBER :=  250;
       x_split_quantity2   NUMBER  := 150;
 -- Procedure specific  parameters
 
begin
   wsh_delivery_details_pub.split_line
    (
   -- Standard parameters
    v_api_version,
   v_init_msg_list,
    v_commit ,
   v_validation_level,
    x_return_status,
   x_msg_count,
    x_msg_data,
   p_from_detail_id,
    x_new_detail_id,
   x_split_quantity,
    x_split_quantity2
     );
DBMS_OUTPUT.PUT_LINE('x_new_detail_id'||x_new_detail_id);
end;
</div>

试试其它关键字

　Splite　　Delivery　　li　

同语言下

可能有用的

bingo贡献的其它代码(3)