1: package body ams_oa_camp_schedule_pub_w as
2: /* $Header: amsaschb.pls 120.4 2006/05/31 11:36:52 srivikri noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ams_camp_schedule_pub.schedule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
2: /* $Header: amsaschb.pls 120.4 2006/05/31 11:36:52 srivikri noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ams_camp_schedule_pub.schedule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
97: , a94 JTF_NUMBER_TABLE
98: , a95 JTF_NUMBER_TABLE
99: , a96 JTF_VARCHAR2_TABLE_100
100: , a97 JTF_VARCHAR2_TABLE_100
101: , a98 JTF_DATE_TABLE
102: , a99 JTF_NUMBER_TABLE
103: , a100 JTF_VARCHAR2_TABLE_300
104: , a101 JTF_VARCHAR2_TABLE_100
105: , a102 JTF_VARCHAR2_TABLE_300
227: end if;
228: end if;
229: end rosetta_table_copy_in_p3;
230: procedure rosetta_table_copy_out_p3(t ams_camp_schedule_pub.schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
231: , a1 out nocopy JTF_DATE_TABLE
232: , a2 out nocopy JTF_NUMBER_TABLE
233: , a3 out nocopy JTF_DATE_TABLE
234: , a4 out nocopy JTF_NUMBER_TABLE
235: , a5 out nocopy JTF_NUMBER_TABLE
229: end rosetta_table_copy_in_p3;
230: procedure rosetta_table_copy_out_p3(t ams_camp_schedule_pub.schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
231: , a1 out nocopy JTF_DATE_TABLE
232: , a2 out nocopy JTF_NUMBER_TABLE
233: , a3 out nocopy JTF_DATE_TABLE
234: , a4 out nocopy JTF_NUMBER_TABLE
235: , a5 out nocopy JTF_NUMBER_TABLE
236: , a6 out nocopy JTF_NUMBER_TABLE
237: , a7 out nocopy JTF_NUMBER_TABLE
236: , a6 out nocopy JTF_NUMBER_TABLE
237: , a7 out nocopy JTF_NUMBER_TABLE
238: , a8 out nocopy JTF_NUMBER_TABLE
239: , a9 out nocopy JTF_VARCHAR2_TABLE_100
240: , a10 out nocopy JTF_DATE_TABLE
241: , a11 out nocopy JTF_VARCHAR2_TABLE_100
242: , a12 out nocopy JTF_VARCHAR2_TABLE_100
243: , a13 out nocopy JTF_DATE_TABLE
244: , a14 out nocopy JTF_DATE_TABLE
239: , a9 out nocopy JTF_VARCHAR2_TABLE_100
240: , a10 out nocopy JTF_DATE_TABLE
241: , a11 out nocopy JTF_VARCHAR2_TABLE_100
242: , a12 out nocopy JTF_VARCHAR2_TABLE_100
243: , a13 out nocopy JTF_DATE_TABLE
244: , a14 out nocopy JTF_DATE_TABLE
245: , a15 out nocopy JTF_NUMBER_TABLE
246: , a16 out nocopy JTF_VARCHAR2_TABLE_100
247: , a17 out nocopy JTF_NUMBER_TABLE
240: , a10 out nocopy JTF_DATE_TABLE
241: , a11 out nocopy JTF_VARCHAR2_TABLE_100
242: , a12 out nocopy JTF_VARCHAR2_TABLE_100
243: , a13 out nocopy JTF_DATE_TABLE
244: , a14 out nocopy JTF_DATE_TABLE
245: , a15 out nocopy JTF_NUMBER_TABLE
246: , a16 out nocopy JTF_VARCHAR2_TABLE_100
247: , a17 out nocopy JTF_NUMBER_TABLE
248: , a18 out nocopy JTF_VARCHAR2_TABLE_100
324: , a94 out nocopy JTF_NUMBER_TABLE
325: , a95 out nocopy JTF_NUMBER_TABLE
326: , a96 out nocopy JTF_VARCHAR2_TABLE_100
327: , a97 out nocopy JTF_VARCHAR2_TABLE_100
328: , a98 out nocopy JTF_DATE_TABLE
329: , a99 out nocopy JTF_NUMBER_TABLE
330: , a100 out nocopy JTF_VARCHAR2_TABLE_300
331: , a101 out nocopy JTF_VARCHAR2_TABLE_100
332: , a102 out nocopy JTF_VARCHAR2_TABLE_300
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();
340: a1 := JTF_DATE_TABLE();
341: a2 := JTF_NUMBER_TABLE();
342: a3 := JTF_DATE_TABLE();
343: a4 := JTF_NUMBER_TABLE();
344: a5 := JTF_NUMBER_TABLE();
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();
340: a1 := JTF_DATE_TABLE();
341: a2 := JTF_NUMBER_TABLE();
342: a3 := JTF_DATE_TABLE();
343: a4 := JTF_NUMBER_TABLE();
344: a5 := JTF_NUMBER_TABLE();
345: a6 := JTF_NUMBER_TABLE();
346: a7 := JTF_NUMBER_TABLE();
345: a6 := JTF_NUMBER_TABLE();
346: a7 := JTF_NUMBER_TABLE();
347: a8 := JTF_NUMBER_TABLE();
348: a9 := JTF_VARCHAR2_TABLE_100();
349: a10 := JTF_DATE_TABLE();
350: a11 := JTF_VARCHAR2_TABLE_100();
351: a12 := JTF_VARCHAR2_TABLE_100();
352: a13 := JTF_DATE_TABLE();
353: a14 := JTF_DATE_TABLE();
348: a9 := JTF_VARCHAR2_TABLE_100();
349: a10 := JTF_DATE_TABLE();
350: a11 := JTF_VARCHAR2_TABLE_100();
351: a12 := JTF_VARCHAR2_TABLE_100();
352: a13 := JTF_DATE_TABLE();
353: a14 := JTF_DATE_TABLE();
354: a15 := JTF_NUMBER_TABLE();
355: a16 := JTF_VARCHAR2_TABLE_100();
356: a17 := JTF_NUMBER_TABLE();
349: a10 := JTF_DATE_TABLE();
350: a11 := JTF_VARCHAR2_TABLE_100();
351: a12 := JTF_VARCHAR2_TABLE_100();
352: a13 := JTF_DATE_TABLE();
353: a14 := JTF_DATE_TABLE();
354: a15 := JTF_NUMBER_TABLE();
355: a16 := JTF_VARCHAR2_TABLE_100();
356: a17 := JTF_NUMBER_TABLE();
357: a18 := JTF_VARCHAR2_TABLE_100();
433: a94 := JTF_NUMBER_TABLE();
434: a95 := JTF_NUMBER_TABLE();
435: a96 := JTF_VARCHAR2_TABLE_100();
436: a97 := JTF_VARCHAR2_TABLE_100();
437: a98 := JTF_DATE_TABLE();
438: a99 := JTF_NUMBER_TABLE();
439: a100 := JTF_VARCHAR2_TABLE_300();
440: a101 := JTF_VARCHAR2_TABLE_100();
441: a102 := JTF_VARCHAR2_TABLE_300();
442: a103 := JTF_VARCHAR2_TABLE_300();
443: a104 := JTF_VARCHAR2_TABLE_100();
444: else
445: a0 := JTF_NUMBER_TABLE();
446: a1 := JTF_DATE_TABLE();
447: a2 := JTF_NUMBER_TABLE();
448: a3 := JTF_DATE_TABLE();
449: a4 := JTF_NUMBER_TABLE();
450: a5 := JTF_NUMBER_TABLE();
444: else
445: a0 := JTF_NUMBER_TABLE();
446: a1 := JTF_DATE_TABLE();
447: a2 := JTF_NUMBER_TABLE();
448: a3 := JTF_DATE_TABLE();
449: a4 := JTF_NUMBER_TABLE();
450: a5 := JTF_NUMBER_TABLE();
451: a6 := JTF_NUMBER_TABLE();
452: a7 := JTF_NUMBER_TABLE();
451: a6 := JTF_NUMBER_TABLE();
452: a7 := JTF_NUMBER_TABLE();
453: a8 := JTF_NUMBER_TABLE();
454: a9 := JTF_VARCHAR2_TABLE_100();
455: a10 := JTF_DATE_TABLE();
456: a11 := JTF_VARCHAR2_TABLE_100();
457: a12 := JTF_VARCHAR2_TABLE_100();
458: a13 := JTF_DATE_TABLE();
459: a14 := JTF_DATE_TABLE();
454: a9 := JTF_VARCHAR2_TABLE_100();
455: a10 := JTF_DATE_TABLE();
456: a11 := JTF_VARCHAR2_TABLE_100();
457: a12 := JTF_VARCHAR2_TABLE_100();
458: a13 := JTF_DATE_TABLE();
459: a14 := JTF_DATE_TABLE();
460: a15 := JTF_NUMBER_TABLE();
461: a16 := JTF_VARCHAR2_TABLE_100();
462: a17 := JTF_NUMBER_TABLE();
455: a10 := JTF_DATE_TABLE();
456: a11 := JTF_VARCHAR2_TABLE_100();
457: a12 := JTF_VARCHAR2_TABLE_100();
458: a13 := JTF_DATE_TABLE();
459: a14 := JTF_DATE_TABLE();
460: a15 := JTF_NUMBER_TABLE();
461: a16 := JTF_VARCHAR2_TABLE_100();
462: a17 := JTF_NUMBER_TABLE();
463: a18 := JTF_VARCHAR2_TABLE_100();
539: a94 := JTF_NUMBER_TABLE();
540: a95 := JTF_NUMBER_TABLE();
541: a96 := JTF_VARCHAR2_TABLE_100();
542: a97 := JTF_VARCHAR2_TABLE_100();
543: a98 := JTF_DATE_TABLE();
544: a99 := JTF_NUMBER_TABLE();
545: a100 := JTF_VARCHAR2_TABLE_300();
546: a101 := JTF_VARCHAR2_TABLE_100();
547: a102 := JTF_VARCHAR2_TABLE_300();