[Home] [Help]
PACKAGE: APPS.WSH_DELIVERIES_PUB
Source
1 PACKAGE WSH_DELIVERIES_PUB as
2 /* $Header: WSHDEPBS.pls 120.0.12000000.1 2007/01/16 05:44:34 appldev ship $ */
3 /*#
4 * This is the public interface for the Delivery entity. It allows
5 * execution of various Delivery functions, including creation, update
6 * of delivery and other actions.
7 * @rep:scope public
8 * @rep:product WSH
9 * @rep:displayname Delivery
10 * @rep:lifecycle active
11 * @rep:category BUSINESS_ENTITY WSH_DELIVERY
12 */
13
14 --===================
15 -- PUBLIC VARS
16 --===================
17
18 TYPE Delivery_Pub_Rec_Type IS RECORD (
19 DELIVERY_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20 NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21 DELIVERY_TYPE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
22 LOADING_SEQUENCE NUMBER DEFAULT FND_API.G_MISS_NUM,
23 LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
24 LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
25 INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
26 INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
27 INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
28 ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
29 ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
30 ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
31 ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
32 ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
33 CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
34 CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35 INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
36 INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
37 POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
38 POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
39 CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
40 CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
41 SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42 SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
43 FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44 FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
45 FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
46 FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
47 FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
48 FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
49 WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
50 DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
51 ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
52 ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53 ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
54 ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55 CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56 CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
57 ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
58 ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
59 ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
60 GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
61 NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
62 WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
63 WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
64 VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
65 VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
66 VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
67 ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
68 CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
69 CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
70 ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71 ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72 ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73 ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74 ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75 ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76 ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77 ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78 ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79 ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80 ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81 ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82 ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83 ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84 ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85 ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86 TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87 TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88 TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89 TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90 TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91 TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92 TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93 TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94 TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95 TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96 TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97 TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98 TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99 TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100 TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101 TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
103 GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104 GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105 GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106 GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107 GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108 GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109 GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110 GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111 GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112 GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113 GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114 GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115 GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116 GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117 GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118 GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119 GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120 GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121 GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122 GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123 CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
124 CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
125 LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
126 LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
127 LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
128 PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
129 PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
130 PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
131 REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
132 NUMBER_OF_LPN NUMBER DEFAULT FND_API.G_MISS_NUM,
133 /* Changes done for the shipping data model Bugfix#1918342*/
134 COD_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM,
135 COD_CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
136 COD_REMIT_TO VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
137 COD_CHARGE_PAID_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
138 PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
139 PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
140 PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
141 FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
142 ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
143 ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
144 ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
145 IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
146 SHIPPING_MARKS VARCHAR2(100) DEFAULT FND_API.G_MISS_CHAR,
147 SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
148 MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
149 ASSIGNED_TO_FTE_TRIPS VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
150 AUTO_SC_EXCLUDE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
151 AUTO_AP_EXCLUDE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
152 /* BUG 3667348*/
153 REASON_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
154 DESCRIPTION VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
155 --Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
156 PRORATE_WT_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
157 );
158
159 --===================
160 -- PROCEDURES
161 --===================
162
163 --========================================================================
164 -- PROCEDURE : Create_Update_Delivery PUBLIC
165 --
166 -- PARAMETERS: p_api_version_number known api versionerror buffer
167 -- p_init_msg_list FND_API.G_TRUE to reset list
168 -- x_return_status return status
169 -- x_msg_count number of messages in the list
170 -- x_msg_data text of messages
171 -- p_delivery_info Attributes for the delivery entity
172 -- p_delivery_name Delivery name for update
173 -- x_delivery_id - delivery_Id of new delivery,
174 -- x_name - Name of delivery
175 -- VERSION : current version 1.0
176 -- initial version 1.0
177 -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information
178 -- specified in p_delivery_info
179 --========================================================================
180
181 /*#
182 * Create or update a delivery with information specified in p_delivery_info
183 * @param p_api_version_number version number of the API
184 * @param p_init_msg_list messages will be initialized if set as true
185 * @param x_return_status return status of the API
186 * @param x_msg_count number of messages, if any
187 * @param x_msg_data message text, if any
188 * @param p_action_code action to be performed, could be 'CREATE' or 'UPDATE'
189 * @param p_delivery_info attributes for the delivery entity
190 * @param p_delivery_name delivery name for update
191 * @param x_delivery_id output parameter, delivery ID of new delivery
192 * @param x_name output parameter, delivery name of the new delivery
193 * @rep:scope public
194 * @rep:lifecycle active
195 * @rep:displayname Create Update Delivery
196 */
197 PROCEDURE Create_Update_Delivery
198 ( p_api_version_number IN NUMBER,
199 p_init_msg_list IN VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_action_code IN VARCHAR2,
204 p_delivery_info IN OUT NOCOPY Delivery_Pub_Rec_Type,
205 p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206 x_delivery_id OUT NOCOPY NUMBER,
207 x_name OUT NOCOPY VARCHAR2);
208
209
210 --========================================================================
211 -- PROCEDURE : Delivery_Action PUBLIC
212 --
213 -- PARAMETERS: p_api_version_number known api version error number
214 -- p_init_msg_list FND_API.G_TRUE to reset list
215 -- x_return_status return status
216 -- x_msg_count number of messages in the list
217 -- x_msg_data text of messages
218 -- p_action_code Delivery action code. Valid action codes are
219 -- 'PLAN','UNPLAN',
220 -- 'PACK','CONFIRM','RE-OPEN','IN-TRANSIT','CLOSE'
221 -- 'ASSIGN-TRIP','UNASSIGN-TRIP','AUTOCREATE-TRIP'
222 -- 'WT-VOL',
223 -- 'PICK-RELEASE',
224 -- 'DELETE'
225 -- p_delivery_id Delivery identifier
226 -- p_delivery_name Delivery name
227 -- p_asg_trip_id Trip identifier for assignment
228 -- p_asg_trip_name Trip name for assignment
229 -- p_asg_pickup_stop_id Stop id for pickup assignment
230 -- p_asg_pickup_loc_id Stop location for pickup assignment
231 -- p_asg_pickup_loc_code Stop location code for pickup assignment
232 -- p_asg_pickup_arr_date Stop location arrival date for pickup assignment
233 -- p_asg_pickup_dep_date Stop location departure date for pickup assignment
234 -- p_asg_dropoff_stop_id Stop id for dropoff assignment
235 -- p_asg_dropoff_loc_id Stop location for dropoff assignment
236 -- p_asg_dropoff_loc_code Stop location code for dropoff assignment
237 -- p_asg_dropoff_arr_date Stop location arrival date for dropoff assignment
238 -- p_asg_dropoff_dep_date Stop location departure date for dropoff assignment
239 -- p_sc_action_flag Ship Confirm option - 'S', 'B', 'T', 'A', 'C'
240 -- p_sc_intransit_flag Ship Confirm set in-transit flag
241 -- p_sc_close_trip_flag Ship Confirm close trip flag
242 -- p_sc_create_bol_flag Ship Confirm create BOL flag
243 -- p_sc_stage_del_flag Ship Confirm create delivery for stage qnt flag
244 -- p_sc_trip_ship_method Ship Confirm trip ship method
245 -- p_sc_actual_dep_date Ship Confirm actual departure date
246 -- p_sc_report_set_id Ship Confirm report set id
250 -- p_wv_override_flag Override flag for weight/volume calc
247 -- p_sc_report_set_name Ship Confirm report set name
248 -- p_sc_rule_id Ship Confirm rule id
249 -- p_sc_rule_name Ship Confirm rule name
251 -- x_trip_id Autocreated trip id
252 -- x_trip_name Autocreated trip name
253 -- VERSION : current version 1.0
254 -- initial version 1.0
255 -- COMMENT : This procedure is used to perform an action specified in p_action_code
256 -- on an existing delivery identified by p_delivery_id/p_delivery_name.
257 --========================================================================
258 /*#
259 * This procedure is used to perform an action specified in p_action_code
260 * on an existing delivery identified by p_delivery_id/p_delivery_name.
261 * @param p_api_version_number version number of the API
262 * @param p_init_msg_list messages will be initialized if set as true
263 * @param x_return_status return status of the API
264 * @param x_msg_count number of messages, if any
265 * @param x_msg_data message text, if any
266 * @param p_action_code action code, valid values are 'PLAN','UNPLAN','PACK','CONFIRM','RE-OPEN','IN-TRANSIT','CLOSE', 'ASSIGN-TRIP','UNASSIGN-TRIP','AUTOCREATE-TRIP', 'WT-VOL', 'PICK-RELEASE', 'DELETE'
267 * @param p_delivery_id delivery ID of the delivery
268 * @param p_delivery_name delivery name of the delivery
269 * @param p_asg_trip_id trip ID for assignment
270 * @param p_asg_trip_name trip name for assignment
271 * @param p_asg_pickup_stop_id stop ID for pickup assignment
272 * @param p_asg_pickup_loc_id stop location for pickup assignment
273 * @param p_asg_pickup_stop_seq obsolete, stop sequence number for pickup assignment
274 * @param p_asg_pickup_loc_code stop location code for pickup assignment
275 * @param p_asg_pickup_arr_date stop location arrival date for pickup assignment
276 * @param p_asg_pickup_dep_date stop location departure date for pickup assignment
277 * @param p_asg_dropoff_stop_id stop id for dropoff assignment
278 * @param p_asg_dropoff_loc_id stop location for dropoff assignment
279 * @param p_asg_dropoff_stop_seq obsolete, stop sequence number for dropoff assignment
280 * @param p_asg_dropoff_loc_code stop location code for dropoff assignment
281 * @param p_asg_dropoff_arr_date stop location arrival date for dropoff assignment
282 * @param p_asg_dropoff_dep_date stop location departure date for dropoff assignment
283 * @param p_sc_action_flag ship confirm option - 'S', 'B', 'T', 'A', 'C'
284 * @param p_sc_intransit_flag ship confirm set in-transit flag
285 * @param p_sc_close_trip_flag ship confirm close trip flag
286 * @param p_sc_create_bol_flag ship confirm create BOL flag
287 * @param p_sc_stage_del_flag ship confirm create delivery for staged quantity flag
288 * @param p_sc_trip_ship_method ship confirm trip ship method
289 * @param p_sc_actual_dep_date ship confirm actual departure date
290 * @param p_sc_report_set_id ship confirm report set id
291 * @param p_sc_report_set_name ship confirm report set name
292 * @param p_sc_defer_interface_flag ship confirm defer interface flag
293 * @param p_sc_send_945_flag ship confirm flag to trigger outbound shipment advise
294 * @param p_sc_rule_id ship confirm rule ID
295 * @param p_sc_rule_name ship confirm rule name
296 * @param p_wv_override_flag override flag for weight/volume calculation
297 * @param x_trip_id autocreated trip id
298 * @param x_trip_name autocreated trip name
299 * @rep:scope public
300 * @rep:lifecycle active
301 * @rep:displayname Delivery Action
302 */
303 PROCEDURE Delivery_Action
304 ( p_api_version_number IN NUMBER,
305 p_init_msg_list IN VARCHAR2,
306 x_return_status OUT NOCOPY VARCHAR2,
307 x_msg_count OUT NOCOPY NUMBER,
308 x_msg_data OUT NOCOPY VARCHAR2,
309 p_action_code IN VARCHAR2,
310 p_delivery_id IN NUMBER DEFAULT NULL,
311 p_delivery_name IN VARCHAR2 DEFAULT NULL,
312 p_asg_trip_id IN NUMBER DEFAULT NULL,
313 p_asg_trip_name IN VARCHAR2 DEFAULT NULL,
314 p_asg_pickup_stop_id IN NUMBER DEFAULT NULL,
315 p_asg_pickup_loc_id IN NUMBER DEFAULT NULL,
316 p_asg_pickup_stop_seq IN NUMBER DEFAULT NULL,/*h integration anxsharm*/
317 p_asg_pickup_loc_code IN VARCHAR2 DEFAULT NULL,
318 p_asg_pickup_arr_date IN DATE DEFAULT NULL,
319 p_asg_pickup_dep_date IN DATE DEFAULT NULL,
320 p_asg_dropoff_stop_id IN NUMBER DEFAULT NULL,
321 p_asg_dropoff_loc_id IN NUMBER DEFAULT NULL,
322 p_asg_dropoff_stop_seq IN NUMBER DEFAULT NULL,/*h integration anxsharm*/
323 p_asg_dropoff_loc_code IN VARCHAR2 DEFAULT NULL,
324 p_asg_dropoff_arr_date IN DATE DEFAULT NULL,
325 p_asg_dropoff_dep_date IN DATE DEFAULT NULL,
326 p_sc_action_flag IN VARCHAR2 DEFAULT 'S',
327 p_sc_intransit_flag IN VARCHAR2 DEFAULT 'N',
328 p_sc_close_trip_flag IN VARCHAR2 DEFAULT 'N',
329 p_sc_create_bol_flag IN VARCHAR2 DEFAULT 'N',
330 p_sc_stage_del_flag IN VARCHAR2 DEFAULT 'Y',
331 p_sc_trip_ship_method IN VARCHAR2 DEFAULT NULL,
332 p_sc_actual_dep_date IN DATE DEFAULT NULL,
333 p_sc_report_set_id IN NUMBER DEFAULT NULL,
334 p_sc_report_set_name IN VARCHAR2 DEFAULT NULL,
335 p_sc_defer_interface_flag IN VARCHAR2 DEFAULT 'Y',
336 p_sc_send_945_flag IN VARCHAR2 DEFAULT NULL,
337 p_sc_rule_id IN NUMBER DEFAULT NULL,
338 p_sc_rule_name IN VARCHAR2 DEFAULT NULL,
339 p_wv_override_flag IN VARCHAR2 DEFAULT 'N',
340 x_trip_id OUT NOCOPY VARCHAR2,
341 x_trip_name OUT NOCOPY VARCHAR2);
342
343 --============================================================================
344 -- PROCEDURE : Genereate_Documents PUBLIC
345 --
346 -- PARAMETERS : p_report_set_name report set name
347 -- p_organization_code organization code
348 -- p_delivery_name delivery name
349 -- x_msg_count Error Message Count
350 -- x_msg_data Error Message
351 -- x_return_status return status
352 --
353 -- VERSION : current version 1.0.1
354 -- initial version 1.0
355 --
356 -- COMMENT : This Procedure is created for Backward Compatability.
357 --
358 -- CREATED BY : version 1.0.1 UESHANKA
359 -- CREATION DT : version 1.0.1 12/MAR/2003
360 --
361 --============================================================================
362
363 /*#
364 * This procedure is used to perform an action specified in p_action_code
365 * on an existing delivery identified by p_delivery_id/p_delivery_name.
366 * @param p_report_set_name report set name
367 * @param p_organization_code organization code
368 * @param p_delivery_name delivery name
369 * @param x_msg_count number of messages, if any
370 * @param x_msg_data message text, if any
371 * @param x_return_status return status of the API
372 * @rep:scope public
373 * @rep:lifecycle active
374 * @rep:displayname Generate Documents
375 */
376 PROCEDURE Generate_Documents
377 ( p_report_set_name IN VARCHAR2,
378 p_organization_code IN VARCHAR2,
379 p_delivery_name IN WSH_UTIL_CORE.Column_Tab_Type,
380 x_msg_count OUT NOCOPY NUMBER,
381 x_msg_data OUT NOCOPY VARCHAR2,
382 x_return_status OUT NOCOPY VARCHAR2
383 );
384
385 END WSH_DELIVERIES_PUB;