[Home] [Help]
PACKAGE BODY: APPS.JTF_IH_WRAP_UPS_SEED_PUB
Source
1 PACKAGE BODY JTF_IH_WRAP_UPS_SEED_PUB AS
2 /* $Header: JTFIHWPB.pls 120.3 2006/04/27 07:41:57 rdday ship $ */
3
4
5 PROCEDURE insert_row(
6 x_rowid IN OUT NOCOPY VARCHAR2
7 , x_wrap_id NUMBER
8 , x_object_version_number NUMBER
9 , x_created_by NUMBER
10 , x_creation_date DATE
11 , x_last_updated_by NUMBER
12 , x_last_update_date DATE
13 , x_last_update_login NUMBER
14 , x_outcome_required VARCHAR2
15 , x_result_required VARCHAR2
16 , x_reason_required VARCHAR2
17 , x_result_id NUMBER
18 , x_reason_id NUMBER
19 , x_outcome_id NUMBER
20 , x_action_activity_id NUMBER
21 , x_object_id NUMBER
22 , x_object_type VARCHAR2
23 , x_source_code_id NUMBER
24 , x_source_code VARCHAR2
25 , x_start_date DATE
26 , x_end_date DATE
27 , x_wrap_up_level VARCHAR2
28 ) IS
29 CURSOR l_insert IS
30 SELECT ROWID
31 FROM jtf_ih_wrap_ups
32 WHERE wrap_id = x_wrap_id;
33 BEGIN
34 INSERT INTO jtf_ih_wrap_ups (
35 wrap_id
36 , object_version_number
37 , created_by
38 , creation_date
39 , last_updated_by
40 , last_update_date
41 , last_update_login
42 , outcome_required
43 , result_required
44 , reason_required
45 , result_id
46 , reason_id
47 , outcome_id
48 , action_activity_id
49 , object_id
50 , object_type
51 , source_code_id
52 , source_code
53 , start_date
54 , end_date
55 , wrap_up_level
56 ) VALUES (
57 x_wrap_id
58 , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59 , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60 , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61 , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62 , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63 , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64 , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65 , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66 , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67 , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68 , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69 , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70 , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71 , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72 , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73 , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74 , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75 , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76 , x_end_date
77 , DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)
78 );
79
80 OPEN l_insert;
81 FETCH l_insert INTO x_rowid;
82 IF (l_insert%NOTFOUND) THEN
83 CLOSE l_insert;
84 RAISE NO_DATA_FOUND;
85 END IF;
86 END insert_row;
87
88 PROCEDURE delete_row(
89 x_wrap_id NUMBER
90 ) IS
91 BEGIN
92 DELETE FROM jtf_ih_wrap_ups
93 WHERE wrap_id = x_wrap_id;
94 IF (SQL%NOTFOUND) THEN
95 RAISE NO_DATA_FOUND;
96 END IF;
97 END delete_row;
98
99 PROCEDURE update_row(
100 x_wrap_id NUMBER
101 , x_object_version_number NUMBER
102 , x_created_by NUMBER
103 , x_creation_date DATE
104 , x_last_updated_by NUMBER
105 , x_last_update_date DATE
106 , x_last_update_login NUMBER
107 , x_outcome_required VARCHAR2
108 , x_result_required VARCHAR2
109 , x_reason_required VARCHAR2
110 , x_result_id NUMBER
111 , x_reason_id NUMBER
112 , x_outcome_id NUMBER
113 , x_action_activity_id NUMBER
114 , x_object_id NUMBER
115 , x_object_type VARCHAR2
116 , x_source_code_id NUMBER
117 , x_source_code VARCHAR2
118 , x_start_date DATE
119 , x_end_date DATE
120 , x_wrap_up_level VARCHAR2
121 ) IS
122 CURSOR cWrapUps IS SELECT * FROM JTF_IH_WRAP_UPS WHERE WRAP_ID = x_wrap_id;
123 rWrapUPS cWrapUps%ROWTYPE;
124 l_wrap_id NUMBER;
125 l_object_version_number NUMBER;
126 l_created_by NUMBER;
127 l_creation_date DATE;
128 l_last_updated_by NUMBER;
129 l_last_update_date DATE;
130 l_last_update_login NUMBER;
131 l_outcome_required VARCHAR2(1);
132 l_result_required VARCHAR2(1);
133 l_reason_required VARCHAR2(1);
134 l_result_id NUMBER;
135 l_reason_id NUMBER;
136 l_outcome_id NUMBER;
137 l_action_activity_id NUMBER;
138 l_object_id NUMBER;
139 l_object_type VARCHAR2(30);
140 l_source_code_id NUMBER;
141 l_source_code VARCHAR2(100);
142 l_start_date DATE;
143 l_end_date DATE;
144 l_wrap_up_level VARCHAR2(30);
145
146 BEGIN
147 l_wrap_id := x_wrap_id;
148 l_object_version_number := x_object_version_number;
149 l_created_by := x_created_by;
150 l_creation_date := x_creation_date;
151 l_last_updated_by := x_last_updated_by;
152 l_last_update_date := x_last_update_date;
153 l_last_update_login := x_last_update_login;
154 l_outcome_required := x_outcome_required;
155 l_result_required := x_result_required;
156 l_reason_required := x_reason_required;
157 l_result_id := x_result_id;
158 l_reason_id := x_reason_id;
159 l_outcome_id := x_outcome_id;
160 l_action_activity_id := x_action_activity_id;
161 l_object_id := x_object_id;
162 l_object_type := x_object_type;
163 l_source_code_id := x_source_code_id;
164 l_source_code := x_source_code;
165 l_start_date := NVL(x_start_date,SYSDATE);
166 l_end_date := x_end_date;
167 l_wrap_up_level := x_wrap_up_level;
168
169 IF x_wrap_id IS NULL THEN
170 RAISE NO_DATA_FOUND;
171 END IF;
172
173 OPEN cWrapUps;
174 FETCH cWrapUps INTO rWrapUPS;
175 IF cWrapUps%NOTFOUND THEN
176 RAISE NO_DATA_FOUND;
177 END IF;
178
179 IF(l_object_version_number IS NULL) THEN
180 l_object_version_number := rWrapUPS.object_version_number;
181 END IF;
182 IF(l_created_by IS NULL) THEN
183 l_created_by := rWrapUPS.created_by;
184 END IF;
185 IF(l_last_updated_by IS NULL) THEN
186 l_last_updated_by := rWrapUPS.last_updated_by;
187 END IF;
188 IF(l_last_update_date IS NULL) THEN
189 l_last_update_date := sysdate;
190 END IF;
191 IF(l_last_update_login IS NULL) THEN
192 l_last_update_login := -1;
193 END IF;
194 IF(l_outcome_required IS NULL) THEN
195 l_outcome_required := rWrapUPS.outcome_required;
196 END IF;
197 IF(l_reason_required IS NULL) THEN
198 l_reason_required := rWrapUPS.reason_required;
199 END IF;
200 IF(l_result_required IS NULL) THEN
201 l_result_required := rWrapUPS.result_required;
202 END IF;
203 IF(l_result_id IS NULL) THEN
204 l_result_id := rWrapUPS.result_id;
205 END IF;
206 IF(l_reason_id IS NULL) THEN
207 l_reason_id := rWrapUPS.reason_id;
208 END IF;
209 IF(l_outcome_id IS NULL) THEN
210 l_outcome_id := rWrapUPS.outcome_id;
211 END IF;
212 IF(l_action_activity_id IS NULL) THEN
213 l_action_activity_id := rWrapUPS.action_activity_id;
214 END IF;
215 IF(l_object_id IS NULL) THEN
216 l_object_id := rWrapUPS.object_id;
217 END IF;
218 IF(l_object_type IS NULL) THEN
219 l_object_type := rWrapUPS.object_type;
220 END IF;
221 IF(l_source_code_id IS NULL) THEN
222 l_source_code_id := rWrapUPS.source_code_id;
223 END IF;
224 IF(l_source_code IS NULL) THEN
225 l_source_code := rWrapUPS.source_code;
226 END IF;
227 IF(l_start_date IS NULL) THEN
228 l_start_date := rWrapUPS.start_date;
229 END IF;
230 IF(l_end_date IS NULL) THEN
231 l_end_date := rWrapUPS.end_date;
232 END IF;
233 IF(l_wrap_up_level IS NULL) THEN
234 l_wrap_up_level := rWrapUPS.wrap_up_level;
235 END IF;
236
237 UPDATE jtf_ih_wrap_ups
238 SET
239 object_version_number=l_object_version_number
240 , last_updated_by =l_last_updated_by
241 , last_update_date = l_last_update_date
242 , last_update_login =l_last_update_login
243 , outcome_required =l_outcome_required
244 , result_required =l_result_required
245 , reason_required =l_reason_required
246 , result_id =l_result_id
247 , reason_id =l_reason_id
248 , outcome_id =l_outcome_id
249 , action_activity_id =l_action_activity_id
250 , object_id =l_object_id
251 , object_type=l_object_type
252 , source_code_id=l_source_code_id
253 , source_code=l_source_code
254 , start_date = l_start_date
255 , end_date = l_end_date
256 , wrap_up_level = l_wrap_up_level
257 WHERE WRAP_ID = l_wrap_id;
258
259 IF (SQL%NOTFOUND) THEN
260 RAISE NO_DATA_FOUND;
261 END IF;
262 END update_row;
263
264 PROCEDURE lock_row(
265 x_rowid VARCHAR2
266 , x_wrap_id NUMBER
267 , x_object_version_number NUMBER
268 , x_created_by NUMBER
269 , x_creation_date DATE
270 , x_last_updated_by NUMBER
271 , x_last_update_date DATE
272 , x_last_update_login NUMBER
273 , x_outcome_required VARCHAR2
274 , x_result_required VARCHAR2
275 , x_reason_required VARCHAR2
276 , x_result_id NUMBER
277 , x_reason_id NUMBER
278 , x_outcome_id NUMBER
279 , x_action_activity_id NUMBER
280 , x_object_id NUMBER
281 , x_object_type VARCHAR2
282 , x_source_code_id NUMBER
283 , x_source_code VARCHAR2
284 ) IS
285 -- bug# 2500341
286 CURSOR l_lock IS
287 SELECT *
288 FROM jtf_ih_wrap_ups
289 WHERE wrap_id = x_wrap_id
290 FOR UPDATE OF wrap_id NOWAIT;
291 l_table_rec l_lock%ROWTYPE;
292 BEGIN
293 OPEN l_lock;
294 FETCH l_lock INTO l_table_rec;
295 IF (l_lock%NOTFOUND) THEN
296 CLOSE l_lock;
297 FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
298 APP_EXCEPTION.RAISE_EXCEPTION;
299 END IF;
300 CLOSE l_lock;
301 IF (
302 ((l_table_rec.wrap_id = x_wrap_id)
303 OR ((l_table_rec.wrap_id IS NULL)
304 AND ( x_wrap_id IS NULL)))
305 AND ((l_table_rec.object_version_number = x_object_version_number)
306 OR ((l_table_rec.object_version_number IS NULL)
307 AND ( x_object_version_number IS NULL)))
308 AND ((l_table_rec.created_by = x_created_by)
309 OR ((l_table_rec.created_by IS NULL)
310 AND ( x_created_by IS NULL)))
311 AND ((l_table_rec.creation_date = x_creation_date)
312 OR ((l_table_rec.creation_date IS NULL)
313 AND ( x_creation_date IS NULL)))
314 AND ((l_table_rec.last_updated_by = x_last_updated_by)
315 OR ((l_table_rec.last_updated_by IS NULL)
316 AND ( x_last_updated_by IS NULL)))
317 AND ((l_table_rec.last_update_date = x_last_update_date)
318 OR ((l_table_rec.last_update_date IS NULL)
319 AND ( x_last_update_date IS NULL)))
320 AND ((l_table_rec.last_update_login = x_last_update_login)
321 OR ((l_table_rec.last_update_login IS NULL)
322 AND ( x_last_update_login IS NULL)))
323 AND ((l_table_rec.outcome_required = x_outcome_required)
324 OR ((l_table_rec.outcome_required IS NULL)
325 AND ( x_outcome_required IS NULL)))
326 AND ((l_table_rec.result_required = x_result_required)
327 OR ((l_table_rec.result_required IS NULL)
328 AND ( x_result_required IS NULL)))
329 AND ((l_table_rec.reason_required = x_reason_required)
330 OR ((l_table_rec.reason_required IS NULL)
331 AND ( x_reason_required IS NULL)))
332 AND ((l_table_rec.result_id = x_result_id)
333 OR ((l_table_rec.result_id IS NULL)
334 AND ( x_result_id IS NULL)))
335 AND ((l_table_rec.reason_id = x_reason_id)
336 OR ((l_table_rec.reason_id IS NULL)
337 AND ( x_reason_id IS NULL)))
338 AND ((l_table_rec.outcome_id = x_outcome_id)
339 OR ((l_table_rec.outcome_id IS NULL)
340 AND ( x_outcome_id IS NULL)))
341 AND ((l_table_rec.action_activity_id = x_action_activity_id)
342 OR ((l_table_rec.action_activity_id IS NULL)
343 AND ( x_action_activity_id IS NULL)))
344 AND ((l_table_rec.object_id = x_object_id)
345 OR ((l_table_rec.object_id IS NULL)
346 AND ( x_object_id IS NULL)))
347 AND ((l_table_rec.object_type = x_object_type)
348 OR ((l_table_rec.object_type IS NULL)
349 AND ( x_object_type IS NULL)))
350 AND ((l_table_rec.source_code_id = x_source_code_id)
351 OR ((l_table_rec.source_code_id IS NULL)
352 AND ( x_source_code_id IS NULL)))
353 AND ((l_table_rec.source_code = x_source_code)
354 OR ((l_table_rec.source_code IS NULL)
355 AND ( x_source_code IS NULL)))
356 ) THEN
360 APP_EXCEPTION.RAISE_EXCEPTION;
357 RETURN;
358 ELSE
359 FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
361 END IF;
362 END lock_row;
363
364
365 PROCEDURE load_row(
366 x_wrap_id NUMBER
367 , x_object_version_number NUMBER
368 , x_outcome_required VARCHAR2
369 , x_result_required VARCHAR2
370 , x_reason_required VARCHAR2
371 , x_result_id NUMBER
372 , x_reason_id NUMBER
373 , x_outcome_id NUMBER
374 , x_action_activity_id NUMBER
375 , x_object_id NUMBER
376 , x_object_type VARCHAR2
377 , x_source_code_id NUMBER
378 , x_source_code VARCHAR2
379 , x_start_date DATE
380 , x_end_date DATE
381 , x_owner VARCHAR2
382 , x_wrap_up_level VARCHAR2
383 )
384 AS
385 user_id NUMBER := 0;
386 row_id VARCHAR2(64);
387 l_wrap_id NUMBER;
388 l_object_version_number NUMBER;
389 l_outcome_required VARCHAR2(1);
390 l_result_required VARCHAR2(1);
391 l_reason_required VARCHAR2(1);
392 l_result_id NUMBER;
393 l_reason_id NUMBER;
394 l_outcome_id NUMBER;
395 l_action_activity_id NUMBER;
396 l_object_id NUMBER;
397 l_object_type VARCHAR2(30);
398 l_source_code_id NUMBER;
399 l_source_code VARCHAR2(100);
400 l_start_date DATE;
401 l_end_date DATE;
402 l_wrap_up_level VARCHAR2(30);
403
404 l_Sql VARCHAR2(2000);
405 n_Wrap_Id NUMBER;
406 n_Cursor BINARY_INTEGER;
407 n_Res BINARY_INTEGER;
408
409 type rec_Params is record (
410 name varchar2(30),
411 value number);
412 type tbl_Params is table of rec_Params index by binary_integer;
413 v_Params tbl_Params;
414 n_CntParams number;
415 l_param_name varchar2(30);
416 l_param_value number;
417
418 BEGIN
419 --if (x_owner = 'SEED') then
420 -- user_id := 1;
421 --end if;
422 user_id := fnd_load_util.owner_id(x_owner);
423 l_wrap_id := x_wrap_id;
424 l_object_version_number := x_object_version_number;
425 l_outcome_required := x_outcome_required;
426 l_result_required := x_result_required;
427 l_reason_required := x_reason_required;
428 l_result_id := x_result_id;
429 l_reason_id := x_reason_id;
430 l_outcome_id := x_outcome_id;
431 l_action_activity_id := x_action_activity_id;
432 l_object_id := x_object_id;
433 l_object_type := x_object_type;
434 l_source_code_id := x_source_code_id;
435 l_source_code := x_source_code;
436 l_start_date := NVL(x_start_date,SYSDATE);
437 l_end_date := x_end_date;
438 l_wrap_up_level := x_wrap_up_level;
439
440 -- Check Wrap_Up on duplicate values.
441 --
442 l_Sql := 'SELECT Wrap_Id FROM jtf_ih_wrap_ups WHERE Outcome_ID = :outcome_id ';
443 n_CntParams := 1;
444 v_Params(n_CntParams).name := ':outcome_id';
445 v_Params(n_CntParams).value := l_outcome_id;
446 IF l_result_id IS NOT NULL THEN
447 -- l_Sql := l_Sql || 'AND result_id = '''||l_result_id||''' ';
448 l_Sql := l_Sql || 'AND result_id = :result_id ';
449 n_CntParams := n_CntParams + 1;
450 v_Params(n_CntParams).name := ':result_id';
451 v_Params(n_CntParams).value := l_result_id;
452 ELSE
453 l_Sql := l_Sql || 'AND result_id IS NULL ';
454 END IF;
455 IF l_reason_id IS NOT NULL THEN
456 --l_Sql := l_Sql || 'AND reason_id = '''||l_reason_id||''' ';
457 l_Sql := l_Sql || 'AND reason_id = :reason_id ';
458 n_CntParams := n_CntParams + 1;
459 v_Params(n_CntParams).name := ':reason_id';
460 v_Params(n_CntParams).value := l_reason_id;
461 ELSE
462 l_Sql := l_Sql || 'AND reason_id IS NULL ';
463 END IF;
464 IF l_source_code IS NOT NULL THEN
465 --l_Sql := l_Sql || 'AND source_code = '''||l_source_code||''' ';
466 l_Sql := l_Sql || 'AND source_code = :source_code ';
467 n_CntParams := n_CntParams + 1;
468 v_Params(n_CntParams).name := ':source_code';
469 v_Params(n_CntParams).value := l_source_code;
470 ELSE
471 l_Sql := l_Sql || 'AND source_code IS NULL ';
472 END IF;
473 IF l_source_code_id IS NOT NULL THEN
474 --l_Sql := l_Sql || 'AND source_code_id = '''||l_source_code_id||''' ';
475 l_Sql := l_Sql || 'AND source_code = :source_code_id ';
476 n_CntParams := n_CntParams + 1;
477 v_Params(n_CntParams).name := ':source_code_id';
478 v_Params(n_CntParams).value := l_source_code_id;
479
480 ELSE
481 l_Sql := l_Sql || 'AND source_code_id IS NULL ';
482 END IF;
483 l_Sql := l_Sql || 'ORDER BY wrap_id';
484 --dbms_output.put_line(l_Sql);
485 BEGIN
486 n_Cursor := dbms_sql.open_cursor;
487 dbms_sql.parse(n_Cursor, l_Sql, dbms_sql.native);
488 FOR i IN 1..v_Params.count LOOP
489 dbms_sql.bind_variable(n_Cursor,v_Params(i).name,v_Params(i).value);
490 END LOOP;
491 dbms_sql.define_column(n_Cursor,1,n_Wrap_Id);
492 n_Res := dbms_sql.execute(n_Cursor);
493 LOOP
494 IF dbms_sql.fetch_rows(n_Cursor) = 0 THEN
495 EXIT;
496 END IF;
497 dbms_sql.column_value(n_Cursor,1,n_Wrap_Id);
498 END LOOP;
499 END;
500 --dbms_output.put_line('Pass l_wrap_id = '||l_wrap_id);
501 --dbms_output.put_line('Get n_Wrap_Id = '||n_Wrap_Id);
502 --
503 -- Bug#3362889
504 BEGIN
505 IF ((n_Wrap_Id IS NOT NULL) AND (l_wrap_id <> n_Wrap_Id)) THEN
506 IF ((n_Wrap_Id > l_wrap_id) AND (l_wrap_id < 10000)) THEN
507 -- dbms_output.put_line('Update JTF_IH_ACTION_ACTION_ITEMS');
508 UPDATE jtf_ih_wrap_ups SET wrap_id = l_wrap_id WHERE wrap_id = n_Wrap_Id;
509 UPDATE jtf_ih_action_action_items SET default_wrap_id = l_wrap_id
510 WHERE default_wrap_id = n_Wrap_Id;
511 ELSE
512 l_wrap_id := n_Wrap_Id;
513 END IF;
514 END IF;
515 --dbms_output.put_line('Wrap_ID = '||l_wrap_id);
516
517 update_row(
518 x_wrap_id => l_wrap_id
519 , x_object_version_number => l_object_version_number
520 , x_created_by => null
521 , x_creation_date => null
522 , x_last_updated_by => user_id
523 , x_last_update_date => sysdate
524 , x_last_update_login => 0
525 , x_outcome_required => l_outcome_required
526 , x_result_required => l_result_required
527 , x_reason_required => l_reason_required
528 , x_result_id => l_result_id
529 , x_reason_id => l_reason_id
530 , x_outcome_id => l_outcome_id
531 , x_action_activity_id => l_action_activity_id
532 , x_object_id => l_object_id
533 , x_object_type => l_object_type
534 , x_source_code_id => l_source_code_id
535 , x_source_code => l_source_code
536 , x_start_date => l_start_date
537 , x_end_date => l_end_date
538 , x_wrap_up_level => l_wrap_up_level);
539 EXCEPTION
540 WHEN DUP_VAL_ON_INDEX THEN
541 NULL;
542 END;
543 EXCEPTION
544 WHEN NO_DATA_FOUND THEN
545 insert_row(
546 x_rowid => row_id
547 , x_wrap_id => l_wrap_id
548 , x_object_version_number => l_object_version_number
549 , x_created_by => user_id
550 , x_creation_date => sysdate
551 , x_last_updated_by => user_id
552 , x_last_update_date => sysdate
553 , x_last_update_login => 0
554 , x_outcome_required => l_outcome_required
555 , x_result_required => l_result_required
556 , x_reason_required => l_reason_required
557 , x_result_id => l_result_id
558 , x_reason_id => l_reason_id
559 , x_outcome_id => l_outcome_id
560 , x_action_activity_id => l_action_activity_id
561 , x_object_id => l_object_id
562 , x_object_type => l_object_type
563 , x_source_code_id => l_source_code_id
564 , x_source_code => l_source_code
565 , x_start_date => l_start_date
566 , x_end_date => l_end_date
567 , x_wrap_up_level => l_wrap_up_level
568 );
569 --dbms_output.put_line('Insert!');
570 END load_row;
571 PROCEDURE load_seed_row(
572 x_wrap_id NUMBER
573 , x_object_version_number NUMBER
574 , x_outcome_required VARCHAR2
575 , x_result_required VARCHAR2
576 , x_reason_required VARCHAR2
577 , x_result_id NUMBER
578 , x_reason_id NUMBER
579 , x_outcome_id NUMBER
580 , x_action_activity_id NUMBER
581 , x_object_id NUMBER
582 , x_object_type VARCHAR2
583 , x_source_code_id NUMBER
584 , x_source_code VARCHAR2
585 , x_start_date DATE DEFAULT NULL
586 , x_end_date DATE DEFAULT NULL
587 , x_owner VARCHAR2
588 , x_wrap_up_level VARCHAR2
589 , x_upload_mode VARCHAR2
590 )AS
591 BEGIN
592 JTF_IH_WRAP_UPS_SEED_PUB.LOAD_ROW(
593 x_wrap_id
594 , x_object_version_number
595 , x_outcome_required
596 , x_result_required
597 , x_reason_required
598 , x_result_id
599 , x_reason_id
600 , x_outcome_id
601 , x_action_activity_id
602 , x_object_id
603 , x_object_type
604 , x_source_code_id
605 , x_source_code
606 , x_start_date
607 , x_end_date
608 , x_owner
609 , x_wrap_up_level);
610 end LOAD_SEED_ROW;
611
612 END JTF_IH_WRAP_UPS_SEED_PUB;