[Home] [Help]
PACKAGE: APPS.WSH_DELIVERIES_PUB
Source
1 PACKAGE WSH_DELIVERIES_PUB AUTHID CURRENT_USER as
2 /* $Header: WSHDEPBS.pls 120.2 2010/08/06 16:24:13 anvarshn 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,
87 TP_ATTRIBUTE1 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,
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 -- LSP PROJECT
158 CLIENT_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
159 CLIENT_CODE VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
160 -- LSP PROJECT
161 -- RTV changes
162 CONSIGNEE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
163 );
164
165 --===================
169 --========================================================================
166 -- PROCEDURES
167 --===================
168
170 -- PROCEDURE : Create_Update_Delivery PUBLIC
171 --
172 -- PARAMETERS: p_api_version_number known api versionerror buffer
173 -- p_init_msg_list FND_API.G_TRUE to reset list
174 -- x_return_status return status
175 -- x_msg_count number of messages in the list
176 -- x_msg_data text of messages
177 -- p_delivery_info Attributes for the delivery entity
178 -- p_delivery_name Delivery name for update
179 -- x_delivery_id - delivery_Id of new delivery,
180 -- x_name - Name of delivery
181 -- VERSION : current version 1.0
182 -- initial version 1.0
183 -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information
184 -- specified in p_delivery_info
185 --========================================================================
186
187 /*#
188 * Create or update a delivery with information specified in p_delivery_info
189 * @param p_api_version_number version number of the API
190 * @param p_init_msg_list messages will be initialized if set as true
191 * @param x_return_status return status of the API
192 * @param x_msg_count number of messages, if any
193 * @param x_msg_data message text, if any
194 * @param p_action_code action to be performed, could be 'CREATE' or 'UPDATE'
195 * @param p_delivery_info attributes for the delivery entity
196 * @param p_delivery_name delivery name for update
197 * @param x_delivery_id output parameter, delivery ID of new delivery
198 * @param x_name output parameter, delivery name of the new delivery
199 * @rep:scope public
200 * @rep:lifecycle active
201 * @rep:displayname Create Update Delivery
202 */
203 PROCEDURE Create_Update_Delivery
204 ( p_api_version_number IN NUMBER,
205 p_init_msg_list IN VARCHAR2,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_action_code IN VARCHAR2,
210 p_delivery_info IN OUT NOCOPY Delivery_Pub_Rec_Type,
211 p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215
212 x_delivery_id OUT NOCOPY NUMBER,
213 x_name OUT NOCOPY VARCHAR2);
214
216 --========================================================================
217 -- PROCEDURE : Delivery_Action PUBLIC
218 --
219 -- PARAMETERS: p_api_version_number known api version error number
220 -- p_init_msg_list FND_API.G_TRUE to reset list
221 -- x_return_status return status
222 -- x_msg_count number of messages in the list
223 -- x_msg_data text of messages
224 -- p_action_code Delivery action code. Valid action codes are
225 -- 'PLAN','UNPLAN',
226 -- 'PACK','CONFIRM','RE-OPEN','IN-TRANSIT','CLOSE'
227 -- 'ASSIGN-TRIP','UNASSIGN-TRIP','AUTOCREATE-TRIP'
228 -- 'WT-VOL',
229 -- 'PICK-RELEASE',
230 -- 'DELETE'
231 -- p_delivery_id Delivery identifier
232 -- p_delivery_name Delivery name
233 -- p_asg_trip_id Trip identifier for assignment
234 -- p_asg_trip_name Trip name for assignment
235 -- p_asg_pickup_stop_id Stop id for pickup assignment
236 -- p_asg_pickup_loc_id Stop location for pickup assignment
237 -- p_asg_pickup_loc_code Stop location code for pickup assignment
238 -- p_asg_pickup_arr_date Stop location arrival date for pickup assignment
239 -- p_asg_pickup_dep_date Stop location departure date for pickup assignment
240 -- p_asg_dropoff_stop_id Stop id for dropoff assignment
241 -- p_asg_dropoff_loc_id Stop location for dropoff assignment
242 -- p_asg_dropoff_loc_code Stop location code for dropoff assignment
243 -- p_asg_dropoff_arr_date Stop location arrival date for dropoff assignment
244 -- p_asg_dropoff_dep_date Stop location departure date for dropoff assignment
248 -- p_sc_create_bol_flag Ship Confirm create BOL flag
245 -- p_sc_action_flag Ship Confirm option - 'S', 'B', 'T', 'A', 'C'
246 -- p_sc_intransit_flag Ship Confirm set in-transit flag
247 -- p_sc_close_trip_flag Ship Confirm close trip flag
249 -- p_sc_stage_del_flag Ship Confirm create delivery for stage qnt flag
250 -- p_sc_trip_ship_method Ship Confirm trip ship method
251 -- p_sc_actual_dep_date Ship Confirm actual departure date
252 -- p_sc_report_set_id Ship Confirm report set id
253 -- p_sc_report_set_name Ship Confirm report set name
254 -- p_sc_rule_id Ship Confirm rule id
255 -- p_sc_rule_name Ship Confirm rule name
256 -- p_wv_override_flag Override flag for weight/volume calc
257 -- x_trip_id Autocreated trip id
258 -- x_trip_name Autocreated trip name
259 -- VERSION : current version 1.0
260 -- initial version 1.0
261 -- COMMENT : This procedure is used to perform an action specified in p_action_code
262 -- on an existing delivery identified by p_delivery_id/p_delivery_name.
263 --========================================================================
264 /*#
265 * This procedure is used to perform an action specified in p_action_code
266 * on an existing delivery identified by p_delivery_id/p_delivery_name.
267 * @param p_api_version_number version number of the API
268 * @param p_init_msg_list messages will be initialized if set as true
269 * @param x_return_status return status of the API
270 * @param x_msg_count number of messages, if any
271 * @param x_msg_data message text, if any
272 * @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'
273 * @param p_delivery_id delivery ID of the delivery
274 * @param p_delivery_name delivery name of the delivery
275 * @param p_asg_trip_id trip ID for assignment
276 * @param p_asg_trip_name trip name for assignment
277 * @param p_asg_pickup_stop_id stop ID for pickup assignment
278 * @param p_asg_pickup_loc_id stop location for pickup assignment
279 * @param p_asg_pickup_stop_seq obsolete, stop sequence number for pickup assignment
280 * @param p_asg_pickup_loc_code stop location code for pickup assignment
281 * @param p_asg_pickup_arr_date stop location arrival date for pickup assignment
282 * @param p_asg_pickup_dep_date stop location departure date for pickup assignment
283 * @param p_asg_dropoff_stop_id stop id for dropoff assignment
284 * @param p_asg_dropoff_loc_id stop location for dropoff assignment
285 * @param p_asg_dropoff_stop_seq obsolete, stop sequence number for dropoff assignment
286 * @param p_asg_dropoff_loc_code stop location code for dropoff assignment
287 * @param p_asg_dropoff_arr_date stop location arrival date for dropoff assignment
288 * @param p_asg_dropoff_dep_date stop location departure date for dropoff assignment
289 * @param p_sc_action_flag ship confirm option - 'S', 'B', 'T', 'A', 'C'
290 * @param p_sc_intransit_flag ship confirm set in-transit flag
291 * @param p_sc_close_trip_flag ship confirm close trip flag
292 * @param p_sc_create_bol_flag ship confirm create BOL flag
293 * @param p_sc_stage_del_flag ship confirm create delivery for staged quantity flag
294 * @param p_sc_trip_ship_method ship confirm trip ship method
295 * @param p_sc_actual_dep_date ship confirm actual departure date
296 * @param p_sc_report_set_id ship confirm report set id
297 * @param p_sc_report_set_name ship confirm report set name
298 * @param p_sc_defer_interface_flag ship confirm defer interface flag
299 * @param p_sc_send_945_flag ship confirm flag to trigger outbound shipment advise
300 * @param p_sc_rule_id ship confirm rule ID
301 * @param p_sc_rule_name ship confirm rule name
302 * @param p_wv_override_flag override flag for weight/volume calculation
303 * @param x_trip_id autocreated trip id
304 * @param x_trip_name autocreated trip name
305 * @rep:scope public
306 * @rep:lifecycle active
307 * @rep:displayname Delivery Action
308 */
309 PROCEDURE Delivery_Action
310 ( p_api_version_number IN NUMBER,
311 p_init_msg_list IN VARCHAR2,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2,
315 p_action_code IN VARCHAR2,
316 p_delivery_id IN NUMBER DEFAULT NULL,
317 p_delivery_name IN VARCHAR2 DEFAULT NULL,
318 p_asg_trip_id IN NUMBER DEFAULT NULL,
319 p_asg_trip_name IN VARCHAR2 DEFAULT NULL,
320 p_asg_pickup_stop_id IN NUMBER DEFAULT NULL,
321 p_asg_pickup_loc_id IN NUMBER DEFAULT NULL,
322 p_asg_pickup_stop_seq IN NUMBER DEFAULT NULL,/*h integration anxsharm*/
323 p_asg_pickup_loc_code IN VARCHAR2 DEFAULT NULL,
324 p_asg_pickup_arr_date IN DATE DEFAULT NULL,
325 p_asg_pickup_dep_date IN DATE DEFAULT NULL,
326 p_asg_dropoff_stop_id IN NUMBER DEFAULT NULL,
327 p_asg_dropoff_loc_id IN NUMBER DEFAULT NULL,
328 p_asg_dropoff_stop_seq IN NUMBER DEFAULT NULL,/*h integration anxsharm*/
329 p_asg_dropoff_loc_code IN VARCHAR2 DEFAULT NULL,
333 p_sc_intransit_flag IN VARCHAR2 DEFAULT 'N',
330 p_asg_dropoff_arr_date IN DATE DEFAULT NULL,
331 p_asg_dropoff_dep_date IN DATE DEFAULT NULL,
332 p_sc_action_flag IN VARCHAR2 DEFAULT 'S',
334 p_sc_close_trip_flag IN VARCHAR2 DEFAULT 'N',
335 p_sc_create_bol_flag IN VARCHAR2 DEFAULT 'N',
336 p_sc_stage_del_flag IN VARCHAR2 DEFAULT 'Y',
337 p_sc_trip_ship_method IN VARCHAR2 DEFAULT NULL,
338 p_sc_actual_dep_date IN DATE DEFAULT NULL,
339 p_sc_report_set_id IN NUMBER DEFAULT NULL,
340 p_sc_report_set_name IN VARCHAR2 DEFAULT NULL,
341 p_sc_defer_interface_flag IN VARCHAR2 DEFAULT 'Y',
342 p_sc_send_945_flag IN VARCHAR2 DEFAULT NULL,
343 p_sc_rule_id IN NUMBER DEFAULT NULL,
344 p_sc_rule_name IN VARCHAR2 DEFAULT NULL,
345 p_wv_override_flag IN VARCHAR2 DEFAULT 'N',
346 x_trip_id OUT NOCOPY VARCHAR2,
347 x_trip_name OUT NOCOPY VARCHAR2);
348
349 --============================================================================
350 -- PROCEDURE : Genereate_Documents PUBLIC
351 --
352 -- PARAMETERS : p_report_set_name report set name
353 -- p_organization_code organization code
354 -- p_delivery_name delivery name
355 -- x_msg_count Error Message Count
356 -- x_msg_data Error Message
357 -- x_return_status return status
358 --
359 -- VERSION : current version 1.0.1
360 -- initial version 1.0
361 --
362 -- COMMENT : This Procedure is created for Backward Compatability.
363 --
364 -- CREATED BY : version 1.0.1 UESHANKA
365 -- CREATION DT : version 1.0.1 12/MAR/2003
366 --
367 --============================================================================
368
369 /*#
370 * This procedure is used to perform an action specified in p_action_code
371 * on an existing delivery identified by p_delivery_id/p_delivery_name.
372 * @param p_report_set_name report set name
373 * @param p_organization_code organization code
374 * @param p_delivery_name delivery name
375 * @param x_msg_count number of messages, if any
376 * @param x_msg_data message text, if any
377 * @param x_return_status return status of the API
378 * @rep:scope public
379 * @rep:lifecycle active
380 * @rep:displayname Generate Documents
381 */
382 PROCEDURE Generate_Documents
383 ( p_report_set_name IN VARCHAR2,
384 p_organization_code IN VARCHAR2,
385 p_delivery_name IN WSH_UTIL_CORE.Column_Tab_Type,
386 x_msg_count OUT NOCOPY NUMBER,
387 x_msg_data OUT NOCOPY VARCHAR2,
388 x_return_status OUT NOCOPY VARCHAR2
389 );
390
391 END WSH_DELIVERIES_PUB;