[Home] [Help]
PACKAGE BODY: APPS.WSH_DELIVERY_TEMPLATE_ROWS
Source
1 package body wsh_delivery_template_rows as
2 /* $Header: WSHTDELB.pls 115.1 99/07/16 08:22:07 porting shi $ */
3
4
5 -- ===========================================================================
6 --
7 -- Name:
8 --
9 -- insert_row
10 --
11 -- Description:
12 --
13 -- Called by the client to insert a row into the
14 -- WSH_DELIVERY_TEMPLATES table.
15 --
16 -- ===========================================================================
17
18 procedure insert_row(
19 X_rowid in out varchar2,
20 X_delivery_template_id in out number,
21 X_name varchar2,
22 X_organization_id number,
23 X_planned_dep_template_id number,
24 X_loading_order_flag varchar2,
25 X_sequence_number number,
26 X_customer_id number,
27 X_ultimate_ship_to_id number,
28 X_intermediate_ship_to_id number,
29 X_pooled_ship_to_id number,
30 X_weight_uom_code varchar2,
31 X_volume_uom_code varchar2,
32 X_expected_arrival_day_offset number,
33 X_expected_arrival_hour_offset number,
34 X_expected_arrival_min_offset number,
35 X_planned_frequency varchar2,
36 X_planned_day varchar2,
37 X_planned_time number,
38 X_attribute_category varchar2,
39 X_attribute1 varchar2,
40 X_attribute2 varchar2,
41 X_attribute3 varchar2,
42 X_attribute4 varchar2,
43 X_attribute5 varchar2,
44 X_attribute6 varchar2,
45 X_attribute7 varchar2,
46 X_attribute8 varchar2,
47 X_attribute9 varchar2,
48 X_attribute10 varchar2,
49 X_attribute11 varchar2,
50 X_attribute12 varchar2,
51 X_attribute13 varchar2,
52 X_attribute14 varchar2,
53 X_attribute15 varchar2,
54 X_global_attribute_category varchar2 default null,
55 X_global_attribute1 varchar2 default null,
56 X_global_attribute2 varchar2 default null,
57 X_global_attribute3 varchar2 default null,
58 X_global_attribute4 varchar2 default null,
59 X_global_attribute5 varchar2 default null,
60 X_global_attribute6 varchar2 default null,
61 X_global_attribute7 varchar2 default null,
62 X_global_attribute8 varchar2 default null,
63 X_global_attribute9 varchar2 default null,
64 X_global_attribute10 varchar2 default null,
65 X_global_attribute11 varchar2 default null,
66 X_global_attribute12 varchar2 default null,
67 X_global_attribute13 varchar2 default null,
68 X_global_attribute14 varchar2 default null,
69 X_global_attribute15 varchar2 default null,
70 X_global_attribute16 varchar2 default null,
71 X_global_attribute17 varchar2 default null,
72 X_global_attribute18 varchar2 default null,
73 X_global_attribute19 varchar2 default null,
74 X_global_attribute20 varchar2 default null,
75 X_creation_date date,
76 X_created_by number,
77 X_last_update_date date,
78 X_last_updated_by number,
79 X_last_update_login number)
80 is
81
82 X_dummy varchar2(18);
83
84 cursor id_sequence is
85 select wsh_delivery_templates_s.nextval
86 from sys.dual;
87
88 cursor row_id is
89 select rowid
90 from wsh_delivery_templates
91 where delivery_template_id = X_delivery_template_id;
92
93 begin
94
95 if (X_planned_dep_template_id is not null) then
96 select rowid
97 into X_dummy
98 from wsh_departure_templates
99 where departure_template_id = X_planned_dep_template_id
100 for update nowait;
101 end if;
102
103 open id_sequence;
104 fetch id_sequence into X_delivery_template_id;
105 close id_sequence;
106
107 insert into wsh_delivery_templates(
108
109 delivery_template_id,
110 name,
111 organization_id,
112 planned_dep_template_id,
113 loading_order_flag,
114 sequence_number,
115 customer_id,
116 ultimate_ship_to_id,
117 intermediate_ship_to_id,
118 pooled_ship_to_id,
119 weight_uom_code,
120 volume_uom_code,
121 expected_arrival_day_offset,
122 expected_arrival_hour_offset,
123 expected_arrival_min_offset,
124 planned_frequency,
125 planned_day,
126 planned_time,
127 attribute_category,
128 attribute1,
129 attribute2,
130 attribute3,
131 attribute4,
132 attribute5,
133 attribute6,
134 attribute7,
135 attribute8,
136 attribute9,
137 attribute10,
138 attribute11,
139 attribute12,
140 attribute13,
141 attribute14,
142 attribute15,
143 creation_date,
144 created_by,
145 last_update_date,
146 last_updated_by,
147 last_update_login)
148
149 values(
150
151 X_delivery_template_id,
152 X_name,
153 X_organization_id,
154 X_planned_dep_template_id,
155 X_loading_order_flag,
156 X_sequence_number,
157 X_customer_id,
158 X_ultimate_ship_to_id,
159 X_intermediate_ship_to_id,
160 X_pooled_ship_to_id,
161 X_weight_uom_code,
162 X_volume_uom_code,
163 X_expected_arrival_day_offset,
164 X_expected_arrival_hour_offset,
165 X_expected_arrival_min_offset,
166 X_planned_frequency,
167 X_planned_day,
168 X_planned_time,
169 X_attribute_category,
170 X_attribute1,
171 X_attribute2,
172 X_attribute3,
173 X_attribute4,
174 X_attribute5,
175 X_attribute6,
176 X_attribute7,
177 X_attribute8,
178 X_attribute9,
179 X_attribute10,
180 X_attribute11,
181 X_attribute12,
182 X_attribute13,
183 X_attribute14,
184 X_attribute15,
185 X_creation_date,
186 X_created_by,
187 X_last_update_date,
188 X_last_updated_by,
189 X_last_update_login
190 );
191
192 open row_id;
193
194 fetch row_id into X_rowid;
195
196 if (row_id%NOTFOUND) then
197 close row_id;
198 raise NO_DATA_FOUND;
199 end if;
200
201 close row_id;
202
203 exception
204 when DUP_VAL_ON_INDEX then
205 fnd_message.set_name('OE', 'WSH_TMPL_DUP_VAL');
206 app_exception.raise_exception;
207
208 when app_exception.record_lock_exception then
209 fnd_message.set_name('OE', 'WSH_NO_LOCK');
210 app_exception.raise_exception;
211
212 end insert_row;
213
214
215 -- ===========================================================================
216 --
217 -- Name:
218 --
219 -- lock_row
220 --
221 -- Description:
222 --
223 -- Called by the client to lock a row into the
224 -- WSH_DELIVERY_TEMPLATES table.
225 --
226 -- ===========================================================================
227
228 procedure lock_row(
229 X_rowid varchar2,
230 X_delivery_template_id number,
231 X_name varchar2,
232 X_organization_id number,
233 X_planned_dep_template_id number,
234 X_loading_order_flag varchar2,
235 X_sequence_number number,
236 X_customer_id number,
237 X_ultimate_ship_to_id number,
238 X_intermediate_ship_to_id number,
239 X_pooled_ship_to_id number,
240 X_weight_uom_code varchar2,
241 X_volume_uom_code varchar2,
242 X_expected_arrival_day_offset number,
243 X_expected_arrival_hour_offset number,
244 X_expected_arrival_min_offset number,
245 X_planned_frequency varchar2,
246 X_planned_day varchar2,
247 X_planned_time number,
248 X_attribute_category varchar2,
249 X_attribute1 varchar2,
250 X_attribute2 varchar2,
251 X_attribute3 varchar2,
252 X_attribute4 varchar2,
253 X_attribute5 varchar2,
254 X_attribute6 varchar2,
255 X_attribute7 varchar2,
256 X_attribute8 varchar2,
257 X_attribute9 varchar2,
258 X_attribute10 varchar2,
259 X_attribute11 varchar2,
260 X_attribute12 varchar2,
261 X_attribute13 varchar2,
262 X_attribute14 varchar2,
263 X_attribute15 varchar2,
264 X_global_attribute_category varchar2 default null,
265 X_global_attribute1 varchar2 default null,
266 X_global_attribute2 varchar2 default null,
267 X_global_attribute3 varchar2 default null,
268 X_global_attribute4 varchar2 default null,
269 X_global_attribute5 varchar2 default null,
270 X_global_attribute6 varchar2 default null,
271 X_global_attribute7 varchar2 default null,
272 X_global_attribute8 varchar2 default null,
273 X_global_attribute9 varchar2 default null,
274 X_global_attribute10 varchar2 default null,
275 X_global_attribute11 varchar2 default null,
276 X_global_attribute12 varchar2 default null,
277 X_global_attribute13 varchar2 default null,
278 X_global_attribute14 varchar2 default null,
279 X_global_attribute15 varchar2 default null,
280 X_global_attribute16 varchar2 default null,
281 X_global_attribute17 varchar2 default null,
282 X_global_attribute18 varchar2 default null,
283 X_global_attribute19 varchar2 default null,
284 X_global_attribute20 varchar2 default null
285 )
286 is
287
288 cursor lock_record is
289 select *
290 from wsh_delivery_templates
291 where rowid = X_rowid
292 for update nowait;
293
294 rec_info lock_record%ROWTYPE;
295
296 begin
297
298 open lock_record;
299
300 fetch lock_record into rec_info;
301
302 if (lock_record%NOTFOUND) then
303 close lock_record;
304
305 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
306 app_exception.raise_exception;
307
308 end if;
309
310 close lock_record;
311
312 if (
313 (rec_info.delivery_template_id = X_delivery_template_id)
314 and
315 (rec_info.name = X_name)
316 and
317 (rec_info.organization_id = X_organization_id)
318 and
319 ((rec_info.planned_dep_template_id = X_planned_dep_template_id)
320 or
321 ((rec_info.planned_dep_template_id is null)
322 and (X_planned_dep_template_id is null)))
323 and
324 ((rec_info.loading_order_flag = X_loading_order_flag)
325 or
326 ((rec_info.loading_order_flag is null)
327 and (X_loading_order_flag is null)))
328 and
329 ((rec_info.sequence_number = X_sequence_number)
330 or
331 ((rec_info.sequence_number is null)
332 and (X_sequence_number is null)))
333 and
334 (rec_info.customer_id = X_customer_id)
335 and
336 (rec_info.ultimate_ship_to_id = X_ultimate_ship_to_id)
337 and
338 ((rec_info.intermediate_ship_to_id = X_intermediate_ship_to_id)
339 or
340 ((rec_info.intermediate_ship_to_id is null)
341 and (X_intermediate_ship_to_id is null)))
342 and
343 ((rec_info.pooled_ship_to_id = X_pooled_ship_to_id)
344 or
345 ((rec_info.pooled_ship_to_id is null)
346 and (X_pooled_ship_to_id is null)))
347 and
348 ((rec_info.weight_uom_code = X_weight_uom_code)
349 or
350 ((rec_info.weight_uom_code is null)
351 and (X_weight_uom_code is null)))
352 and
353 ((rec_info.volume_uom_code = X_volume_uom_code)
354 or
355 ((rec_info.volume_uom_code is null)
356 and (X_volume_uom_code is null)))
357 and
358 ((rec_info.expected_arrival_day_offset = X_expected_arrival_day_offset)
359 or
360 ((rec_info.expected_arrival_day_offset is null)
361 and (X_expected_arrival_day_offset is null)))
362 and
363 ((rec_info.expected_arrival_hour_offset = X_expected_arrival_hour_offset)
364 or
365 ((rec_info.expected_arrival_hour_offset is null)
366 and (X_expected_arrival_hour_offset is null)))
367 and
368 ((rec_info.expected_arrival_min_offset = X_expected_arrival_min_offset)
369 or
370 ((rec_info.expected_arrival_min_offset is null)
371 and (X_expected_arrival_min_offset is null)))
372 and
373 ((rec_info.planned_frequency = X_planned_frequency)
374 or
375 ((rec_info.planned_frequency is null)
376 and (X_planned_frequency is null)))
377 and
378 ((rec_info.planned_day = X_planned_day)
379 or
380 ((rec_info.planned_day is null)
381 and (X_planned_day is null)))
382 and
383 ((rec_info.planned_time = X_planned_time)
384 or
385 ((rec_info.planned_time is null)
386 and (X_planned_time is null)))
387 and
388 ((rec_info.attribute_category = X_attribute_category)
389 or
390 ((rec_info.attribute_category is null)
391 and (X_attribute_category is null)))
392 and
393 ((rec_info.attribute1 = X_attribute1)
394 or
395 ((rec_info.attribute1 is null)
396 and (X_attribute1 is null)))
397 and
398 ((rec_info.attribute2 = X_attribute2)
399 or
400 ((rec_info.attribute2 is null)
401 and (X_attribute2 is null)))
402 and
403 ((rec_info.attribute3 = X_attribute3)
404 or
405 ((rec_info.attribute3 is null)
406 and (X_attribute3 is null)))
407 and
408 ((rec_info.attribute4 = X_attribute4)
409 or
410 ((rec_info.attribute4 is null)
411 and (X_attribute4 is null)))
412 and
413 ((rec_info.attribute5 = X_attribute5)
414 or
415 ((rec_info.attribute5 is null)
416 and (X_attribute5 is null)))
417 and
418 ((rec_info.attribute6 = X_attribute6)
419 or
420 ((rec_info.attribute6 is null)
421 and (X_attribute6 is null)))
422 and
423 ((rec_info.attribute7 = X_attribute7)
424 or
425 ((rec_info.attribute7 is null)
426 and (X_attribute7 is null)))
427 and
428 ((rec_info.attribute8 = X_attribute8)
429 or
433 ((rec_info.attribute9 = X_attribute9)
430 ((rec_info.attribute8 is null)
431 and (X_attribute8 is null)))
432 and
434 or
435 ((rec_info.attribute9 is null)
436 and (X_attribute9 is null)))
437 and
438 ((rec_info.attribute10 = X_attribute10)
439 or
440 ((rec_info.attribute10 is null)
441 and (X_attribute10 is null)))
442 and
443 ((rec_info.attribute11 = X_attribute11)
444 or
445 ((rec_info.attribute11 is null)
446 and (X_attribute11 is null)))
447 and
448 ((rec_info.attribute12 = X_attribute12)
449 or
450 ((rec_info.attribute12 is null)
451 and (X_attribute12 is null)))
452 and
453 ((rec_info.attribute13 = X_attribute13)
454 or
455 ((rec_info.attribute13 is null)
456 and (X_attribute13 is null)))
457 and
458 ((rec_info.attribute14 = X_attribute14)
459 or
460 ((rec_info.attribute14 is null)
461 and (X_attribute14 is null)))
462 and
463 ((rec_info.attribute15 = X_attribute15)
464 or
465 ((rec_info.attribute15 is null)
466 and (X_attribute15 is null)))
467 and
468 ((rec_info.global_attribute_category = X_global_attribute_category)
469 or
470 ((rec_info.global_attribute_category is null)
471 and (X_global_attribute_category is null)))
472 and
473 ((rec_info.global_attribute1 = X_global_attribute1)
474 or
475 ((rec_info.global_attribute1 is null)
476 and (X_global_attribute1 is null)))
477 and
478 ((rec_info.global_attribute2 = X_global_attribute2)
479 or
480 ((rec_info.global_attribute2 is null)
481 and (X_global_attribute2 is null)))
482 and
483 ((rec_info.global_attribute3 = X_global_attribute3)
484 or
485 ((rec_info.global_attribute3 is null)
486 and (X_global_attribute3 is null)))
487 and
488 ((rec_info.global_attribute4 = X_global_attribute4)
489 or
490 ((rec_info.global_attribute4 is null)
491 and (X_global_attribute4 is null)))
492 and
493 ((rec_info.global_attribute5 = X_global_attribute5)
494 or
495 ((rec_info.global_attribute5 is null)
496 and (X_global_attribute5 is null)))
497 and
498 ((rec_info.global_attribute6 = X_global_attribute6)
499 or
500 ((rec_info.global_attribute6 is null)
501 and (X_global_attribute6 is null)))
502 and
503 ((rec_info.global_attribute7 = X_global_attribute7)
504 or
505 ((rec_info.global_attribute7 is null)
506 and (X_global_attribute7 is null)))
507 and
508 ((rec_info.global_attribute8 = X_global_attribute8)
509 or
510 ((rec_info.global_attribute8 is null)
511 and (X_global_attribute8 is null)))
512 and
513 ((rec_info.global_attribute9 = X_global_attribute9)
514 or
515 ((rec_info.global_attribute9 is null)
516 and (X_global_attribute9 is null)))
517 and
518 ((rec_info.global_attribute10 = X_global_attribute10)
519 or
520 ((rec_info.global_attribute10 is null)
521 and (X_global_attribute10 is null)))
522 and
523 ((rec_info.global_attribute11 = X_global_attribute11)
524 or
525 ((rec_info.global_attribute11 is null)
526 and (X_global_attribute11 is null)))
527 and
528 ((rec_info.global_attribute12 = X_global_attribute12)
529 or
530 ((rec_info.global_attribute12 is null)
531 and (X_global_attribute12 is null)))
532 and
533 ((rec_info.global_attribute13 = X_global_attribute13)
534 or
535 ((rec_info.global_attribute13 is null)
536 and (X_global_attribute13 is null)))
537 and
538 ((rec_info.global_attribute14 = X_global_attribute14)
539 or
540 ((rec_info.global_attribute14 is null)
541 and (X_global_attribute14 is null)))
542 and
543 ((rec_info.global_attribute15 = X_global_attribute15)
544 or
545 ((rec_info.global_attribute15 is null)
546 and (X_global_attribute15 is null)))
547 and
548 ((rec_info.global_attribute16 = X_global_attribute16)
549 or
550 ((rec_info.global_attribute16 is null)
551 and (X_global_attribute16 is null)))
552 and
553 ((rec_info.global_attribute17 = X_global_attribute17)
554 or
555 ((rec_info.global_attribute17 is null)
556 and (X_global_attribute17 is null)))
557 and
558 ((rec_info.global_attribute18 = X_global_attribute18)
559 or
560 ((rec_info.global_attribute18 is null)
561 and (X_global_attribute18 is null)))
562 and
563 ((rec_info.global_attribute19 = X_global_attribute19)
564 or
565 ((rec_info.global_attribute19 is null)
566 and (X_global_attribute19 is null)))
567 and
568 ((rec_info.global_attribute20 = X_global_attribute20)
569 or
570 ((rec_info.global_attribute20 is null)
571 and (X_global_attribute20 is null)))
572 ) then
573
574 return;
575
576 else
577
578 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
579 app_exception.raise_exception;
580
581 end if;
582
583 end lock_row;
584
585
586 -- ===========================================================================
587 --
588 -- Name:
589 --
590 -- update_row
591 --
592 -- Description:
593 --
594 -- Called by the client to update a row into the
595 -- WSH_DELIVERY_TEMPLATES table.
596 --
597 -- ===========================================================================
598
599 procedure update_row(
600 X_rowid varchar2,
601 X_delivery_template_id number,
605 X_loading_order_flag varchar2,
602 X_name varchar2,
603 X_organization_id number,
604 X_planned_dep_template_id number,
606 X_sequence_number number,
607 X_customer_id number,
608 X_ultimate_ship_to_id number,
609 X_intermediate_ship_to_id number,
610 X_pooled_ship_to_id number,
611 X_weight_uom_code varchar2,
612 X_volume_uom_code varchar2,
613 X_expected_arrival_day_offset number,
614 X_expected_arrival_hour_offset number,
615 X_expected_arrival_min_offset number,
616 X_planned_frequency varchar2,
617 X_planned_day varchar2,
618 X_planned_time number,
619 X_attribute_category varchar2,
620 X_attribute1 varchar2,
621 X_attribute2 varchar2,
622 X_attribute3 varchar2,
623 X_attribute4 varchar2,
624 X_attribute5 varchar2,
625 X_attribute6 varchar2,
626 X_attribute7 varchar2,
627 X_attribute8 varchar2,
628 X_attribute9 varchar2,
629 X_attribute10 varchar2,
630 X_attribute11 varchar2,
631 X_attribute12 varchar2,
632 X_attribute13 varchar2,
633 X_attribute14 varchar2,
634 X_attribute15 varchar2,
635 X_global_attribute_category varchar2 default null,
636 X_global_attribute1 varchar2 default null,
637 X_global_attribute2 varchar2 default null,
638 X_global_attribute3 varchar2 default null,
639 X_global_attribute4 varchar2 default null,
640 X_global_attribute5 varchar2 default null,
641 X_global_attribute6 varchar2 default null,
642 X_global_attribute7 varchar2 default null,
643 X_global_attribute8 varchar2 default null,
644 X_global_attribute9 varchar2 default null,
645 X_global_attribute10 varchar2 default null,
646 X_global_attribute11 varchar2 default null,
647 X_global_attribute12 varchar2 default null,
648 X_global_attribute13 varchar2 default null,
649 X_global_attribute14 varchar2 default null,
650 X_global_attribute15 varchar2 default null,
651 X_global_attribute16 varchar2 default null,
652 X_global_attribute17 varchar2 default null,
653 X_global_attribute18 varchar2 default null,
654 X_global_attribute19 varchar2 default null,
655 X_global_attribute20 varchar2 default null,
656 X_last_update_date date,
657 X_last_updated_by number,
658 X_last_update_login number)
659 is
660 X_dummy varchar2(18);
661 begin
662
663 if (X_planned_dep_template_id is not null) then
664 select rowid
665 into X_dummy
666 from wsh_departure_templates
667 where departure_template_id = X_planned_dep_template_id
668 for update nowait;
669 end if;
670
671 update wsh_delivery_templates set
672
673 delivery_template_id = X_delivery_template_id,
674 name = X_name,
675 organization_id = X_organization_id,
676 planned_dep_template_id = X_planned_dep_template_id,
677 loading_order_flag = X_loading_order_flag,
678 sequence_number = X_sequence_number,
679 customer_id = X_customer_id,
680 ultimate_ship_to_id = X_ultimate_ship_to_id,
681 intermediate_ship_to_id = X_intermediate_ship_to_id,
682 pooled_ship_to_id = X_pooled_ship_to_id,
683 weight_uom_code = X_weight_uom_code,
684 volume_uom_code = X_volume_uom_code,
685 expected_arrival_day_offset = X_expected_arrival_day_offset,
686 expected_arrival_hour_offset = X_expected_arrival_hour_offset,
687 expected_arrival_min_offset = X_expected_arrival_min_offset,
688 planned_frequency = X_planned_frequency,
689 planned_day = X_planned_day,
690 planned_time = X_planned_time,
691 attribute_category = X_attribute_category,
692 attribute1 = X_attribute1,
693 attribute2 = X_attribute2,
694 attribute3 = X_attribute3,
695 attribute4 = X_attribute4,
696 attribute5 = X_attribute5,
697 attribute6 = X_attribute6,
698 attribute7 = X_attribute7,
699 attribute8 = X_attribute8,
700 attribute9 = X_attribute9,
701 attribute10 = X_attribute10,
702 attribute11 = X_attribute11,
703 attribute12 = X_attribute12,
704 attribute13 = X_attribute13,
705 attribute14 = X_attribute14,
706 attribute15 = X_attribute15,
707 global_attribute_category = X_global_attribute_category,
708 global_attribute1 = X_global_attribute1,
709 global_attribute2 = X_global_attribute2,
710 global_attribute3 = X_global_attribute3,
711 global_attribute4 = X_global_attribute4,
712 global_attribute5 = X_global_attribute5,
713 global_attribute6 = X_global_attribute6,
714 global_attribute7 = X_global_attribute7,
718 global_attribute11 = X_global_attribute11,
715 global_attribute8 = X_global_attribute8,
716 global_attribute9 = X_global_attribute9,
717 global_attribute10 = X_global_attribute10,
719 global_attribute12 = X_global_attribute12,
720 global_attribute13 = X_global_attribute13,
721 global_attribute14 = X_global_attribute14,
722 global_attribute15 = X_global_attribute15,
723 global_attribute16 = X_global_attribute16,
724 global_attribute17 = X_global_attribute17,
725 global_attribute18 = X_global_attribute18,
726 global_attribute19 = X_global_attribute19,
727 global_attribute20 = X_global_attribute20,
728 last_update_date = X_last_update_date,
729 last_updated_by = X_last_updated_by,
730 last_update_login = X_last_update_login
731
732 where rowid = X_rowid;
733
734 if (SQL%NOTFOUND) then
735 raise NO_DATA_FOUND;
736 end if;
737
738 exception
739 when DUP_VAL_ON_INDEX then
740 fnd_message.set_name('OE', 'WSH_TMPL_DUP_VAL');
741 app_exception.raise_exception;
742
743 when app_exception.record_lock_exception then
744 fnd_message.set_name('OE', 'WSH_NO_LOCK');
745 app_exception.raise_exception;
746
747 end update_row;
748
749
750 -- ===========================================================================
751 --
752 -- Name:
753 --
754 -- delete_row
755 --
756 -- Description:
757 --
758 -- Called by the client to delete a row into the
759 -- WSH_DELIVERY_TEMPLATES table.
760 --
761 -- ===========================================================================
762
763 procedure delete_row(X_rowid varchar2)
764 is
765 begin
766
767 delete from wsh_delivery_templates
768 where rowid = X_rowid;
769
770 if (SQL%NOTFOUND) then
771 raise NO_DATA_FOUND;
772 end if;
773
774 end delete_row;
775
776
777 end wsh_delivery_template_rows;