29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_DATE_TABLE
35: , a19 JTF_DATE_TABLE
36: ) as
37: ddindx binary_integer; indx binary_integer;
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_DATE_TABLE
35: , a19 JTF_DATE_TABLE
36: ) as
37: ddindx binary_integer; indx binary_integer;
38: begin
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_DATE_TABLE
35: , a19 JTF_DATE_TABLE
36: ) as
37: ddindx binary_integer; indx binary_integer;
38: begin
39: if a0 is not null and a0.count > 0 then
86: , a13 out nocopy JTF_NUMBER_TABLE
87: , a14 out nocopy JTF_VARCHAR2_TABLE_100
88: , a15 out nocopy JTF_VARCHAR2_TABLE_100
89: , a16 out nocopy JTF_VARCHAR2_TABLE_100
90: , a17 out nocopy JTF_DATE_TABLE
91: , a18 out nocopy JTF_DATE_TABLE
92: , a19 out nocopy JTF_DATE_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
87: , a14 out nocopy JTF_VARCHAR2_TABLE_100
88: , a15 out nocopy JTF_VARCHAR2_TABLE_100
89: , a16 out nocopy JTF_VARCHAR2_TABLE_100
90: , a17 out nocopy JTF_DATE_TABLE
91: , a18 out nocopy JTF_DATE_TABLE
92: , a19 out nocopy JTF_DATE_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
88: , a15 out nocopy JTF_VARCHAR2_TABLE_100
89: , a16 out nocopy JTF_VARCHAR2_TABLE_100
90: , a17 out nocopy JTF_DATE_TABLE
91: , a18 out nocopy JTF_DATE_TABLE
92: , a19 out nocopy JTF_DATE_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_VARCHAR2_TABLE_100();
112: a15 := JTF_VARCHAR2_TABLE_100();
113: a16 := JTF_VARCHAR2_TABLE_100();
114: a17 := JTF_DATE_TABLE();
115: a18 := JTF_DATE_TABLE();
116: a19 := JTF_DATE_TABLE();
117: else
118: a0 := JTF_VARCHAR2_TABLE_300();
111: a14 := JTF_VARCHAR2_TABLE_100();
112: a15 := JTF_VARCHAR2_TABLE_100();
113: a16 := JTF_VARCHAR2_TABLE_100();
114: a17 := JTF_DATE_TABLE();
115: a18 := JTF_DATE_TABLE();
116: a19 := JTF_DATE_TABLE();
117: else
118: a0 := JTF_VARCHAR2_TABLE_300();
119: a1 := JTF_NUMBER_TABLE();
112: a15 := JTF_VARCHAR2_TABLE_100();
113: a16 := JTF_VARCHAR2_TABLE_100();
114: a17 := JTF_DATE_TABLE();
115: a18 := JTF_DATE_TABLE();
116: a19 := JTF_DATE_TABLE();
117: else
118: a0 := JTF_VARCHAR2_TABLE_300();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_VARCHAR2_TABLE_100();
131: a13 := JTF_NUMBER_TABLE();
132: a14 := JTF_VARCHAR2_TABLE_100();
133: a15 := JTF_VARCHAR2_TABLE_100();
134: a16 := JTF_VARCHAR2_TABLE_100();
135: a17 := JTF_DATE_TABLE();
136: a18 := JTF_DATE_TABLE();
137: a19 := JTF_DATE_TABLE();
138: if t.count > 0 then
139: a0.extend(t.count);
132: a14 := JTF_VARCHAR2_TABLE_100();
133: a15 := JTF_VARCHAR2_TABLE_100();
134: a16 := JTF_VARCHAR2_TABLE_100();
135: a17 := JTF_DATE_TABLE();
136: a18 := JTF_DATE_TABLE();
137: a19 := JTF_DATE_TABLE();
138: if t.count > 0 then
139: a0.extend(t.count);
140: a1.extend(t.count);
133: a15 := JTF_VARCHAR2_TABLE_100();
134: a16 := JTF_VARCHAR2_TABLE_100();
135: a17 := JTF_DATE_TABLE();
136: a18 := JTF_DATE_TABLE();
137: a19 := JTF_DATE_TABLE();
138: if t.count > 0 then
139: a0.extend(t.count);
140: a1.extend(t.count);
141: a2.extend(t.count);
379: end if;
380: end rosetta_table_copy_out_p6;
381:
382: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE
383: , a1 JTF_DATE_TABLE
384: ) as
385: ddindx binary_integer; indx binary_integer;
386: begin
387: if a0 is not null and a0.count > 0 then
400: end if;
401: end if;
402: end rosetta_table_copy_in_p7;
403: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE
404: , a1 out nocopy JTF_DATE_TABLE
405: ) as
406: ddindx binary_integer; indx binary_integer;
407: begin
408: if t is null or t.count = 0 then
406: ddindx binary_integer; indx binary_integer;
407: begin
408: if t is null or t.count = 0 then
409: a0 := JTF_NUMBER_TABLE();
410: a1 := JTF_DATE_TABLE();
411: else
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_DATE_TABLE();
414: if t.count > 0 then
409: a0 := JTF_NUMBER_TABLE();
410: a1 := JTF_DATE_TABLE();
411: else
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_DATE_TABLE();
414: if t.count > 0 then
415: a0.extend(t.count);
416: a1.extend(t.count);
417: ddindx := t.first;
438: , a6 JTF_VARCHAR2_TABLE_100
439: , a7 JTF_VARCHAR2_TABLE_300
440: , a8 JTF_VARCHAR2_TABLE_100
441: , a9 JTF_VARCHAR2_TABLE_100
442: , a10 JTF_DATE_TABLE
443: , a11 JTF_DATE_TABLE
444: , a12 JTF_DATE_TABLE
445: ) as
446: ddindx binary_integer; indx binary_integer;
439: , a7 JTF_VARCHAR2_TABLE_300
440: , a8 JTF_VARCHAR2_TABLE_100
441: , a9 JTF_VARCHAR2_TABLE_100
442: , a10 JTF_DATE_TABLE
443: , a11 JTF_DATE_TABLE
444: , a12 JTF_DATE_TABLE
445: ) as
446: ddindx binary_integer; indx binary_integer;
447: begin
440: , a8 JTF_VARCHAR2_TABLE_100
441: , a9 JTF_VARCHAR2_TABLE_100
442: , a10 JTF_DATE_TABLE
443: , a11 JTF_DATE_TABLE
444: , a12 JTF_DATE_TABLE
445: ) as
446: ddindx binary_integer; indx binary_integer;
447: begin
448: if a0 is not null and a0.count > 0 then
481: , a6 out nocopy JTF_VARCHAR2_TABLE_100
482: , a7 out nocopy JTF_VARCHAR2_TABLE_300
483: , a8 out nocopy JTF_VARCHAR2_TABLE_100
484: , a9 out nocopy JTF_VARCHAR2_TABLE_100
485: , a10 out nocopy JTF_DATE_TABLE
486: , a11 out nocopy JTF_DATE_TABLE
487: , a12 out nocopy JTF_DATE_TABLE
488: ) as
489: ddindx binary_integer; indx binary_integer;
482: , a7 out nocopy JTF_VARCHAR2_TABLE_300
483: , a8 out nocopy JTF_VARCHAR2_TABLE_100
484: , a9 out nocopy JTF_VARCHAR2_TABLE_100
485: , a10 out nocopy JTF_DATE_TABLE
486: , a11 out nocopy JTF_DATE_TABLE
487: , a12 out nocopy JTF_DATE_TABLE
488: ) as
489: ddindx binary_integer; indx binary_integer;
490: begin
483: , a8 out nocopy JTF_VARCHAR2_TABLE_100
484: , a9 out nocopy JTF_VARCHAR2_TABLE_100
485: , a10 out nocopy JTF_DATE_TABLE
486: , a11 out nocopy JTF_DATE_TABLE
487: , a12 out nocopy JTF_DATE_TABLE
488: ) as
489: ddindx binary_integer; indx binary_integer;
490: begin
491: if t is null or t.count = 0 then
498: a6 := JTF_VARCHAR2_TABLE_100();
499: a7 := JTF_VARCHAR2_TABLE_300();
500: a8 := JTF_VARCHAR2_TABLE_100();
501: a9 := JTF_VARCHAR2_TABLE_100();
502: a10 := JTF_DATE_TABLE();
503: a11 := JTF_DATE_TABLE();
504: a12 := JTF_DATE_TABLE();
505: else
506: a0 := JTF_NUMBER_TABLE();
499: a7 := JTF_VARCHAR2_TABLE_300();
500: a8 := JTF_VARCHAR2_TABLE_100();
501: a9 := JTF_VARCHAR2_TABLE_100();
502: a10 := JTF_DATE_TABLE();
503: a11 := JTF_DATE_TABLE();
504: a12 := JTF_DATE_TABLE();
505: else
506: a0 := JTF_NUMBER_TABLE();
507: a1 := JTF_VARCHAR2_TABLE_100();
500: a8 := JTF_VARCHAR2_TABLE_100();
501: a9 := JTF_VARCHAR2_TABLE_100();
502: a10 := JTF_DATE_TABLE();
503: a11 := JTF_DATE_TABLE();
504: a12 := JTF_DATE_TABLE();
505: else
506: a0 := JTF_NUMBER_TABLE();
507: a1 := JTF_VARCHAR2_TABLE_100();
508: a2 := JTF_VARCHAR2_TABLE_100();
512: a6 := JTF_VARCHAR2_TABLE_100();
513: a7 := JTF_VARCHAR2_TABLE_300();
514: a8 := JTF_VARCHAR2_TABLE_100();
515: a9 := JTF_VARCHAR2_TABLE_100();
516: a10 := JTF_DATE_TABLE();
517: a11 := JTF_DATE_TABLE();
518: a12 := JTF_DATE_TABLE();
519: if t.count > 0 then
520: a0.extend(t.count);
513: a7 := JTF_VARCHAR2_TABLE_300();
514: a8 := JTF_VARCHAR2_TABLE_100();
515: a9 := JTF_VARCHAR2_TABLE_100();
516: a10 := JTF_DATE_TABLE();
517: a11 := JTF_DATE_TABLE();
518: a12 := JTF_DATE_TABLE();
519: if t.count > 0 then
520: a0.extend(t.count);
521: a1.extend(t.count);
514: a8 := JTF_VARCHAR2_TABLE_100();
515: a9 := JTF_VARCHAR2_TABLE_100();
516: a10 := JTF_DATE_TABLE();
517: a11 := JTF_DATE_TABLE();
518: a12 := JTF_DATE_TABLE();
519: if t.count > 0 then
520: a0.extend(t.count);
521: a1.extend(t.count);
522: a2.extend(t.count);
556: end if;
557: end rosetta_table_copy_out_p8;
558:
559: procedure derive_visit_end_date(p0_a0 in out nocopy JTF_NUMBER_TABLE
560: , p0_a1 in out nocopy JTF_DATE_TABLE
561: , x_return_status out nocopy VARCHAR2
562: , x_msg_count out nocopy NUMBER
563: , x_msg_data out nocopy VARCHAR2
564: )
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a10 out nocopy JTF_DATE_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_DATE_TABLE
860: , x_return_status out nocopy VARCHAR2
861: , x_msg_count out nocopy NUMBER
854: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a10 out nocopy JTF_DATE_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_DATE_TABLE
860: , x_return_status out nocopy VARCHAR2
861: , x_msg_count out nocopy NUMBER
862: , x_msg_data out nocopy VARCHAR2
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a10 out nocopy JTF_DATE_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_DATE_TABLE
860: , x_return_status out nocopy VARCHAR2
861: , x_msg_count out nocopy NUMBER
862: , x_msg_data out nocopy VARCHAR2
863: )