1 package body wms_wp_wave_headers_pkg as
2 /* $Header: WMSWPTHB.pls 120.1.12010000.2 2009/08/03 08:19:58 ssrikaku noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_WAVE_HEADER_ID in NUMBER,
6 X_ATTRIBUTE15 in VARCHAR2,
7 X_WAVE_SOURCE in VARCHAR2,
8 X_WAVE_STATUS in VARCHAR2,
9 X_START_TIME in DATE,
10 X_TYPE_ID in VARCHAR2,
11 X_BATCH_ID in NUMBER,
12 X_SHIP_TO_LOCATION_ID in NUMBER,
13 X_CUSTOMER_CLASS_ID in VARCHAR2,
14 X_PULL_REPLENISHMENT_FLAG in VARCHAR2,
15 X_INITIATE_WAVE_PLANNING in VARCHAR2,
16 X_RELEASE_IMMEDIATELY in VARCHAR2,
17 X_TABLE_NAME in VARCHAR2,
18 X_ADVANCED_CRITERIA in VARCHAR2,
19 X_ORGANIZATION_ID in NUMBER,
20 X_PICK_SEQ_RULE_ID in NUMBER,
21 X_PICK_GROUPING_RULE_ID in NUMBER,
22 X_TRIP_ID in NUMBER,
23 X_TRIP_STOP_ID in NUMBER,
24 X_SHIP_METHOD_CODE in VARCHAR2,
25 X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
26 X_CARRIER_ID in NUMBER,
27 X_DELIVERY_ID in NUMBER,
28 X_FROM_ORDER_HEADER_ID in NUMBER,
29 X_ORDER_TYPE_ID in NUMBER,
30 X_CUSTOMER_ID in NUMBER,
31 X_TASK_ID in NUMBER,
32 X_PROJECT_ID in NUMBER,
33 X_CATEGORY_SET_ID in NUMBER,
34 X_CATEGORY_ID in NUMBER,
35 X_INVENTORY_ITEM_ID in NUMBER,
36 X_BACKORDERS_FLAG in VARCHAR2,
37 X_INCLUDE_PLANNED_LINES in VARCHAR2,
38 X_TASK_PLANNING_FLAG in VARCHAR2,
39 X_APPEND_DELIVERIES in VARCHAR2,
40 X_AUTO_CREATE_DELIVERY in VARCHAR2,
41 X_AUTO_CREATE_DELIVERY_CRITERI in VARCHAR2,
42 X_TASK_PRIORITY in NUMBER,
43 X_DEFAULT_STAGE_SUBINVENTORY in VARCHAR2,
44 X_DEFAULT_STAGE_LOCATOR_ID in NUMBER,
45 X_DEFAULT_ALLOCATION_METHOD in VARCHAR2,
46 X_WAVE_FIRMED_FLAG in VARCHAR2,
47 X_WAVE_COMPLETION_TIME in DATE,
48 X_ORDER_NAME in VARCHAR2,
49 X_CUSTOMER in VARCHAR2,
50 X_ORDER_TYPE in VARCHAR2,
51 X_CUSTOMER_CLASS in VARCHAR2,
52 X_SHIP_METHOD in VARCHAR2,
53 X_CARRIER in VARCHAR2,
54 X_SHIP_PRIORITY in VARCHAR2,
55 X_DELIVERY in VARCHAR2,
56 X_TRIP in VARCHAR2,
57 X_TRIP_STOP in VARCHAR2,
58 X_ITEM in VARCHAR2,
59 X_ITEM_CATEGORY in VARCHAR2,
60 X_PROJECT_NAME in VARCHAR2,
61 X_TASK_NAME in VARCHAR2,
62 X_SCHEDULED_DAYS in NUMBER,
63 X_SCHEDULED_HRS in NUMBER,
64 X_DOCK_APPOINTMENT_DAYS in NUMBER,
65 X_DOCK_APPOINTMENT_HOURS in NUMBER,
66 X_PICK_SLIP_GROUP in VARCHAR2,
67 X_RELEASE_SEQ_RULE in VARCHAR2,
68 X_STAGING_SUBINVENTORY in VARCHAR2,
69 X_STAGING_LOCATOR in VARCHAR2,
70 X_CROSS_DOCK_CRITERIA in VARCHAR2,
71 X_PICK_SUBINVENTORY in VARCHAR2,
72 X_PLANNING_CRITERIA in VARCHAR2,
73 X_PLANNING_CRITERIA_ID in NUMBER,
74 X_REQUEST_ID in NUMBER,
75 X_ATTRIBUTE_CATEGORY in VARCHAR2,
76 X_ATTRIBUTE1 in VARCHAR2,
77 X_ATTRIBUTE2 in VARCHAR2,
78 X_ATTRIBUTE3 in VARCHAR2,
79 X_ATTRIBUTE4 in VARCHAR2,
80 X_ATTRIBUTE5 in VARCHAR2,
81 X_ATTRIBUTE6 in VARCHAR2,
82 X_ATTRIBUTE7 in VARCHAR2,
83 X_ATTRIBUTE8 in VARCHAR2,
84 X_ATTRIBUTE9 in VARCHAR2,
85 X_ATTRIBUTE10 in VARCHAR2,
86 X_ATTRIBUTE11 in VARCHAR2,
87 X_ATTRIBUTE12 in VARCHAR2,
88 X_ATTRIBUTE13 in VARCHAR2,
89 X_ATTRIBUTE14 in VARCHAR2,
90 X_WAVE_NAME in VARCHAR2,
91 X_WAVE_DESCRIPTION in VARCHAR2,
92 X_CREATION_DATE in DATE,
93 X_CREATED_BY in NUMBER,
94 X_LAST_UPDATE_DATE in DATE,
95 X_LAST_UPDATED_BY in NUMBER,
96 X_LAST_UPDATE_LOGIN in NUMBER
97 ) is
98 cursor C is select ROWID from WMS_WP_WAVE_HEADERS_B
99 where WAVE_HEADER_ID = X_WAVE_HEADER_ID
100 ;
101
102 l_curvar C%rowtype;
103
104 begin
105 insert into WMS_WP_WAVE_HEADERS_B (
106 ATTRIBUTE15,
107 WAVE_HEADER_ID,
108 WAVE_SOURCE,
109 WAVE_STATUS,
110 START_TIME,
111 TYPE_ID,
112 BATCH_ID,
113 SHIP_TO_LOCATION_ID,
114 CUSTOMER_CLASS_ID,
115 PULL_REPLENISHMENT_FLAG,
116 INITIATE_WAVE_PLANNING,
117 RELEASE_IMMEDIATELY,
118 TABLE_NAME,
119 ADVANCED_CRITERIA,
120 ORGANIZATION_ID,
121 PICK_SEQ_RULE_ID,
122 PICK_GROUPING_RULE_ID,
123 TRIP_ID,
124 TRIP_STOP_ID,
125 SHIP_METHOD_CODE,
126 SHIPMENT_PRIORITY_CODE,
127 CARRIER_ID,
128 DELIVERY_ID,
129 FROM_ORDER_HEADER_ID,
130 ORDER_TYPE_ID,
131 CUSTOMER_ID,
132 TASK_ID,
133 PROJECT_ID,
134 CATEGORY_SET_ID,
135 CATEGORY_ID,
136 INVENTORY_ITEM_ID,
137 BACKORDERS_FLAG,
138 INCLUDE_PLANNED_LINES,
139 TASK_PLANNING_FLAG,
140 APPEND_DELIVERIES,
141 AUTO_CREATE_DELIVERY,
142 AUTO_CREATE_DELIVERY_CRITERIA,
143 TASK_PRIORITY,
144 DEFAULT_STAGE_SUBINVENTORY,
145 DEFAULT_STAGE_LOCATOR_ID,
146 DEFAULT_ALLOCATION_METHOD,
147 WAVE_FIRMED_FLAG,
148 WAVE_COMPLETION_TIME,
149 ORDER_NAME,
150 CUSTOMER,
151 ORDER_TYPE,
152 CUSTOMER_CLASS,
153 SHIP_METHOD,
154 CARRIER,
155 SHIP_PRIORITY,
156 DELIVERY,
157 TRIP,
158 TRIP_STOP,
159 ITEM,
160 ITEM_CATEGORY,
161 PROJECT_NAME,
162 TASK_NAME,
163 SCHEDULED_DAYS,
164 SCHEDULED_HRS,
165 DOCK_APPOINTMENT_DAYS,
166 DOCK_APPOINTMENT_HOURS,
167 PICK_SLIP_GROUP,
168 RELEASE_SEQ_RULE,
169 STAGING_SUBINVENTORY,
170 STAGING_LOCATOR,
171 CROSS_DOCK_CRITERIA,
172 PICK_SUBINVENTORY,
173 PLANNING_CRITERIA,
174 PLANNING_CRITERIA_ID,
175 REQUEST_ID,
176 ATTRIBUTE_CATEGORY,
177 ATTRIBUTE1,
178 ATTRIBUTE2,
179 ATTRIBUTE3,
180 ATTRIBUTE4,
181 ATTRIBUTE5,
182 ATTRIBUTE6,
183 ATTRIBUTE7,
184 ATTRIBUTE8,
185 ATTRIBUTE9,
186 ATTRIBUTE10,
187 ATTRIBUTE11,
188 ATTRIBUTE12,
189 ATTRIBUTE13,
190 ATTRIBUTE14,
191 CREATION_DATE,
192 CREATED_BY,
193 LAST_UPDATE_DATE,
194 LAST_UPDATED_BY,
195 LAST_UPDATE_LOGIN
196 ) values (
197 X_ATTRIBUTE15,
198 X_WAVE_HEADER_ID,
199 X_WAVE_SOURCE,
200 X_WAVE_STATUS,
201 X_START_TIME,
202 X_TYPE_ID,
203 X_BATCH_ID,
204 X_SHIP_TO_LOCATION_ID,
205 X_CUSTOMER_CLASS_ID,
206 X_PULL_REPLENISHMENT_FLAG,
207 X_INITIATE_WAVE_PLANNING,
208 X_RELEASE_IMMEDIATELY,
209 X_TABLE_NAME,
210 X_ADVANCED_CRITERIA,
211 X_ORGANIZATION_ID,
212 X_PICK_SEQ_RULE_ID,
213 X_PICK_GROUPING_RULE_ID,
214 X_TRIP_ID,
215 X_TRIP_STOP_ID,
216 X_SHIP_METHOD_CODE,
217 X_SHIPMENT_PRIORITY_CODE,
218 X_CARRIER_ID,
219 X_DELIVERY_ID,
220 X_FROM_ORDER_HEADER_ID,
221 X_ORDER_TYPE_ID,
222 X_CUSTOMER_ID,
223 X_TASK_ID,
224 X_PROJECT_ID,
225 X_CATEGORY_SET_ID,
226 X_CATEGORY_ID,
227 X_INVENTORY_ITEM_ID,
228 X_BACKORDERS_FLAG,
229 X_INCLUDE_PLANNED_LINES,
230 X_TASK_PLANNING_FLAG,
231 X_APPEND_DELIVERIES,
232 X_AUTO_CREATE_DELIVERY,
233 X_AUTO_CREATE_DELIVERY_CRITERI,
234 X_TASK_PRIORITY,
235 X_DEFAULT_STAGE_SUBINVENTORY,
236 X_DEFAULT_STAGE_LOCATOR_ID,
237 X_DEFAULT_ALLOCATION_METHOD,
238 X_WAVE_FIRMED_FLAG,
239 X_WAVE_COMPLETION_TIME,
240 X_ORDER_NAME,
241 X_CUSTOMER,
242 X_ORDER_TYPE,
243 X_CUSTOMER_CLASS,
244 X_SHIP_METHOD,
245 X_CARRIER,
246 X_SHIP_PRIORITY,
247 X_DELIVERY,
248 X_TRIP,
249 X_TRIP_STOP,
250 X_ITEM,
251 X_ITEM_CATEGORY,
252 X_PROJECT_NAME,
253 X_TASK_NAME,
254 X_SCHEDULED_DAYS,
255 X_SCHEDULED_HRS,
256 X_DOCK_APPOINTMENT_DAYS,
257 X_DOCK_APPOINTMENT_HOURS,
258 X_PICK_SLIP_GROUP,
259 X_RELEASE_SEQ_RULE,
260 X_STAGING_SUBINVENTORY,
261 X_STAGING_LOCATOR,
262 X_CROSS_DOCK_CRITERIA,
263 X_PICK_SUBINVENTORY,
264 X_PLANNING_CRITERIA,
265 X_PLANNING_CRITERIA_ID,
266 X_REQUEST_ID,
267 X_ATTRIBUTE_CATEGORY,
268 X_ATTRIBUTE1,
269 X_ATTRIBUTE2,
270 X_ATTRIBUTE3,
271 X_ATTRIBUTE4,
272 X_ATTRIBUTE5,
273 X_ATTRIBUTE6,
274 X_ATTRIBUTE7,
275 X_ATTRIBUTE8,
276 X_ATTRIBUTE9,
277 X_ATTRIBUTE10,
278 X_ATTRIBUTE11,
279 X_ATTRIBUTE12,
280 X_ATTRIBUTE13,
281 X_ATTRIBUTE14,
282 X_CREATION_DATE,
283 X_CREATED_BY,
284 X_LAST_UPDATE_DATE,
285 X_LAST_UPDATED_BY,
286 X_LAST_UPDATE_LOGIN
287 );
288
289 insert into WMS_WP_WAVE_HEADERS_TL (
290 WAVE_HEADER_ID,
291 WAVE_NAME,
292 WAVE_DESCRIPTION,
293 CREATED_BY,
294 CREATION_DATE,
295 LAST_UPDATED_BY,
296 LAST_UPDATE_DATE,
297 LAST_UPDATE_LOGIN,
298 LANGUAGE,
299 SOURCE_LANG
300 ) select
301 X_WAVE_HEADER_ID,
302 X_WAVE_NAME,
303 X_WAVE_DESCRIPTION,
304 X_CREATED_BY,
305 X_CREATION_DATE,
306 X_LAST_UPDATED_BY,
307 X_LAST_UPDATE_DATE,
308 X_LAST_UPDATE_LOGIN,
309 L.LANGUAGE_CODE,
310 userenv('LANG')
311 from FND_LANGUAGES L
312 where L.INSTALLED_FLAG in ('I', 'B')
313 and not exists
314 (select NULL
315 from WMS_WP_WAVE_HEADERS_TL T
316 where T.WAVE_HEADER_ID = X_WAVE_HEADER_ID
317 and T.LANGUAGE = L.LANGUAGE_CODE);
318
319 open c;
320 fetch c into l_curvar;
321 if (c%notfound) then
322 close c;
323 raise no_data_found;
324 end if;
325 close c;
326 end INSERT_ROW;
327
328 procedure LOCK_ROW (
329 X_WAVE_HEADER_ID in NUMBER,
330 X_ATTRIBUTE15 in VARCHAR2,
331 X_WAVE_SOURCE in VARCHAR2,
332 X_WAVE_STATUS in VARCHAR2,
333 X_START_TIME in DATE,
334 X_TYPE_ID in VARCHAR2,
335 X_BATCH_ID in NUMBER,
336 X_SHIP_TO_LOCATION_ID in NUMBER,
337 X_CUSTOMER_CLASS_ID in VARCHAR2,
338 X_PULL_REPLENISHMENT_FLAG in VARCHAR2,
339 X_INITIATE_WAVE_PLANNING in VARCHAR2,
340 X_RELEASE_IMMEDIATELY in VARCHAR2,
341 X_TABLE_NAME in VARCHAR2,
342 X_ADVANCED_CRITERIA in VARCHAR2,
343 X_ORGANIZATION_ID in NUMBER,
344 X_PICK_SEQ_RULE_ID in NUMBER,
345 X_PICK_GROUPING_RULE_ID in NUMBER,
346 X_TRIP_ID in NUMBER,
347 X_TRIP_STOP_ID in NUMBER,
348 X_SHIP_METHOD_CODE in VARCHAR2,
349 X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
350 X_CARRIER_ID in NUMBER,
351 X_DELIVERY_ID in NUMBER,
352 X_FROM_ORDER_HEADER_ID in NUMBER,
353 X_ORDER_TYPE_ID in NUMBER,
354 X_CUSTOMER_ID in NUMBER,
355 X_TASK_ID in NUMBER,
356 X_PROJECT_ID in NUMBER,
357 X_CATEGORY_SET_ID in NUMBER,
358 X_CATEGORY_ID in NUMBER,
359 X_INVENTORY_ITEM_ID in NUMBER,
360 X_BACKORDERS_FLAG in VARCHAR2,
361 X_INCLUDE_PLANNED_LINES in VARCHAR2,
362 X_TASK_PLANNING_FLAG in VARCHAR2,
363 X_APPEND_DELIVERIES in VARCHAR2,
364 X_AUTO_CREATE_DELIVERY in VARCHAR2,
365 X_AUTO_CREATE_DELIVERY_CRITERI in VARCHAR2,
366 X_TASK_PRIORITY in NUMBER,
367 X_DEFAULT_STAGE_SUBINVENTORY in VARCHAR2,
368 X_DEFAULT_STAGE_LOCATOR_ID in NUMBER,
369 X_DEFAULT_ALLOCATION_METHOD in VARCHAR2,
370 X_WAVE_FIRMED_FLAG in VARCHAR2,
371 X_WAVE_COMPLETION_TIME in DATE,
372 X_ORDER_NAME in VARCHAR2,
373 X_CUSTOMER in VARCHAR2,
374 X_ORDER_TYPE in VARCHAR2,
375 X_CUSTOMER_CLASS in VARCHAR2,
376 X_SHIP_METHOD in VARCHAR2,
377 X_CARRIER in VARCHAR2,
378 X_SHIP_PRIORITY in VARCHAR2,
379 X_DELIVERY in VARCHAR2,
380 X_TRIP in VARCHAR2,
381 X_TRIP_STOP in VARCHAR2,
382 X_ITEM in VARCHAR2,
383 X_ITEM_CATEGORY in VARCHAR2,
384 X_PROJECT_NAME in VARCHAR2,
385 X_TASK_NAME in VARCHAR2,
386 X_SCHEDULED_DAYS in NUMBER,
387 X_SCHEDULED_HRS in NUMBER,
388 X_DOCK_APPOINTMENT_DAYS in NUMBER,
389 X_DOCK_APPOINTMENT_HOURS in NUMBER,
390 X_PICK_SLIP_GROUP in VARCHAR2,
391 X_RELEASE_SEQ_RULE in VARCHAR2,
392 X_STAGING_SUBINVENTORY in VARCHAR2,
393 X_STAGING_LOCATOR in VARCHAR2,
394 X_CROSS_DOCK_CRITERIA in VARCHAR2,
395 X_PICK_SUBINVENTORY in VARCHAR2,
396 X_PLANNING_CRITERIA in VARCHAR2,
397 X_PLANNING_CRITERIA_ID in NUMBER,
398 X_REQUEST_ID in NUMBER,
399 X_ATTRIBUTE_CATEGORY in VARCHAR2,
400 X_ATTRIBUTE1 in VARCHAR2,
401 X_ATTRIBUTE2 in VARCHAR2,
402 X_ATTRIBUTE3 in VARCHAR2,
403 X_ATTRIBUTE4 in VARCHAR2,
404 X_ATTRIBUTE5 in VARCHAR2,
405 X_ATTRIBUTE6 in VARCHAR2,
406 X_ATTRIBUTE7 in VARCHAR2,
407 X_ATTRIBUTE8 in VARCHAR2,
408 X_ATTRIBUTE9 in VARCHAR2,
409 X_ATTRIBUTE10 in VARCHAR2,
410 X_ATTRIBUTE11 in VARCHAR2,
411 X_ATTRIBUTE12 in VARCHAR2,
412 X_ATTRIBUTE13 in VARCHAR2,
413 X_ATTRIBUTE14 in VARCHAR2,
414 X_WAVE_NAME in VARCHAR2,
415 X_WAVE_DESCRIPTION in VARCHAR2
416 ) is
417 cursor c is select
418 ATTRIBUTE15,
419 WAVE_SOURCE,
420 WAVE_STATUS,
421 START_TIME,
422 TYPE_ID,
423 BATCH_ID,
424 SHIP_TO_LOCATION_ID,
425 CUSTOMER_CLASS_ID,
429 TABLE_NAME,
426 PULL_REPLENISHMENT_FLAG,
427 INITIATE_WAVE_PLANNING,
428 RELEASE_IMMEDIATELY,
430 ADVANCED_CRITERIA,
431 ORGANIZATION_ID,
432 PICK_SEQ_RULE_ID,
433 PICK_GROUPING_RULE_ID,
434 TRIP_ID,
435 TRIP_STOP_ID,
436 SHIP_METHOD_CODE,
437 SHIPMENT_PRIORITY_CODE,
438 CARRIER_ID,
439 DELIVERY_ID,
440 FROM_ORDER_HEADER_ID,
441 ORDER_TYPE_ID,
442 CUSTOMER_ID,
443 TASK_ID,
444 PROJECT_ID,
445 CATEGORY_SET_ID,
446 CATEGORY_ID,
447 INVENTORY_ITEM_ID,
448 BACKORDERS_FLAG,
449 INCLUDE_PLANNED_LINES,
450 TASK_PLANNING_FLAG,
451 APPEND_DELIVERIES,
452 AUTO_CREATE_DELIVERY,
453 AUTO_CREATE_DELIVERY_CRITERIA,
454 TASK_PRIORITY,
455 DEFAULT_STAGE_SUBINVENTORY,
456 DEFAULT_STAGE_LOCATOR_ID,
457 DEFAULT_ALLOCATION_METHOD,
458 WAVE_FIRMED_FLAG,
459 WAVE_COMPLETION_TIME,
460 ORDER_NAME,
461 CUSTOMER,
462 ORDER_TYPE,
463 CUSTOMER_CLASS,
464 SHIP_METHOD,
465 CARRIER,
466 SHIP_PRIORITY,
467 DELIVERY,
468 TRIP,
469 TRIP_STOP,
470 ITEM,
471 ITEM_CATEGORY,
472 PROJECT_NAME,
473 TASK_NAME,
474 SCHEDULED_DAYS,
475 SCHEDULED_HRS,
476 DOCK_APPOINTMENT_DAYS,
477 DOCK_APPOINTMENT_HOURS,
478 PICK_SLIP_GROUP,
479 RELEASE_SEQ_RULE,
480 STAGING_SUBINVENTORY,
481 STAGING_LOCATOR,
482 CROSS_DOCK_CRITERIA,
483 PICK_SUBINVENTORY,
484 PLANNING_CRITERIA,
485 PLANNING_CRITERIA_ID,
486 REQUEST_ID,
487 ATTRIBUTE_CATEGORY,
488 ATTRIBUTE1,
489 ATTRIBUTE2,
490 ATTRIBUTE3,
491 ATTRIBUTE4,
492 ATTRIBUTE5,
493 ATTRIBUTE6,
494 ATTRIBUTE7,
495 ATTRIBUTE8,
496 ATTRIBUTE9,
497 ATTRIBUTE10,
498 ATTRIBUTE11,
499 ATTRIBUTE12,
500 ATTRIBUTE13,
501 ATTRIBUTE14
502 from WMS_WP_WAVE_HEADERS_B
503 where WAVE_HEADER_ID = X_WAVE_HEADER_ID
504 for update of WAVE_HEADER_ID nowait;
505 recinfo c%rowtype;
506
507 cursor c1 is select
508 WAVE_NAME,
509 WAVE_DESCRIPTION,
510 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
511 from WMS_WP_WAVE_HEADERS_TL
512 where WAVE_HEADER_ID = X_WAVE_HEADER_ID
513 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
514 for update of WAVE_HEADER_ID nowait;
515 begin
516 open c;
517 fetch c into recinfo;
518 if (c%notfound) then
519 close c;
520 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
521 app_exception.raise_exception;
522 end if;
523 close c;
524 if ( ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
525 OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
526 AND ((recinfo.WAVE_SOURCE = X_WAVE_SOURCE)
527 OR ((recinfo.WAVE_SOURCE is null) AND (X_WAVE_SOURCE is null)))
528 AND ((recinfo.WAVE_STATUS = X_WAVE_STATUS)
529 OR ((recinfo.WAVE_STATUS is null) AND (X_WAVE_STATUS is null)))
530 AND ((recinfo.START_TIME = X_START_TIME)
531 OR ((recinfo.START_TIME is null) AND (X_START_TIME is null)))
532 AND ((recinfo.TYPE_ID = X_TYPE_ID)
533 OR ((recinfo.TYPE_ID is null) AND (X_TYPE_ID is null)))
534 AND ((recinfo.BATCH_ID = X_BATCH_ID)
535 OR ((recinfo.BATCH_ID is null) AND (X_BATCH_ID is null)))
536 AND ((recinfo.SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID)
537 OR ((recinfo.SHIP_TO_LOCATION_ID is null) AND (X_SHIP_TO_LOCATION_ID is null)))
538 AND ((recinfo.CUSTOMER_CLASS_ID = X_CUSTOMER_CLASS_ID)
539 OR ((recinfo.CUSTOMER_CLASS_ID is null) AND (X_CUSTOMER_CLASS_ID is null)))
540 AND ((recinfo.PULL_REPLENISHMENT_FLAG = X_PULL_REPLENISHMENT_FLAG)
541 OR ((recinfo.PULL_REPLENISHMENT_FLAG is null) AND (X_PULL_REPLENISHMENT_FLAG is null)))
542 AND ((recinfo.INITIATE_WAVE_PLANNING = X_INITIATE_WAVE_PLANNING)
543 OR ((recinfo.INITIATE_WAVE_PLANNING is null) AND (X_INITIATE_WAVE_PLANNING is null)))
544 AND ((recinfo.RELEASE_IMMEDIATELY = X_RELEASE_IMMEDIATELY)
545 OR ((recinfo.RELEASE_IMMEDIATELY is null) AND (X_RELEASE_IMMEDIATELY is null)))
546 AND ((recinfo.TABLE_NAME = X_TABLE_NAME)
547 OR ((recinfo.TABLE_NAME is null) AND (X_TABLE_NAME is null)))
548 AND ((recinfo.ADVANCED_CRITERIA = X_ADVANCED_CRITERIA)
549 OR ((recinfo.ADVANCED_CRITERIA is null) AND (X_ADVANCED_CRITERIA is null)))
550 AND ((recinfo.ORGANIZATION_ID = X_ORGANIZATION_ID)
551 OR ((recinfo.ORGANIZATION_ID is null) AND (X_ORGANIZATION_ID is null)))
552 AND ((recinfo.PICK_SEQ_RULE_ID = X_PICK_SEQ_RULE_ID)
553 OR ((recinfo.PICK_SEQ_RULE_ID is null) AND (X_PICK_SEQ_RULE_ID is null)))
554 AND ((recinfo.PICK_GROUPING_RULE_ID = X_PICK_GROUPING_RULE_ID)
555 OR ((recinfo.PICK_GROUPING_RULE_ID is null) AND (X_PICK_GROUPING_RULE_ID is null)))
556 AND ((recinfo.TRIP_ID = X_TRIP_ID)
557 OR ((recinfo.TRIP_ID is null) AND (X_TRIP_ID is null)))
558 AND ((recinfo.TRIP_STOP_ID = X_TRIP_STOP_ID)
559 OR ((recinfo.TRIP_STOP_ID is null) AND (X_TRIP_STOP_ID is null)))
560 AND ((recinfo.SHIP_METHOD_CODE = X_SHIP_METHOD_CODE)
561 OR ((recinfo.SHIP_METHOD_CODE is null) AND (X_SHIP_METHOD_CODE is null)))
562 AND ((recinfo.SHIPMENT_PRIORITY_CODE = X_SHIPMENT_PRIORITY_CODE)
563 OR ((recinfo.SHIPMENT_PRIORITY_CODE is null) AND (X_SHIPMENT_PRIORITY_CODE is null)))
564 AND ((recinfo.CARRIER_ID = X_CARRIER_ID)
568 AND ((recinfo.FROM_ORDER_HEADER_ID = X_FROM_ORDER_HEADER_ID)
565 OR ((recinfo.CARRIER_ID is null) AND (X_CARRIER_ID is null)))
566 AND ((recinfo.DELIVERY_ID = X_DELIVERY_ID)
567 OR ((recinfo.DELIVERY_ID is null) AND (X_DELIVERY_ID is null)))
569 OR ((recinfo.FROM_ORDER_HEADER_ID is null) AND (X_FROM_ORDER_HEADER_ID is null)))
570 AND ((recinfo.ORDER_TYPE_ID = X_ORDER_TYPE_ID)
571 OR ((recinfo.ORDER_TYPE_ID is null) AND (X_ORDER_TYPE_ID is null)))
572 AND ((recinfo.CUSTOMER_ID = X_CUSTOMER_ID)
573 OR ((recinfo.CUSTOMER_ID is null) AND (X_CUSTOMER_ID is null)))
574 AND ((recinfo.TASK_ID = X_TASK_ID)
575 OR ((recinfo.TASK_ID is null) AND (X_TASK_ID is null)))
576 AND ((recinfo.PROJECT_ID = X_PROJECT_ID)
577 OR ((recinfo.PROJECT_ID is null) AND (X_PROJECT_ID is null)))
578 AND ((recinfo.CATEGORY_SET_ID = X_CATEGORY_SET_ID)
579 OR ((recinfo.CATEGORY_SET_ID is null) AND (X_CATEGORY_SET_ID is null)))
580 AND ((recinfo.CATEGORY_ID = X_CATEGORY_ID)
581 OR ((recinfo.CATEGORY_ID is null) AND (X_CATEGORY_ID is null)))
582 AND ((recinfo.INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID)
583 OR ((recinfo.INVENTORY_ITEM_ID is null) AND (X_INVENTORY_ITEM_ID is null)))
584 AND ((recinfo.BACKORDERS_FLAG = X_BACKORDERS_FLAG)
585 OR ((recinfo.BACKORDERS_FLAG is null) AND (X_BACKORDERS_FLAG is null)))
586 AND ((recinfo.INCLUDE_PLANNED_LINES = X_INCLUDE_PLANNED_LINES)
587 OR ((recinfo.INCLUDE_PLANNED_LINES is null) AND (X_INCLUDE_PLANNED_LINES is null)))
588 AND ((recinfo.TASK_PLANNING_FLAG = X_TASK_PLANNING_FLAG)
589 OR ((recinfo.TASK_PLANNING_FLAG is null) AND (X_TASK_PLANNING_FLAG is null)))
590 AND ((recinfo.APPEND_DELIVERIES = X_APPEND_DELIVERIES)
591 OR ((recinfo.APPEND_DELIVERIES is null) AND (X_APPEND_DELIVERIES is null)))
592 AND ((recinfo.AUTO_CREATE_DELIVERY = X_AUTO_CREATE_DELIVERY)
593 OR ((recinfo.AUTO_CREATE_DELIVERY is null) AND (X_AUTO_CREATE_DELIVERY is null)))
594 AND ((recinfo.AUTO_CREATE_DELIVERY_CRITERIA = X_AUTO_CREATE_DELIVERY_CRITERI)
595 OR ((recinfo.AUTO_CREATE_DELIVERY_CRITERIA is null) AND (X_AUTO_CREATE_DELIVERY_CRITERI is null)))
596 AND ((recinfo.TASK_PRIORITY = X_TASK_PRIORITY)
597 OR ((recinfo.TASK_PRIORITY is null) AND (X_TASK_PRIORITY is null)))
598 AND ((recinfo.DEFAULT_STAGE_SUBINVENTORY = X_DEFAULT_STAGE_SUBINVENTORY)
599 OR ((recinfo.DEFAULT_STAGE_SUBINVENTORY is null) AND (X_DEFAULT_STAGE_SUBINVENTORY is null)))
600 AND ((recinfo.DEFAULT_STAGE_LOCATOR_ID = X_DEFAULT_STAGE_LOCATOR_ID)
601 OR ((recinfo.DEFAULT_STAGE_LOCATOR_ID is null) AND (X_DEFAULT_STAGE_LOCATOR_ID is null)))
602 AND ((recinfo.DEFAULT_ALLOCATION_METHOD = X_DEFAULT_ALLOCATION_METHOD)
603 OR ((recinfo.DEFAULT_ALLOCATION_METHOD is null) AND (X_DEFAULT_ALLOCATION_METHOD is null)))
604 AND ((recinfo.WAVE_FIRMED_FLAG = X_WAVE_FIRMED_FLAG)
605 OR ((recinfo.WAVE_FIRMED_FLAG is null) AND (X_WAVE_FIRMED_FLAG is null)))
606 AND ((recinfo.WAVE_COMPLETION_TIME = X_WAVE_COMPLETION_TIME)
607 OR ((recinfo.WAVE_COMPLETION_TIME is null) AND (X_WAVE_COMPLETION_TIME is null)))
608 AND ((recinfo.ORDER_NAME = X_ORDER_NAME)
609 OR ((recinfo.ORDER_NAME is null) AND (X_ORDER_NAME is null)))
610 AND ((recinfo.CUSTOMER = X_CUSTOMER)
611 OR ((recinfo.CUSTOMER is null) AND (X_CUSTOMER is null)))
612 AND ((recinfo.ORDER_TYPE = X_ORDER_TYPE)
613 OR ((recinfo.ORDER_TYPE is null) AND (X_ORDER_TYPE is null)))
614 AND ((recinfo.CUSTOMER_CLASS = X_CUSTOMER_CLASS)
615 OR ((recinfo.CUSTOMER_CLASS is null) AND (X_CUSTOMER_CLASS is null)))
616 AND ((recinfo.SHIP_METHOD = X_SHIP_METHOD)
617 OR ((recinfo.SHIP_METHOD is null) AND (X_SHIP_METHOD is null)))
618 AND ((recinfo.CARRIER = X_CARRIER)
619 OR ((recinfo.CARRIER is null) AND (X_CARRIER is null)))
620 AND ((recinfo.SHIP_PRIORITY = X_SHIP_PRIORITY)
621 OR ((recinfo.SHIP_PRIORITY is null) AND (X_SHIP_PRIORITY is null)))
622 AND ((recinfo.DELIVERY = X_DELIVERY)
623 OR ((recinfo.DELIVERY is null) AND (X_DELIVERY is null)))
624 AND ((recinfo.TRIP = X_TRIP)
625 OR ((recinfo.TRIP is null) AND (X_TRIP is null)))
626 AND ((recinfo.TRIP_STOP = X_TRIP_STOP)
627 OR ((recinfo.TRIP_STOP is null) AND (X_TRIP_STOP is null)))
628 AND ((recinfo.ITEM = X_ITEM)
629 OR ((recinfo.ITEM is null) AND (X_ITEM is null)))
630 AND ((recinfo.ITEM_CATEGORY = X_ITEM_CATEGORY)
631 OR ((recinfo.ITEM_CATEGORY is null) AND (X_ITEM_CATEGORY is null)))
632 AND ((recinfo.PROJECT_NAME = X_PROJECT_NAME)
633 OR ((recinfo.PROJECT_NAME is null) AND (X_PROJECT_NAME is null)))
634 AND ((recinfo.TASK_NAME = X_TASK_NAME)
635 OR ((recinfo.TASK_NAME is null) AND (X_TASK_NAME is null)))
636 AND ((recinfo.SCHEDULED_DAYS = X_SCHEDULED_DAYS)
637 OR ((recinfo.SCHEDULED_DAYS is null) AND (X_SCHEDULED_DAYS is null)))
638 AND ((recinfo.SCHEDULED_HRS = X_SCHEDULED_HRS)
639 OR ((recinfo.SCHEDULED_HRS is null) AND (X_SCHEDULED_HRS is null)))
640 AND ((recinfo.DOCK_APPOINTMENT_DAYS = X_DOCK_APPOINTMENT_DAYS)
641 OR ((recinfo.DOCK_APPOINTMENT_DAYS is null) AND (X_DOCK_APPOINTMENT_DAYS is null)))
642 AND ((recinfo.DOCK_APPOINTMENT_HOURS = X_DOCK_APPOINTMENT_HOURS)
643 OR ((recinfo.DOCK_APPOINTMENT_HOURS is null) AND (X_DOCK_APPOINTMENT_HOURS is null)))
644 AND ((recinfo.PICK_SLIP_GROUP = X_PICK_SLIP_GROUP)
645 OR ((recinfo.PICK_SLIP_GROUP is null) AND (X_PICK_SLIP_GROUP is null)))
646 AND ((recinfo.RELEASE_SEQ_RULE = X_RELEASE_SEQ_RULE)
647 OR ((recinfo.RELEASE_SEQ_RULE is null) AND (X_RELEASE_SEQ_RULE is null)))
648 AND ((recinfo.STAGING_SUBINVENTORY = X_STAGING_SUBINVENTORY)
649 OR ((recinfo.STAGING_SUBINVENTORY is null) AND (X_STAGING_SUBINVENTORY is null)))
650 AND ((recinfo.STAGING_LOCATOR = X_STAGING_LOCATOR)
654 AND ((recinfo.PICK_SUBINVENTORY = X_PICK_SUBINVENTORY)
651 OR ((recinfo.STAGING_LOCATOR is null) AND (X_STAGING_LOCATOR is null)))
652 AND ((recinfo.CROSS_DOCK_CRITERIA = X_CROSS_DOCK_CRITERIA)
653 OR ((recinfo.CROSS_DOCK_CRITERIA is null) AND (X_CROSS_DOCK_CRITERIA is null)))
655 OR ((recinfo.PICK_SUBINVENTORY is null) AND (X_PICK_SUBINVENTORY is null)))
656 AND ((recinfo.PLANNING_CRITERIA = X_PLANNING_CRITERIA)
657 OR ((recinfo.PLANNING_CRITERIA is null) AND (X_PLANNING_CRITERIA is null)))
658 AND ((recinfo.PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID)
659 OR ((recinfo.PLANNING_CRITERIA_ID is null) AND (X_PLANNING_CRITERIA_ID is null)))
660 AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
661 OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
662 AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
663 OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
664 AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
665 OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
666 AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
667 OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
668 AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
669 OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
670 AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
671 OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
672 AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
673 OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
674 AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
675 OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
676 AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
677 OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
678 AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
679 OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
680 AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
681 OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
682 AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
683 OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
684 AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
685 OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
686 AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
687 OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
688 AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
689 OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
690 AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
691 OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
692 ) then
693 null;
694 else
695 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
696 app_exception.raise_exception;
697 end if;
698
699 for tlinfo in c1 loop
700 if (tlinfo.BASELANG = 'Y') then
701 if ( ((tlinfo.WAVE_NAME = X_WAVE_NAME)
702 OR ((tlinfo.WAVE_NAME is null) AND (X_WAVE_NAME is null)))
703 AND ((tlinfo.WAVE_DESCRIPTION = X_WAVE_DESCRIPTION)
704 OR ((tlinfo.WAVE_DESCRIPTION is null) AND (X_WAVE_DESCRIPTION is null)))
705 ) then
706 null;
707 else
708 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
709 app_exception.raise_exception;
710 end if;
711 end if;
712 end loop;
713 return;
714 end LOCK_ROW;
715
716 procedure UPDATE_ROW (
717 X_WAVE_HEADER_ID in NUMBER,
718 X_ATTRIBUTE15 in VARCHAR2,
719 X_WAVE_SOURCE in VARCHAR2,
720 X_WAVE_STATUS in VARCHAR2,
721 X_START_TIME in DATE,
722 X_TYPE_ID in VARCHAR2,
723 X_BATCH_ID in NUMBER,
724 X_SHIP_TO_LOCATION_ID in NUMBER,
725 X_CUSTOMER_CLASS_ID in VARCHAR2,
726 X_PULL_REPLENISHMENT_FLAG in VARCHAR2,
727 X_INITIATE_WAVE_PLANNING in VARCHAR2,
728 X_RELEASE_IMMEDIATELY in VARCHAR2,
729 X_TABLE_NAME in VARCHAR2,
730 X_ADVANCED_CRITERIA in VARCHAR2,
731 X_ORGANIZATION_ID in NUMBER,
732 X_PICK_SEQ_RULE_ID in NUMBER,
733 X_PICK_GROUPING_RULE_ID in NUMBER,
734 X_TRIP_ID in NUMBER,
735 X_TRIP_STOP_ID in NUMBER,
736 X_SHIP_METHOD_CODE in VARCHAR2,
737 X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
738 X_CARRIER_ID in NUMBER,
739 X_DELIVERY_ID in NUMBER,
740 X_FROM_ORDER_HEADER_ID in NUMBER,
741 X_ORDER_TYPE_ID in NUMBER,
742 X_CUSTOMER_ID in NUMBER,
743 X_TASK_ID in NUMBER,
744 X_PROJECT_ID in NUMBER,
745 X_CATEGORY_SET_ID in NUMBER,
746 X_CATEGORY_ID in NUMBER,
747 X_INVENTORY_ITEM_ID in NUMBER,
748 X_BACKORDERS_FLAG in VARCHAR2,
749 X_INCLUDE_PLANNED_LINES in VARCHAR2,
750 X_TASK_PLANNING_FLAG in VARCHAR2,
751 X_APPEND_DELIVERIES in VARCHAR2,
752 X_AUTO_CREATE_DELIVERY in VARCHAR2,
753 X_AUTO_CREATE_DELIVERY_CRITERI in VARCHAR2,
754 X_TASK_PRIORITY in NUMBER,
755 X_DEFAULT_STAGE_SUBINVENTORY in VARCHAR2,
756 X_DEFAULT_STAGE_LOCATOR_ID in NUMBER,
757 X_DEFAULT_ALLOCATION_METHOD in VARCHAR2,
758 X_WAVE_FIRMED_FLAG in VARCHAR2,
759 X_WAVE_COMPLETION_TIME in DATE,
760 X_ORDER_NAME in VARCHAR2,
761 X_CUSTOMER in VARCHAR2,
762 X_ORDER_TYPE in VARCHAR2,
763 X_CUSTOMER_CLASS in VARCHAR2,
764 X_SHIP_METHOD in VARCHAR2,
765 X_CARRIER in VARCHAR2,
766 X_SHIP_PRIORITY in VARCHAR2,
767 X_DELIVERY in VARCHAR2,
768 X_TRIP in VARCHAR2,
769 X_TRIP_STOP in VARCHAR2,
770 X_ITEM in VARCHAR2,
771 X_ITEM_CATEGORY in VARCHAR2,
772 X_PROJECT_NAME in VARCHAR2,
773 X_TASK_NAME in VARCHAR2,
774 X_SCHEDULED_DAYS in NUMBER,
775 X_SCHEDULED_HRS in NUMBER,
776 X_DOCK_APPOINTMENT_DAYS in NUMBER,
777 X_DOCK_APPOINTMENT_HOURS in NUMBER,
778 X_PICK_SLIP_GROUP in VARCHAR2,
779 X_RELEASE_SEQ_RULE in VARCHAR2,
783 X_PICK_SUBINVENTORY in VARCHAR2,
780 X_STAGING_SUBINVENTORY in VARCHAR2,
781 X_STAGING_LOCATOR in VARCHAR2,
782 X_CROSS_DOCK_CRITERIA in VARCHAR2,
784 X_PLANNING_CRITERIA in VARCHAR2,
785 X_PLANNING_CRITERIA_ID in NUMBER,
786 X_REQUEST_ID in NUMBER,
787 X_ATTRIBUTE_CATEGORY in VARCHAR2,
788 X_ATTRIBUTE1 in VARCHAR2,
789 X_ATTRIBUTE2 in VARCHAR2,
790 X_ATTRIBUTE3 in VARCHAR2,
791 X_ATTRIBUTE4 in VARCHAR2,
792 X_ATTRIBUTE5 in VARCHAR2,
793 X_ATTRIBUTE6 in VARCHAR2,
794 X_ATTRIBUTE7 in VARCHAR2,
795 X_ATTRIBUTE8 in VARCHAR2,
796 X_ATTRIBUTE9 in VARCHAR2,
797 X_ATTRIBUTE10 in VARCHAR2,
798 X_ATTRIBUTE11 in VARCHAR2,
799 X_ATTRIBUTE12 in VARCHAR2,
800 X_ATTRIBUTE13 in VARCHAR2,
801 X_ATTRIBUTE14 in VARCHAR2,
802 X_WAVE_NAME in VARCHAR2,
803 X_WAVE_DESCRIPTION in VARCHAR2,
804 X_LAST_UPDATE_DATE in DATE,
805 X_LAST_UPDATED_BY in NUMBER,
806 X_LAST_UPDATE_LOGIN in NUMBER
807 ) is
808 begin
809 update WMS_WP_WAVE_HEADERS_B set
810 ATTRIBUTE15 = X_ATTRIBUTE15,
811 WAVE_SOURCE = X_WAVE_SOURCE,
812 WAVE_STATUS = X_WAVE_STATUS,
813 START_TIME = X_START_TIME,
814 TYPE_ID = X_TYPE_ID,
815 BATCH_ID = X_BATCH_ID,
816 SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID,
817 CUSTOMER_CLASS_ID = X_CUSTOMER_CLASS_ID,
818 PULL_REPLENISHMENT_FLAG = X_PULL_REPLENISHMENT_FLAG,
819 INITIATE_WAVE_PLANNING = X_INITIATE_WAVE_PLANNING,
820 RELEASE_IMMEDIATELY = X_RELEASE_IMMEDIATELY,
821 TABLE_NAME = X_TABLE_NAME,
822 ADVANCED_CRITERIA = X_ADVANCED_CRITERIA,
823 ORGANIZATION_ID = X_ORGANIZATION_ID,
824 PICK_SEQ_RULE_ID = X_PICK_SEQ_RULE_ID,
825 PICK_GROUPING_RULE_ID = X_PICK_GROUPING_RULE_ID,
826 TRIP_ID = X_TRIP_ID,
827 TRIP_STOP_ID = X_TRIP_STOP_ID,
828 SHIP_METHOD_CODE = X_SHIP_METHOD_CODE,
829 SHIPMENT_PRIORITY_CODE = X_SHIPMENT_PRIORITY_CODE,
830 CARRIER_ID = X_CARRIER_ID,
831 DELIVERY_ID = X_DELIVERY_ID,
832 FROM_ORDER_HEADER_ID = X_FROM_ORDER_HEADER_ID,
833 ORDER_TYPE_ID = X_ORDER_TYPE_ID,
834 CUSTOMER_ID = X_CUSTOMER_ID,
835 TASK_ID = X_TASK_ID,
836 PROJECT_ID = X_PROJECT_ID,
837 CATEGORY_SET_ID = X_CATEGORY_SET_ID,
838 CATEGORY_ID = X_CATEGORY_ID,
839 INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
840 BACKORDERS_FLAG = X_BACKORDERS_FLAG,
841 INCLUDE_PLANNED_LINES = X_INCLUDE_PLANNED_LINES,
842 TASK_PLANNING_FLAG = X_TASK_PLANNING_FLAG,
843 APPEND_DELIVERIES = X_APPEND_DELIVERIES,
844 AUTO_CREATE_DELIVERY = X_AUTO_CREATE_DELIVERY,
845 AUTO_CREATE_DELIVERY_CRITERIA = X_AUTO_CREATE_DELIVERY_CRITERI,
846 TASK_PRIORITY = X_TASK_PRIORITY,
847 DEFAULT_STAGE_SUBINVENTORY = X_DEFAULT_STAGE_SUBINVENTORY,
848 DEFAULT_STAGE_LOCATOR_ID = X_DEFAULT_STAGE_LOCATOR_ID,
849 DEFAULT_ALLOCATION_METHOD = X_DEFAULT_ALLOCATION_METHOD,
850 WAVE_FIRMED_FLAG = X_WAVE_FIRMED_FLAG,
851 WAVE_COMPLETION_TIME = X_WAVE_COMPLETION_TIME,
852 ORDER_NAME = X_ORDER_NAME,
853 CUSTOMER = X_CUSTOMER,
854 ORDER_TYPE = X_ORDER_TYPE,
855 CUSTOMER_CLASS = X_CUSTOMER_CLASS,
856 SHIP_METHOD = X_SHIP_METHOD,
857 CARRIER = X_CARRIER,
858 SHIP_PRIORITY = X_SHIP_PRIORITY,
859 DELIVERY = X_DELIVERY,
860 TRIP = X_TRIP,
861 TRIP_STOP = X_TRIP_STOP,
862 ITEM = X_ITEM,
863 ITEM_CATEGORY = X_ITEM_CATEGORY,
864 PROJECT_NAME = X_PROJECT_NAME,
865 TASK_NAME = X_TASK_NAME,
866 SCHEDULED_DAYS = X_SCHEDULED_DAYS,
867 SCHEDULED_HRS = X_SCHEDULED_HRS,
868 DOCK_APPOINTMENT_DAYS = X_DOCK_APPOINTMENT_DAYS,
869 DOCK_APPOINTMENT_HOURS = X_DOCK_APPOINTMENT_HOURS,
870 PICK_SLIP_GROUP = X_PICK_SLIP_GROUP,
871 RELEASE_SEQ_RULE = X_RELEASE_SEQ_RULE,
872 STAGING_SUBINVENTORY = X_STAGING_SUBINVENTORY,
873 STAGING_LOCATOR = X_STAGING_LOCATOR,
874 CROSS_DOCK_CRITERIA = X_CROSS_DOCK_CRITERIA,
875 PICK_SUBINVENTORY = X_PICK_SUBINVENTORY,
876 PLANNING_CRITERIA = X_PLANNING_CRITERIA,
877 PLANNING_CRITERIA_ID = X_PLANNING_CRITERIA_ID,
878 REQUEST_ID = X_REQUEST_ID,
879 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
880 ATTRIBUTE1 = X_ATTRIBUTE1,
881 ATTRIBUTE2 = X_ATTRIBUTE2,
882 ATTRIBUTE3 = X_ATTRIBUTE3,
883 ATTRIBUTE4 = X_ATTRIBUTE4,
884 ATTRIBUTE5 = X_ATTRIBUTE5,
885 ATTRIBUTE6 = X_ATTRIBUTE6,
886 ATTRIBUTE7 = X_ATTRIBUTE7,
887 ATTRIBUTE8 = X_ATTRIBUTE8,
888 ATTRIBUTE9 = X_ATTRIBUTE9,
889 ATTRIBUTE10 = X_ATTRIBUTE10,
890 ATTRIBUTE11 = X_ATTRIBUTE11,
891 ATTRIBUTE12 = X_ATTRIBUTE12,
892 ATTRIBUTE13 = X_ATTRIBUTE13,
893 ATTRIBUTE14 = X_ATTRIBUTE14,
894 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
895 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
896 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
897 where WAVE_HEADER_ID = X_WAVE_HEADER_ID;
898
899 if (sql%notfound) then
900 raise no_data_found;
901 end if;
902
903 update WMS_WP_WAVE_HEADERS_TL set
904 WAVE_NAME = X_WAVE_NAME,
905 WAVE_DESCRIPTION = X_WAVE_DESCRIPTION,
906 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
907 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
908 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
909 SOURCE_LANG = userenv('LANG')
910 where WAVE_HEADER_ID = X_WAVE_HEADER_ID
911 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
912
913 if (sql%notfound) then
914 raise no_data_found;
915 end if;
916 end UPDATE_ROW;
917
918 procedure DELETE_ROW (
919 X_WAVE_HEADER_ID in NUMBER
920 ) is
921 begin
922 delete from WMS_WP_WAVE_HEADERS_TL
923 where WAVE_HEADER_ID = X_WAVE_HEADER_ID;
924
925 if (sql%notfound) then
926 raise no_data_found;
927 end if;
928
932 if (sql%notfound) then
929 delete from WMS_WP_WAVE_HEADERS_B
930 where WAVE_HEADER_ID = X_WAVE_HEADER_ID;
931
933 raise no_data_found;
934 end if;
935 end DELETE_ROW;
936
937 procedure ADD_LANGUAGE
938 is
939 begin
940 delete from WMS_WP_WAVE_HEADERS_TL T
941 where not exists
942 (select NULL
943 from WMS_WP_WAVE_HEADERS_B B
944 where B.WAVE_HEADER_ID = T.WAVE_HEADER_ID
945 );
946
947 update WMS_WP_WAVE_HEADERS_TL T set (
948 WAVE_NAME,
949 WAVE_DESCRIPTION
950 ) = (select
951 B.WAVE_NAME,
952 B.WAVE_DESCRIPTION
953 from WMS_WP_WAVE_HEADERS_TL B
954 where B.WAVE_HEADER_ID = T.WAVE_HEADER_ID
955 and B.LANGUAGE = T.SOURCE_LANG)
956 where (
957 T.WAVE_HEADER_ID,
958 T.LANGUAGE
959 ) in (select
960 SUBT.WAVE_HEADER_ID,
961 SUBT.LANGUAGE
962 from WMS_WP_WAVE_HEADERS_TL SUBB, WMS_WP_WAVE_HEADERS_TL SUBT
963 where SUBB.WAVE_HEADER_ID = SUBT.WAVE_HEADER_ID
964 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
965 and (SUBB.WAVE_NAME <> SUBT.WAVE_NAME
966 or (SUBB.WAVE_NAME is null and SUBT.WAVE_NAME is not null)
967 or (SUBB.WAVE_NAME is not null and SUBT.WAVE_NAME is null)
968 or SUBB.WAVE_DESCRIPTION <> SUBT.WAVE_DESCRIPTION
969 or (SUBB.WAVE_DESCRIPTION is null and SUBT.WAVE_DESCRIPTION is not null)
970 or (SUBB.WAVE_DESCRIPTION is not null and SUBT.WAVE_DESCRIPTION is null)
971 ));
972
973 insert into WMS_WP_WAVE_HEADERS_TL (
974 WAVE_HEADER_ID,
975 WAVE_NAME,
976 WAVE_DESCRIPTION,
977 CREATED_BY,
978 CREATION_DATE,
979 LAST_UPDATED_BY,
980 LAST_UPDATE_DATE,
981 LAST_UPDATE_LOGIN,
982 LANGUAGE,
983 SOURCE_LANG
984 ) select /*+ ORDERED */
985 B.WAVE_HEADER_ID,
986 B.WAVE_NAME,
987 B.WAVE_DESCRIPTION,
988 B.CREATED_BY,
989 B.CREATION_DATE,
990 B.LAST_UPDATED_BY,
991 B.LAST_UPDATE_DATE,
992 B.LAST_UPDATE_LOGIN,
993 L.LANGUAGE_CODE,
994 B.SOURCE_LANG
995 from WMS_WP_WAVE_HEADERS_TL B, FND_LANGUAGES L
996 where L.INSTALLED_FLAG in ('I', 'B')
997 and B.LANGUAGE = userenv('LANG')
998 and not exists
999 (select NULL
1000 from WMS_WP_WAVE_HEADERS_TL T
1001 where T.WAVE_HEADER_ID = B.WAVE_HEADER_ID
1002 and T.LANGUAGE = L.LANGUAGE_CODE);
1003 end ADD_LANGUAGE;
1004
1005 end WMS_WP_WAVE_HEADERS_PKG;
[Home] [Help]