1 PACKAGE FTE_WORKFLOW_UTIL AS
2 /* $Header: FTEWKFUS.pls 120.1 2005/06/29 11:43:25 vphalak noship $ */
3
4 --===================
5 -- PROCEDURES
6 --===================
7
8 --========================================================================
9 -- PROCEDURE : Trip_Select_Service_Init
10 --
11 -- PARAMETERS: p_trip_id Trip Id
12 -- x_return_status Return status
13 --
14 -- COMMENT : This procedure accepts a trip and calls the procedures which
15 -- raises the Service Selection Initiation for the trip and
16 -- Select Service event for all the deliveries assigned to the trip.
17 --========================================================================
18 PROCEDURE Trip_Select_Service_Init(
19 p_trip_id IN NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2);
21
22 --========================================================================
23 -- PROCEDURE : Trip_Cancel_Service
24 --
25 -- PARAMETERS: p_trip_id Trip Id
26 -- x_return_status Return status
27 --
28 -- COMMENT : This procedure accepts a trip and calls the procedures which
29 -- raises the Cancel Service event for all the deliveries
30 -- assigned to the trip.
31 --========================================================================
32 PROCEDURE Trip_Cancel_Service(
33 p_trip_id IN NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2);
35
36 --========================================================================
37 -- PROCEDURE : Dleg_Select_Service
38 --
39 -- PARAMETERS: p_dleg_id Delivery Leg Id
40 -- x_return_status Return status
41 --
42 -- COMMENT : This procedure accepts a delivery leg and calls the procedures which
43 -- raises the Select Service Event for the delivery and Select Service
44 -- Initiation event for the trip to which the delivery is assigned.
45 --========================================================================
46 PROCEDURE Dleg_Select_Service(
47 p_dleg_id IN NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2);
49
50 --========================================================================
51 -- PROCEDURE : Dleg_Cancel_Service
52 --
53 -- PARAMETERS: p_dleg_id Delivery Leg Id
54 -- x_return_status Return status
55 --
56 -- COMMENT : This procedure accepts a delivery leg and calls the procedure which
57 -- raises the Cancel Service Event for the delivery.
58 --========================================================================
59 PROCEDURE Dleg_Cancel_Service(
60 p_dleg_id IN NUMBER,
61 x_return_status OUT NOCOPY VARCHAR2);
62
63
64 --========================================================================
65 -- PROCEDURE : Single_Trip_Sel_Ser_Init
66 --
67 -- PARAMETERS: p_trip_id Trip Id
68 -- x_return_status Return status
69 --
70 -- COMMENT : This procedure accepts a trip id and raises the Select Service
71 -- Initiated event for the trip.
72 --========================================================================
73
74 END FTE_WORKFLOW_UTIL;