[Home] [Help]
PACKAGE: APPS.WSH_TRIPS_GRP
Source
1 PACKAGE WSH_TRIPS_GRP as
2 /* $Header: WSHTRGPS.pls 120.0.12000000.1 2007/01/16 05:51:38 appldev ship $ */
3
4 --===================
5 -- PUBLIC VARS
6 --===================
7
8 TYPE Trip_Pub_Rec_Type IS RECORD (
9 TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
10 NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
11 ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
12 ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
13 VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
14 VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
15 VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16 VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
17 VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
18 VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
19 CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20 SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21 SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
22 ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23 ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
24 ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
25 ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
26 ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27 ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28 ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29 ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30 ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31 ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32 ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33 ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34 ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35 ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36 ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37 ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38 ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39 ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40 SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41 MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42 CONSOLIDATION_ALLOWED VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
43 PLANNED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
44 STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
45 FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
46 -- anxsharm for Load Tender, increase to 30
47 LOAD_TENDER_STATUS VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
48 ROUTE_LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
49 LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
50 SCHEDULE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51 BOOKING_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
52 CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53 CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54 LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
55 LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
56 LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
57 PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
58 PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59 PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
60 REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
61 CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
62 CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR);
63
64
65 --Harmonizing Project -I
66 TYPE TripInRecType is RECORD(
67 caller VARCHAR2(32767),
68 phase NUMBER,
69 action_code VARCHAR2(32767));
70
71 TYPE tripActionInRecType
72 IS
73 RECORD
74 (
75 action_code VARCHAR2(32767),
76 wv_override_flag VARCHAR2(1) DEFAULT 'N'
77 );
78
79 TYPE tripOutRecType IS RECORD
80 (
81 rowid VARCHAR2(32767),
82 trip_id NUMBER,
83 trip_name VARCHAR2(32767)
84 );
85
86 TYPE tripActionOutRecType
87 IS
88 RECORD
89 (
90 result_id_tab wsh_util_core.id_tab_type,
91 valid_ids_tab wsh_util_core.id_tab_type,
92 selection_issue_flag VARCHAR2(1)
93 );
94
95 TYPE default_parameters_rectype IS RECORD (
96 parameter1 varchar2(1),
97 defer_interface_flag VARCHAR2(1), --] These parameters
98 report_set_id NUMBER, --] are used for
99 report_set_name VARCHAR2(30), --] action_code = 'CONFIRM'
100 trip_multiple_pickup VARCHAR2(1), --]
101 stop_location_code VARCHAR2(100) --]
102 );
103 --Harmonizing Project -I
104
105 TYPE action_parameters_rectype IS RECORD(
106 caller VARCHAR2(500)
107 ,phase NUMBER
108 ,action_code VARCHAR2(500)
109 ,organization_id NUMBER
110 ,report_set_id NUMBER
111 ,override_flag VARCHAR2(500)
112 ,trip_name wsh_trips.name%TYPE
113 ,actual_date DATE
114 ,stop_id NUMBER --] These parameters
115 ,action_flag VARCHAR2(1) --] are used for
116 ,autointransit_flag VARCHAR2(1) --] action_code = 'CONFIRM'
117 ,autoclose_flag VARCHAR2(1) --]
118 ,stage_del_flag VARCHAR2(1) --]
119 ,ship_method VARCHAR2(30) --]
120 ,bill_of_lading_flag VARCHAR2(1) --]
121 ,defer_interface_flag VARCHAR2(1) --]
122 ,actual_departure_date DATE --]
123 ,mbol_flag VARCHAR2(1) --] Added for Master Bill of Lading
124 );
125
126 --===================
127 -- NEW PROCEDURES
128 --===================
129
130 --========================================================================
131 -- PROCEDURE : Create_Update_Trip PUBLIC
132 --
133 -- PARAMETERS: p_api_version_number known api versionerror buffer
134 -- p_init_msg_list FND_API.G_TRUE to reset list
135 -- x_return_status return status
136 -- x_msg_count number of messages in the list
137 -- x_msg_data text of messages
138 -- p_trip_info Attributes for the trip entity
139 -- p_trip_IN_rec Input Attributes for the trip entity
140 -- p_trip_OUT_rec Output Attributes for the trip entity
141 -- VERSION : current version 1.0
142 -- initial version 1.0
143 -- COMMENT : Creates or updates a record in wsh_trips table with information
144 -- specified in p_trip_info
145 --========================================================================
146 PROCEDURE Create_Update_Trip_New
147 ( p_api_version_number IN NUMBER,
148 p_init_msg_list IN VARCHAR2,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_trip_info IN OUT NOCOPY Trip_Pub_Rec_Type,
153 p_trip_IN_rec IN tripInRecType,
154 p_trip_OUT_rec OUT NOCOPY tripOutRecType);
155
156 --========================================================================
157 -- PROCEDURE : Trip_Action PUBLIC
158 --
159 -- PARAMETERS: p_api_version_number known api version error number
160 -- p_init_msg_list FND_API.G_TRUE to reset list
161 -- x_return_status return status
162 -- x_msg_count number of messages in the list
163 -- x_msg_data text of messages
164 -- p_trip_info Attributes for the trip entity
165 -- p_trip_IN_rec Input Attributes for the trip entity
166 -- p_trip_OUT_rec Output Attributes for the trip entity
167 -- p_action_code Trip action code. Valid action codes are
168 -- 'PLAN','UNPLAN',
169 -- 'WT-VOL'
170 -- 'PICK-RELEASE'
171 -- 'DELETE'
172 -- VERSION : current version 1.0
173 -- initial version 1.0
174 -- COMMENT : This procedure is used to perform an action specified in p_action_code
175 -- on an existing trip identified by p_trip_id or trip_name
176 --
177 --========================================================================
178
179 PROCEDURE Trip_Action_New
180 ( p_api_version_number IN NUMBER,
181 p_init_msg_list IN VARCHAR2,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_trip_info IN OUT NOCOPY Trip_Pub_Rec_Type,
186 p_trip_IN_rec IN tripActionInRecType,
187 p_trip_OUT_rec OUT NOCOPY tripActionOutRecType);
188
189 --===================
190 -- OLD PROCEDURES
191 --===================
192
193 --========================================================================
194 -- PROCEDURE : Create_Update_Trip PUBLIC
195 --
196 -- PARAMETERS: p_api_version_number known api versionerror buffer
197 -- p_init_msg_list FND_API.G_TRUE to reset list
198 -- x_return_status return status
199 -- x_msg_count number of messages in the list
200 -- x_msg_data text of messages
201 -- p_trip_info Attributes for the trip entity
202 -- p_trip_name Trip name for update
203 -- x_trip_id Trip id of new trip
204 -- x_trip_name Trip name of new trip
205 -- VERSION : current version 1.0
206 -- initial version 1.0
207 -- COMMENT : Creates or updates a record in wsh_trips table with information
208 -- specified in p_trip_info
209 --========================================================================
210 PROCEDURE Create_Update_Trip
211 ( p_api_version_number IN NUMBER,
212 p_init_msg_list IN VARCHAR2,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_action_code IN VARCHAR2,
217 p_trip_info IN OUT NOCOPY Trip_Pub_Rec_Type,
218 p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219 x_trip_id OUT NOCOPY NUMBER,
220 x_trip_name OUT NOCOPY VARCHAR2);
221
222
223 --========================================================================
224 -- PROCEDURE : Trip_Action PUBLIC
225 --
226 -- PARAMETERS: p_api_version_number known api version error number
227 -- p_init_msg_list FND_API.G_TRUE to reset list
228 -- x_return_status return status
229 -- x_msg_count number of messages in the list
230 -- x_msg_data text of messages
231 -- p_action_code Trip action code. Valid action codes are
232 -- 'PLAN','UNPLAN',
233 -- 'WT-VOL'
234 -- 'PICK-RELEASE'
235 -- 'DELETE'
236 -- p_trip_id Trip identifier
237 -- p_trip_name Trip name
238 -- p_wv_override_flag Override flag for weight/volume calc
239 -- VERSION : current version 1.0
240 -- initial version 1.0
241 -- COMMENT : This procedure is used to perform an action specified in p_action_code
242 -- on an existing trip identified by p_trip_id or trip_name
243 --
244 --========================================================================
245
246 PROCEDURE Trip_Action
247 ( p_api_version_number IN NUMBER,
248 p_init_msg_list IN VARCHAR2,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2,
252 p_action_code IN VARCHAR2,
253 p_trip_id IN NUMBER DEFAULT NULL,
254 p_trip_name IN VARCHAR2 DEFAULT NULL,
255 p_wv_override_flag IN VARCHAR2 DEFAULT 'N');
256
257
258
259 PROCEDURE Trip_Action
260 ( p_api_version_number IN NUMBER,
261 p_init_msg_list IN VARCHAR2,
262 p_commit IN VARCHAR2,
263 p_action_prms IN action_parameters_rectype,
264 p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
265 x_trip_out_rec OUT NOCOPY tripActionOutRecType,
266 x_def_rec OUT NOCOPY default_parameters_rectype,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2);
270
271
272
273 --Harmonizing Project -I
274 TYPE trip_out_tab_type IS TABLE OF TripOutRecType INDEX BY BINARY_INTEGER;
275
276 PROCEDURE Create_Update_Trip(
277 p_api_version_number IN NUMBER,
278 p_init_msg_list IN VARCHAR2,
279 p_commit IN VARCHAR2,
280 p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
281 p_In_rec IN tripInRecType,
282 x_Out_Tab OUT NOCOPY trip_Out_Tab_Type,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2);
286
287 --Harmonizing Project -I
288
289 -- API to get trip details
290 PROCEDURE get_trip_details_pvt
291 (p_trip_id IN NUMBER,
292 x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,
293 x_return_status OUT NOCOPY VARCHAR2);
294
295 END WSH_TRIPS_GRP;