[Home] [Help]
PACKAGE BODY: APPS.WMS_RESTRICTIONS_PKG
Source
1 PACKAGE BODY WMS_RESTRICTIONS_PKG AS
2 /* $Header: WMSHPREB.pls 120.1 2005/06/21 02:18:42 appldev ship $ */
3
4 PROCEDURE INSERT_ROW (
5 x_rowid IN OUT NOCOPY VARCHAR2
6 ,x_rule_id IN NUMBER
7 ,x_sequence_number IN NUMBER
8 ,x_last_updated_by IN NUMBER
9 ,x_last_update_date IN DATE
10 ,x_created_by IN NUMBER
11 ,x_creation_date IN DATE
12 ,x_last_update_login IN NUMBER
13 ,x_parameter_id IN NUMBER
14 ,x_operator_code IN NUMBER
15 ,x_operand_type_code IN NUMBER
16 ,x_operand_constant_number IN NUMBER
17 ,x_operand_constant_character IN VARCHAR2
18 ,x_operand_constant_date IN DATE
19 ,x_operand_parameter_id IN NUMBER
20 ,x_operand_expression IN VARCHAR2
21 ,x_operand_flex_value_set_id IN NUMBER
22 ,x_logical_operator_code IN NUMBER
23 ,x_bracket_open IN VARCHAR2
24 ,x_bracket_close IN VARCHAR2
25 ,x_attribute_category IN VARCHAR2
26 ,x_attribute1 IN VARCHAR2
27 ,x_attribute2 IN VARCHAR2
28 ,x_attribute3 IN VARCHAR2
29 ,x_attribute4 IN VARCHAR2
30 ,x_attribute5 IN VARCHAR2
31 ,x_attribute6 IN VARCHAR2
32 ,x_attribute7 IN VARCHAR2
33 ,x_attribute8 IN VARCHAR2
34 ,x_attribute9 IN VARCHAR2
35 ,x_attribute10 IN VARCHAR2
36 ,x_attribute11 IN VARCHAR2
37 ,x_attribute12 IN VARCHAR2
38 ,x_attribute13 IN VARCHAR2
39 ,x_attribute14 IN VARCHAR2
40 ,x_attribute15 IN VARCHAR2
41 )IS
42 CURSOR C IS SELECT ROWID FROM WMS_RESTRICTIONS
43 WHERE rule_id = x_rule_id
44 AND sequence_number = x_sequence_number;
45 BEGIN
46
47 INSERT INTO WMS_RESTRICTIONS (
48 rule_id
49 ,sequence_number
50 ,last_updated_by
51 ,last_update_date
52 ,created_by
53 ,creation_date
54 ,last_update_login
55 ,parameter_id
56 ,operator_code
57 ,operand_type_code
58 ,operand_constant_number
59 ,operand_constant_character
60 ,operand_constant_date
61 ,operand_parameter_id
62 ,operand_expression
63 ,operand_flex_value_set_id
64 ,logical_operator_code
65 ,bracket_open
66 ,bracket_close
67 ,attribute_category
68 ,attribute1
69 ,attribute2
70 ,attribute3
71 ,attribute4
72 ,attribute5
73 ,attribute6
74 ,attribute7
75 ,attribute8
76 ,attribute9
77 ,attribute10
78 ,attribute11
79 ,attribute12
80 ,attribute13
81 ,attribute14
82 ,attribute15
83 ) values (
84 x_rule_id
85 ,x_sequence_number
86 ,x_last_updated_by
87 ,x_last_update_date
88 ,x_created_by
89 ,x_creation_date
90 ,x_last_update_login
91 ,x_parameter_id
92 ,x_operator_code
93 ,x_operand_type_code
94 ,x_operand_constant_number
95 ,x_operand_constant_character
96 ,x_operand_constant_date
97 ,x_operand_parameter_id
98 ,x_operand_expression
99 ,x_operand_flex_value_set_id
100 ,x_logical_operator_code
101 ,x_bracket_open
102 ,x_bracket_close
103 ,x_attribute_category
104 ,x_attribute1
105 ,x_attribute2
106 ,x_attribute3
107 ,x_attribute4
108 ,x_attribute5
109 ,x_attribute6
110 ,x_attribute7
111 ,x_attribute8
112 ,x_attribute9
113 ,x_attribute10
114 ,x_attribute11
115 ,x_attribute12
116 ,x_attribute13
117 ,x_attribute14
118 ,x_attribute15
119 );
120
121 OPEN C;
122 FETCH C INTO x_rowid;
123 IF (C%NOTFOUND) THEN
124 CLOSE C;
125 RAISE NO_DATA_FOUND;
126 END IF;
127 CLOSE C;
128 END INSERT_ROW;
129
130 PROCEDURE LOCK_ROW (
131 x_rowid IN VARCHAR2
132 ,x_rule_id IN NUMBER
133 ,x_sequence_number IN NUMBER
134 ,x_parameter_id IN NUMBER
135 ,x_operator_code IN NUMBER
136 ,x_operand_type_code IN NUMBER
137 ,x_operand_constant_number IN NUMBER
138 ,x_operand_constant_character IN VARCHAR2
139 ,x_operand_constant_date IN DATE
140 ,x_operand_parameter_id IN NUMBER
141 ,x_operand_expression IN VARCHAR2
142 ,x_operand_flex_value_set_id IN NUMBER
143 ,x_logical_operator_code IN NUMBER
144 ,x_bracket_open IN VARCHAR2
145 ,x_bracket_close IN VARCHAR2
146 ,x_attribute_category IN VARCHAR2
147 ,x_attribute1 IN VARCHAR2
148 ,x_attribute2 IN VARCHAR2
149 ,x_attribute3 IN VARCHAR2
150 ,x_attribute4 IN VARCHAR2
151 ,x_attribute5 IN VARCHAR2
152 ,x_attribute6 IN VARCHAR2
153 ,x_attribute7 IN VARCHAR2
154 ,x_attribute8 IN VARCHAR2
155 ,x_attribute9 IN VARCHAR2
156 ,x_attribute10 IN VARCHAR2
157 ,x_attribute11 IN VARCHAR2
158 ,x_attribute12 IN VARCHAR2
159 ,x_attribute13 IN VARCHAR2
160 ,x_attribute14 IN VARCHAR2
161 ,x_attribute15 IN VARCHAR2
162 )IS
163 CURSOR C IS SELECT
164 rule_id
165 ,sequence_number
166 ,parameter_id
167 ,operator_code
168 ,operand_type_code
169 ,operand_constant_number
170 ,operand_constant_character
171 ,operand_constant_date
172 ,operand_parameter_id
173 ,operand_expression
174 ,operand_flex_value_set_id
175 ,logical_operator_code
176 ,bracket_open
177 ,bracket_close
178 ,attribute_category
179 ,attribute1
180 ,attribute2
181 ,attribute3
182 ,attribute4
183 ,attribute5
184 ,attribute6
185 ,attribute7
186 ,attribute8
187 ,attribute9
188 ,attribute10
189 ,attribute11
190 ,attribute12
191 ,attribute13
192 ,attribute14
193 ,attribute15
194 FROM WMS_RESTRICTIONS
195 WHERE rowid = x_rowid
196 FOR UPDATE OF rule_id NOWAIT;
197
198 recinfo c%ROWTYPE;
199 BEGIN
200 OPEN c;
201 FETCH c INTO recinfo;
202 IF (c%notfound) THEN
203 CLOSE c;
204 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
205 app_exception.raise_exception;
206 END IF;
207 CLOSE c;
208 IF ( (recinfo.rule_id = x_rule_id)
209 AND (recinfo.sequence_number = x_sequence_number)
210 AND (recinfo.parameter_id = x_parameter_id)
211 AND (recinfo.operator_code = x_operator_code)
212 AND (recinfo.operand_type_code = x_operand_type_code)
213 AND ((recinfo.operand_constant_number = x_operand_constant_number)
214 OR ((recinfo.operand_constant_number IS NULL)
215 AND (x_operand_constant_number IS NULL)))
216 AND ((recinfo.operand_constant_character = x_operand_constant_character)
217 OR ((recinfo.operand_constant_character IS NULL)
218 AND (x_operand_constant_character IS NULL)))
219 AND ((recinfo.operand_constant_date = x_operand_constant_date)
220 OR ((recinfo.operand_constant_date IS NULL)
221 AND (x_operand_constant_date IS NULL)))
222 AND ((recinfo.operand_parameter_id = x_operand_parameter_id)
223 OR ((recinfo.operand_parameter_id IS NULL)
224 AND (x_operand_parameter_id IS NULL)))
225 AND ((recinfo.operand_expression = x_operand_expression)
226 OR ((recinfo.operand_expression IS NULL)
227 AND (x_operand_expression IS NULL)))
228 AND ((recinfo.operand_flex_value_set_id = x_operand_flex_value_set_id)
229 OR ((recinfo.operand_flex_value_set_id IS NULL)
230 AND (x_operand_flex_value_set_id IS NULL)))
231 AND ((recinfo.logical_operator_code = x_logical_operator_code)
232 OR ((recinfo.logical_operator_code IS NULL)
233 AND (x_logical_operator_code IS NULL)))
234 AND ((recinfo.bracket_open = x_bracket_open)
235 OR ((recinfo.bracket_open IS NULL)
236 AND (x_bracket_open IS NULL)))
237 AND ((recinfo.bracket_close = x_bracket_close)
238 OR ((recinfo.bracket_close IS NULL)
239 AND (x_bracket_close IS NULL)))
240 AND ((recinfo.attribute_category = x_attribute_category)
241 OR ((recinfo.attribute_category IS NULL)
242 AND (x_attribute_category IS NULL)))
243 AND ((recinfo.attribute1 = x_attribute1)
244 OR ((recinfo.attribute1 IS NULL)
245 AND (x_attribute1 IS NULL)))
246 AND ((recinfo.attribute2 = x_attribute2)
247 OR ((recinfo.attribute2 IS NULL)
248 AND (x_attribute2 IS NULL)))
249 AND ((recinfo.attribute3 = x_attribute3)
250 OR ((recinfo.attribute3 IS NULL)
251 AND (x_attribute3 IS NULL)))
252 AND ((recinfo.attribute4 = x_attribute4)
253 OR ((recinfo.attribute4 IS NULL)
254 AND (x_attribute4 IS NULL)))
255 AND ((recinfo.attribute5 = x_attribute5)
256 OR ((recinfo.attribute5 IS NULL)
257 AND (x_attribute5 IS NULL)))
258 AND ((recinfo.attribute6 = x_attribute6)
259 OR ((recinfo.attribute6 IS NULL)
260 AND (x_attribute6 IS NULL)))
261 AND ((recinfo.attribute7 = x_attribute7)
262 OR ((recinfo.attribute7 IS NULL)
263 AND (x_attribute7 IS NULL)))
264 AND ((recinfo.attribute8 = x_attribute8)
265 OR ((recinfo.attribute8 IS NULL)
266 AND (x_attribute8 IS NULL)))
267 AND ((recinfo.attribute9 = x_attribute9)
268 OR ((recinfo.attribute9 IS NULL)
269 AND (x_attribute9 IS NULL)))
270 AND ((recinfo.attribute10 = x_attribute10)
271 OR ((recinfo.attribute10 IS NULL)
272 AND (x_attribute10 IS NULL)))
273 AND ((recinfo.attribute11 = x_attribute11)
274 OR ((recinfo.attribute11 IS NULL)
275 AND (x_attribute11 IS NULL)))
276 AND ((recinfo.attribute12 = x_attribute12)
277 OR ((recinfo.attribute12 IS NULL)
278 AND (x_attribute12 IS NULL)))
279 AND ((recinfo.attribute13 = x_attribute13)
280 OR ((recinfo.attribute13 IS NULL)
281 AND (x_attribute13 IS NULL)))
282 AND ((recinfo.attribute14 = x_attribute14)
283 OR ((recinfo.attribute14 IS NULL)
284 AND (x_attribute14 IS NULL)))
285 AND ((recinfo.attribute15 = x_attribute15)
286 OR ((recinfo.attribute15 IS NULL)
287 AND (x_attribute15 IS NULL)))
288
289 ) THEN
290 NULL;
291 ELSE
292 fnd_message.set_name('FND','FORM_RECORD_CHANGED');
293 app_exception.raise_exception;
294 END IF;
295 END LOCK_ROW;
296
297 PROCEDURE UPDATE_ROW (
298 x_rowid IN VARCHAR2
299 ,x_rule_id IN NUMBER
300 ,x_sequence_number IN NUMBER
301 ,x_last_updated_by IN NUMBER
302 ,x_last_update_date IN DATE
303 ,x_last_update_login IN NUMBER
304 ,x_parameter_id IN NUMBER
305 ,x_operator_code IN NUMBER
306 ,x_operand_type_code IN NUMBER
307 ,x_operand_constant_number IN NUMBER
308 ,x_operand_constant_character IN VARCHAR2
309 ,x_operand_constant_date IN DATE
310 ,x_operand_parameter_id IN NUMBER
311 ,x_operand_expression IN VARCHAR2
312 ,x_operand_flex_value_set_id IN NUMBER
313 ,x_logical_operator_code IN NUMBER
314 ,x_bracket_open IN VARCHAR2
315 ,x_bracket_close IN VARCHAR2
316 ,x_attribute_category IN VARCHAR2
317 ,x_attribute1 IN VARCHAR2
318 ,x_attribute2 IN VARCHAR2
319 ,x_attribute3 IN VARCHAR2
320 ,x_attribute4 IN VARCHAR2
321 ,x_attribute5 IN VARCHAR2
322 ,x_attribute6 IN VARCHAR2
323 ,x_attribute7 IN VARCHAR2
324 ,x_attribute8 IN VARCHAR2
325 ,x_attribute9 IN VARCHAR2
326 ,x_attribute10 IN VARCHAR2
327 ,x_attribute11 IN VARCHAR2
328 ,x_attribute12 IN VARCHAR2
329 ,x_attribute13 IN VARCHAR2
330 ,x_attribute14 IN VARCHAR2
331 ,x_attribute15 IN VARCHAR2
332 )IS
333 BEGIN
334 IF (x_rowid IS NOT NULL) THEN
335 UPDATE WMS_RESTRICTIONS SET
336 rule_id = x_rule_id
337 ,sequence_number = x_sequence_number
338 ,last_updated_by = x_last_updated_by
339 ,last_update_date = x_last_update_date
340 ,last_update_login = x_last_update_login
341 ,parameter_id = x_parameter_id
342 ,operator_code = x_operator_code
343 ,operand_type_code = x_operand_type_code
344 ,operand_constant_number = x_operand_constant_number
345 ,operand_constant_character = x_operand_constant_character
346 ,operand_constant_date = x_operand_constant_date
347 ,operand_parameter_id = x_operand_parameter_id
348 ,operand_expression = x_operand_expression
349 ,operand_flex_value_set_id = x_operand_flex_value_set_id
350 ,logical_operator_code = x_logical_operator_code
351 ,bracket_open = x_bracket_open
352 ,bracket_close = x_bracket_close
353 ,attribute_category = x_attribute_category
354 ,attribute1 = x_attribute1
355 ,attribute2 = x_attribute2
356 ,attribute3 = x_attribute3
357 ,attribute4 = x_attribute4
358 ,attribute5 = x_attribute5
359 ,attribute6 = x_attribute6
360 ,attribute7 = x_attribute7
361 ,attribute8 = x_attribute8
362 ,attribute9 = x_attribute9
363 ,attribute10 = x_attribute10
364 ,attribute11 = x_attribute11
365 ,attribute12 = x_attribute12
366 ,attribute13 = x_attribute13
367 ,attribute14 = x_attribute14
368 ,attribute15 = x_attribute15
369 WHERE rowid = x_rowid;
370 ELSE
371 UPDATE WMS_RESTRICTIONS SET
372 rule_id = x_rule_id
373 ,sequence_number = x_sequence_number
374 ,last_updated_by = x_last_updated_by
375 ,last_update_date = x_last_update_date
376 ,last_update_login = x_last_update_login
377 ,parameter_id = x_parameter_id
378 ,operator_code = x_operator_code
379 ,operand_type_code = x_operand_type_code
380 ,operand_constant_number = x_operand_constant_number
381 ,operand_constant_character = x_operand_constant_character
382 ,operand_constant_date = x_operand_constant_date
383 ,operand_parameter_id = x_operand_parameter_id
384 ,operand_expression = x_operand_expression
388 ,bracket_close = x_bracket_close
385 ,operand_flex_value_set_id = x_operand_flex_value_set_id
386 ,logical_operator_code = x_logical_operator_code
387 ,bracket_open = x_bracket_open
389 ,attribute_category = x_attribute_category
390 ,attribute1 = x_attribute1
391 ,attribute2 = x_attribute2
392 ,attribute3 = x_attribute3
393 ,attribute4 = x_attribute4
394 ,attribute5 = x_attribute5
395 ,attribute6 = x_attribute6
396 ,attribute7 = x_attribute7
397 ,attribute8 = x_attribute8
398 ,attribute9 = x_attribute9
399 ,attribute10 = x_attribute10
400 ,attribute11 = x_attribute11
401 ,attribute12 = x_attribute12
402 ,attribute13 = x_attribute13
403 ,attribute14 = x_attribute14
404 ,attribute15 = x_attribute15
405 WHERE rule_id = x_rule_id
406 AND sequence_number = x_sequence_number;
407 END IF;
408
409 IF (SQL%NOTFOUND) THEN
410 RAISE NO_DATA_FOUND;
411 END IF;
412 END UPDATE_ROW;
413
414 PROCEDURE DELETE_ROW (
415 x_rowid IN VARCHAR2
416 )IS
417 BEGIN
418
419 DELETE FROM WMS_RESTRICTIONS
420 WHERE rowid = x_rowid;
421
422 IF (SQL%NOTFOUND) THEN
423 RAISE NO_DATA_FOUND;
424 END IF;
425 END DELETE_ROW;
426
427 PROCEDURE LOAD_ROW (
428 X_RULE_ID IN VARCHAR2
429 ,x_OWNER IN VARCHAR2
430 ,X_SEQUENCE_NUMBER IN VARCHAR2
431 ,X_PARAMETER_ID IN VARCHAR2
432 ,X_OPERATOR_CODE IN VARCHAR2
433 ,X_OPERAND_TYPE_CODE IN VARCHAR2
434 ,X_OPERAND_CONSTANT_NUMBER IN VARCHAR2
435 ,X_OPERAND_CONSTANT_CHARACTER IN VARCHAR2
436 ,X_OPERAND_CONSTANT_DATE IN VARCHAR2
437 ,X_OPERAND_PARAMETER_ID IN VARCHAR2
438 ,X_OPERAND_EXPRESSION IN VARCHAR2
439 ,X_OPERAND_FLEX_VALUE_SET_ID IN VARCHAR2
440 ,X_LOGICAL_OPERATOR_CODE IN VARCHAR2
441 ,X_BRACKET_OPEN IN VARCHAR2
442 ,X_BRACKET_CLOSE IN VARCHAR2
443 ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
444 ,X_ATTRIBUTE1 IN VARCHAR2
445 ,X_ATTRIBUTE2 IN VARCHAR2
446 ,X_ATTRIBUTE3 IN VARCHAR2
447 ,X_ATTRIBUTE4 IN VARCHAR2
448 ,X_ATTRIBUTE5 IN VARCHAR2
449 ,X_ATTRIBUTE6 IN VARCHAR2
450 ,X_ATTRIBUTE7 IN VARCHAR2
451 ,X_ATTRIBUTE8 IN VARCHAR2
452 ,X_ATTRIBUTE9 IN VARCHAR2
453 ,X_ATTRIBUTE10 IN VARCHAR2
454 ,X_ATTRIBUTE11 IN VARCHAR2
455 ,X_ATTRIBUTE12 IN VARCHAR2
456 ,X_ATTRIBUTE13 IN VARCHAR2
457 ,X_ATTRIBUTE14 IN VARCHAR2
458 ,X_ATTRIBUTE15 IN VARCHAR2
459 ) IS
460 BEGIN
461 DECLARE
462 l_rule_id NUMBER;
463 l_sequence_number NUMBER;
464 l_parameter_id NUMBER;
465 l_operator_code NUMBER;
466 l_operator_type_code NUMBER;
467 l_operand_type_code NUMBER;
468 l_operand_constant_number NUMBER;
469 l_operand_parameter_id NUMBER;
470 l_operand_flex_value_set_id NUMBER;
471 l_logical_operator_code NUMBER;
472 l_operand_constant_date date;
473 l_user_id NUMBER := 0;
474 l_row_id VARCHAR2(64);
475 l_sysdate DATE;
476 l_date_type_from NUMBER := 0;
477 l_date_type_to NUMBER := 0;
478 BEGIN
479 IF (x_owner = 'SEED') THEN
480 l_user_id := 1;
481 END IF;
482 --
483 SELECT Sysdate INTO l_sysdate FROM dual;
484 l_rule_id := fnd_number.canonical_to_number(x_rule_id);
485 l_parameter_id := fnd_number.canonical_to_number(x_parameter_id );
486 l_sequence_number :=
487 fnd_number.canonical_to_number(x_sequence_number);
488 l_operator_code :=
489 fnd_number.canonical_to_number(x_operator_code );
490 l_operand_type_code :=
491 fnd_number.canonical_to_number(x_operand_type_code );
492 l_operand_constant_number :=
493 fnd_number.canonical_to_number(x_operand_constant_number );
494 l_operand_flex_value_set_id :=
495 fnd_number.canonical_to_number(x_operand_flex_value_set_id );
496 l_logical_operator_code :=
497 fnd_number.canonical_to_number(x_logical_operator_code );
498 l_operand_parameter_id :=
499 fnd_number.canonical_to_number(x_operand_parameter_id );
500
501 l_operand_constant_date := to_date(x_operand_constant_date, 'YYYY/MM/DD');
502
503 wms_restrictions_pkg.update_row
504 (
505 x_rowid => NULL
506 ,x_rule_id => l_rule_id
507 ,x_sequence_number => l_sequence_number
508 ,x_last_updated_by => l_user_id
509 ,x_last_update_date => l_sysdate
510 ,x_last_update_login => 0
511 ,x_parameter_id => l_parameter_id
512 ,x_operator_code => l_operator_code
513 ,x_operand_type_code => l_operand_type_code
514 ,x_operand_constant_number => l_operand_constant_number
515 ,x_operand_constant_character => x_operand_constant_character
516 ,x_operand_constant_date => x_operand_constant_date
517 ,x_operand_parameter_id => l_operand_parameter_id
518 ,x_operand_expression => x_operand_expression
519 ,x_operand_flex_value_set_id => l_operand_flex_value_set_id
520 ,x_logical_operator_code => l_logical_operator_code
521 ,x_bracket_open => x_bracket_open
522 ,x_bracket_close => x_bracket_close
523 ,x_attribute_category => x_attribute_category
524 ,x_attribute1 => x_attribute1
525 ,x_attribute2 => x_attribute2
526 ,x_attribute3 => x_attribute3
527 ,x_attribute4 => x_attribute4
528 ,x_attribute5 => x_attribute5
529 ,x_attribute6 => x_attribute6
530 ,x_attribute7 => x_attribute7
531 ,x_attribute8 => x_attribute8
532 ,x_attribute9 => x_attribute9
533 ,x_attribute10 => x_attribute10
534 ,x_attribute11 => x_attribute11
535 ,x_attribute12 => x_attribute12
536 ,x_attribute13 => x_attribute13
537 ,x_attribute14 => x_attribute14
538 ,x_attribute15 => x_attribute15
539 );
540 EXCEPTION
541 WHEN no_data_found THEN
542 wms_restrictions_pkg.insert_row
543 (
544 x_rowid => l_row_id
545 ,x_rule_id => l_rule_id
546 ,x_sequence_number => l_sequence_number
547 ,x_last_updated_by => l_user_id
548 ,x_last_update_date => l_sysdate
549 ,x_created_by => l_user_id
550 ,x_creation_date => l_sysdate
551 ,x_last_update_login => 0
552 ,x_parameter_id => l_parameter_id
553 ,x_operator_code => l_operator_code
554 ,x_operand_type_code => l_operand_type_code
555 ,x_operand_constant_number => l_operand_constant_number
556 ,x_operand_constant_character => x_operand_constant_character
557 ,x_operand_constant_date => x_operand_constant_date
558 ,x_operand_parameter_id => x_operand_parameter_id
559 ,x_operand_expression => x_operand_expression
560 ,x_operand_flex_value_set_id => l_operand_flex_value_set_id
561 ,x_logical_operator_code => l_logical_operator_code
562 ,x_bracket_open => x_bracket_open
563 ,x_bracket_close => x_bracket_close
564 ,x_attribute_category => x_attribute_category
565 ,x_attribute1 => x_attribute1
566 ,x_attribute2 => x_attribute2
567 ,x_attribute3 => x_attribute3
568 ,x_attribute4 => x_attribute4
569 ,x_attribute5 => x_attribute5
570 ,x_attribute6 => x_attribute6
571 ,x_attribute7 => x_attribute7
572 ,x_attribute8 => x_attribute8
573 ,x_attribute9 => x_attribute9
574 ,x_attribute10 => x_attribute10
575 ,x_attribute11 => x_attribute11
576 ,x_attribute12 => x_attribute12
577 ,x_attribute13 => x_attribute13
578 ,x_attribute14 => x_attribute14
579 ,x_attribute15 => x_attribute15
580 );
581 END;
582 END load_row;
583 END WMS_RESTRICTIONS_PKG;