declare
 p_api_version_number    NUMBER :=1.0;
    init_msg_list           VARCHAR2(200);
    x_msg_details           VARCHAR2(3000);
    x_msg_summary           VARCHAR2(3000);     
    p_line_rows             WSH_UTIL_CORE.ID_TAB_TYPE;
    x_del_rows              WSH_UTIL_CORE.ID_TAB_TYPE;
    l_ship_method_code      VARCHAR2(100);
    l_commit                VARCHAR2(30);       
    p_delivery_id           NUMBER;
    p_delivery_name         VARCHAR2(30);
    x_trip_id               VARCHAR2(30);
    x_trip_name             VARCHAR2(30); 
    l_picked_flag           VARCHAR2(10);
    l_return_status    VARCHAR2(1000);
    l_msg_count        NUMBER;
    l_msg_data         VARCHAR2(1000); 
	l_detail  number;
	x_return_status varchar2(100);
	x_msg_count   varchar2(100);
	x_msg_data    varchar2(100);
	BEGIN
    SELECT DELIVERY_DETAIL_ID INTO l_detail FROM WSH_DELIVERY_DETAILS WHERE SOURCE_HEADER_ID=(
SELECT HEADER_ID    FROM OE_ORDER_HEADERS_ALL WHERE ORDER_NUMBER=58297 AND ORDER_SOURCE_ID=
(SELECT ORDER_SOURCE_ID FROM OE_ORDER_SOURCES WHERE NAME='Online') AND 	ORDER_TYPE_ID=
(SELECT TRANSACTION_TYPE_ID FROM OE_TRANSACTION_TYPES_TL WHERE NAME ='Mixed'));	   
 
    fnd_global.apps_initialize( 1318, 21623, 660 );  
    x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;  
	 p_line_rows(1):= l_detail;
	 WSH_DELIVERY_DETAILS_PUB.AUTOCREATE_DELIVERIES(   
               p_api_version_number     => 1.0,              
               p_init_msg_list          => APPS.FND_API.G_TRUE,              
               p_commit                 => l_commit,              
               x_return_status          => x_return_status,              
               x_msg_count              => x_msg_count,              
               x_msg_data               => x_msg_data,              
               p_line_rows       	      => p_line_rows,              
               x_del_rows               => x_del_rows );
	   p_delivery_id := x_del_rows(1);
       p_delivery_name := TO_CHAR( x_del_rows(1) );
       l_detail := p_delivery_id;
        wsh_deliveries_pub.delivery_action( 
            p_api_version_number => 1.0 , 
            p_init_msg_list => null,  
            x_return_status => x_return_status,  
            x_msg_count => x_msg_count,  
            x_msg_data => x_msg_data,   
            p_action_code => 'PICK-RELEASE',   
            p_delivery_id => p_delivery_id,  
            p_delivery_name => p_delivery_name,   
            x_trip_id => x_trip_id,   
            x_trip_name => x_trip_name  
            ); 
          
IF X_RETURN_STATUS=FND_API.G_RET_STS_SUCCESS THEN
DBMS_OUTPUT.PUT_LINE('SUCESS');
COMMIT;
ELSE
DBMS_OUTPUT.PUT_LINE('FAILURE');
ROLLBACK;
END IF;
DBMS_OUTPUT.PUT_LINE('return staus is:'||X_RETURN_STATUS);
DBMS_OUTPUT.PUT_LINE('message count is :'||X_MSG_COUNT);
DBMS_OUTPUT.PUT_LINE('message data is :'|| X_MSG_DATA);
DBMS_OUTPUT.PUT_LINE('TRIP_ID IS '||x_trip_id );
DBMS_OUTPUT.PUT_LINE('TRIP_NAME IS :'||  x_trip_name);
END;