DBA Data[Home] [Help]

APPS.AMS_OA_CAMP_SCHEDULE_PUB_W dependencies on JTF_DATE_TABLE

Line 4: , a1 JTF_DATE_TABLE

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

Line 6: , a3 JTF_DATE_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

Line 13: , a10 JTF_DATE_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

Line 16: , a13 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

Line 17: , a14 JTF_DATE_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

Line 101: , a98 JTF_DATE_TABLE

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

Line 231: , a1 out nocopy JTF_DATE_TABLE

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

Line 233: , a3 out nocopy JTF_DATE_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

Line 240: , a10 out nocopy JTF_DATE_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

Line 243: , a13 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

Line 244: , a14 out nocopy JTF_DATE_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

Line 328: , a98 out nocopy JTF_DATE_TABLE

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

Line 340: a1 := JTF_DATE_TABLE();

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();

Line 342: a3 := JTF_DATE_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();

Line 349: a10 := JTF_DATE_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();

Line 352: a13 := 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();

Line 353: a14 := JTF_DATE_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();

Line 437: a98 := JTF_DATE_TABLE();

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();

Line 446: a1 := JTF_DATE_TABLE();

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();

Line 448: a3 := JTF_DATE_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();

Line 455: a10 := JTF_DATE_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();

Line 458: a13 := 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();

Line 459: a14 := JTF_DATE_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();

Line 543: a98 := JTF_DATE_TABLE();

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();