1 PACKAGE WSH_INTERFACE_GRP as
2 /* $Header: WSHINGPS.pls 120.1 2005/06/15 18:08:13 appldev $ */
3
4 --===================
5 -- PUBLIC VARS
6 --===================
7
8 -- SSN change
9 -- Constants for Stop Sequence Mode
10 G_STOP_SEQ_MODE_SSN NUMBER := 1;
11 G_STOP_SEQ_MODE_PAD NUMBER := 2;
12
13 --========================================================================
14 -- PROCEDURE : Delivery_Action Wrapper API PUBLIC
15 --
16 -- PARAMETERS: p_api_version_number known api version error number
17 -- p_init_msg_list FND_API.G_TRUE to reset list
18 -- x_return_status return status
19 -- x_msg_count number of messages in the list
20 -- x_msg_data text of messages
21 -- p_action_prms Record of caller, phase, action_code and other
22 -- parameters specific to the actions.
23 -- p_rec_attr_tab Table of Attributes for the delivery entity
24 -- x_delivery_out_rec Record of output parameters based on the actions.
25 -- VERSION : current version 1.0
26 -- initial version 1.0
27 -- COMMENT : This procedure is used to perform an action specified
28 -- in p_action_prms.action_code on an existing delivery identified
29 -- by p_rec_attr.delivery_id/p_rec_attr.name.
30 --========================================================================
31 PROCEDURE Delivery_Action
32 ( p_api_version_number IN NUMBER,
33 p_init_msg_list IN VARCHAR2,
34 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35 p_action_prms IN WSH_DELIVERIES_GRP.action_parameters_rectype,
36 p_delivery_id_tab IN wsh_util_core.id_tab_type,
37 x_delivery_out_rec OUT NOCOPY WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2);
41 --========================================================================
42
43 -- I Harmonization: rvishnuv ******* Actions ******
44
45 -- I Harmonization: rvishnuv ******* Create/Update ******
46 --========================================================================
47 -- PROCEDURE : Create_Update_Delivery Wrapper API PUBLIC
48 --
49 -- PARAMETERS: p_api_version_number known api version error buffer
50 -- p_init_msg_list FND_API.G_TRUE to reset list
51 -- x_return_status return status
52 -- x_msg_count number of messages in the list
53 -- x_msg_data text of messages
54 -- p_in_rec Record for caller, phase
55 -- and action_code ( CREATE-UPDATE )
56 -- p_rec_attr_tab Table of Attributes for the delivery entity
57 -- x_del_out_rec Record of delivery_id, and name of new deliveries,
58 -- VERSION : current version 1.0
59 -- initial version 1.0
60 -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information
61 -- specified in p_delivery_info
62 --========================================================================
63 PROCEDURE Create_Update_Delivery
64 ( p_api_version_number IN NUMBER,
65 p_init_msg_list IN VARCHAR2,
66 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67 p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type,
68 p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
69 x_del_out_rec_tab OUT NOCOPY WSH_DELIVERIES_GRP.Del_Out_Tbl_Type,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2);
73 --========================================================================
74
75 -- I Harmonization: rvishnuv ******* Create/Update ******
76
77
78 -- ---------------------------------------------------------------------
79 -- Procedure: Delivery_Detail_Action Wrapper API
80 --
81 -- Parameters:
82 --
83 -- Description: This procedure is the wrapper(overloaded) version for the
84 -- main delivery_detail_group API. This is for use by public APIs
85 -- and by other product APIs. This signature does not have
86 -- the form(UI) specific parameters
87 -- Created : Patchset I : Harmonziation Project
88 -- Created by: KVENKATE
89 -- -----------------------------------------------------------------------
90 PROCEDURE Delivery_Detail_Action
91 (
92 -- Standard Parameters
93 p_api_version_number IN NUMBER,
94 p_init_msg_list IN VARCHAR2,
95 p_commit IN VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99
100 -- Procedure specific Parameters
101 p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
102 p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
103 x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
104 );
105
106
107 -- ---------------------------------------------------------------------
108 -- Procedure: Create_Update_Delivery_Detail Wrapper API
109 --
110 -- Parameters:
111 --
112 -- Description: This procedure is the new API for wrapping the logic of CREATE/UPDATE of delivery details
113 -- Created : Patchset I - Harmonization Project
114 -- Created By : KVENKATE
115 -- -----------------------------------------------------------------------
116
117 PROCEDURE Create_Update_Delivery_Detail
118 (
119 -- Standard Parameters
120 p_api_version_number IN NUMBER,
121 p_init_msg_list IN VARCHAR2,
122 p_commit IN VARCHAR2,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126
127 -- Procedure Specific Parameters
128 p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type,
129 p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
130 x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
131 );
132
133
134
135 PROCEDURE Trip_Action
136 ( p_api_version_number IN NUMBER,
137 p_init_msg_list IN VARCHAR2,
138 p_commit IN VARCHAR2,
139 p_entity_id_tab IN wsh_util_core.id_tab_type,
140 p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
141 x_trip_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripActionOutRecType,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2);
145
146 PROCEDURE Stop_Action
147 ( p_api_version_number IN NUMBER,
148 p_init_msg_list IN VARCHAR2,
149 p_commit IN VARCHAR2,
150 p_entity_id_tab IN wsh_util_core.id_tab_type,
151 p_action_prms IN WSH_TRIP_STOPS_GRP.action_parameters_rectype,
152 x_stop_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopActionOutRecType,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2);
156
157 --heali
158 PROCEDURE CREATE_UPDATE_STOP(
159 p_api_version_number IN NUMBER,
160 p_init_msg_list IN VARCHAR2,
161 p_commit IN VARCHAR2,
162 p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
163 p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
164 x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2);
168
169 PROCEDURE Create_Update_Trip(
170 p_api_version_number IN NUMBER,
171 p_init_msg_list IN VARCHAR2,
172 p_commit IN VARCHAR2,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
177 p_In_rec IN WSH_TRIPS_GRP.tripInRecType,
178 x_Out_Tab OUT NOCOPY WSH_TRIPS_GRP.trip_Out_Tab_Type);
179
180 PROCEDURE Create_Update_Freight_Costs(
181 p_api_version_number IN NUMBER,
182 p_init_msg_list IN VARCHAR2,
183 p_commit IN VARCHAR2,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_freight_info_tab IN WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type,
188 p_in_rec IN WSH_FREIGHT_COSTS_GRP.freightInRecType,
189 x_out_tab OUT NOCOPY WSH_FREIGHT_COSTS_GRP.freight_out_tab_type);
190 --heali
191
192 PROCEDURE Update_Delivery_Leg(
193 p_api_version_number IN NUMBER,
194 p_init_msg_list IN VARCHAR2,
195 p_commit IN VARCHAR2,
196 p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
197 p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
198 x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2);
202
203 END WSH_INTERFACE_GRP;