1 PACKAGE WSH_OTM_INBOUND_GRP as
2 /* $Header: WSHOTMIS.pls 120.0.12010000.1 2008/07/29 06:16:17 appldev ship $ */
3
4 --***************************************************************************--
5 --========================================================================
6 -- PROCEDURE : initiate_planned_shipment Called by the WSH Inbound BPEL Process
7 --
8 -- PARAMETERS: p_int_trip_info Table of trip records to process into the interface table
9 -- The trip record is a nested object containing
10 -- Stop, releases, Legs and Freight Costs
11 -- x_output_request_id Concurrent request_id of the instance launched for WSHOTMRL
12 -- x_msg_count Number of messages
13 -- x_msg_data Message Data
14 -- x_return_status Return status
15 -- COMMENT : This procedure is used to perform for following actions
16 -- Takes a table of trip records to process
17 -- Processes the trip and children stops, releases and legs
18 -- and inserts into the WSH Interface tables
19 -- Then launches the WSHOTMRL concurrent program
20 --========================================================================
21
22 PROCEDURE initiate_planned_shipment( p_int_trip_info IN WSH_OTM_TRIP_TAB,
23 x_output_request_id OUT NOCOPY NUMBER,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2);
27
28 END WSH_OTM_INBOUND_GRP;
29