DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_SCHEDULE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100

Line 19: , a3 JTF_NUMBER_TABLE

15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100

Line 22: , a6 JTF_NUMBER_TABLE

18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100

Line 27: , a11 JTF_NUMBER_TABLE

23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_100

Line 29: , a13 JTF_NUMBER_TABLE

25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
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

Line 74: , a1 out nocopy JTF_NUMBER_TABLE

70: end if;
71: end if;
72: end rosetta_table_copy_in_p5;
73: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_VARCHAR2_TABLE_100
76: , a3 out nocopy JTF_NUMBER_TABLE
77: , a4 out nocopy JTF_VARCHAR2_TABLE_100
78: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 76: , a3 out nocopy JTF_NUMBER_TABLE

72: end rosetta_table_copy_in_p5;
73: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_VARCHAR2_TABLE_100
76: , a3 out nocopy JTF_NUMBER_TABLE
77: , a4 out nocopy JTF_VARCHAR2_TABLE_100
78: , a5 out nocopy JTF_VARCHAR2_TABLE_100
79: , a6 out nocopy JTF_NUMBER_TABLE
80: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 79: , a6 out nocopy JTF_NUMBER_TABLE

75: , a2 out nocopy JTF_VARCHAR2_TABLE_100
76: , a3 out nocopy JTF_NUMBER_TABLE
77: , a4 out nocopy JTF_VARCHAR2_TABLE_100
78: , a5 out nocopy JTF_VARCHAR2_TABLE_100
79: , a6 out nocopy JTF_NUMBER_TABLE
80: , a7 out nocopy JTF_VARCHAR2_TABLE_100
81: , a8 out nocopy JTF_VARCHAR2_TABLE_100
82: , a9 out nocopy JTF_VARCHAR2_TABLE_100
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 84: , a11 out nocopy JTF_NUMBER_TABLE

80: , a7 out nocopy JTF_VARCHAR2_TABLE_100
81: , a8 out nocopy JTF_VARCHAR2_TABLE_100
82: , a9 out nocopy JTF_VARCHAR2_TABLE_100
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100
84: , a11 out nocopy JTF_NUMBER_TABLE
85: , a12 out nocopy JTF_VARCHAR2_TABLE_100
86: , a13 out nocopy JTF_NUMBER_TABLE
87: , a14 out nocopy JTF_VARCHAR2_TABLE_100
88: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 86: , a13 out nocopy JTF_NUMBER_TABLE

82: , a9 out nocopy JTF_VARCHAR2_TABLE_100
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100
84: , a11 out nocopy JTF_NUMBER_TABLE
85: , a12 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 98: a1 := JTF_NUMBER_TABLE();

94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
97: a0 := JTF_VARCHAR2_TABLE_300();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_NUMBER_TABLE();
101: a4 := JTF_VARCHAR2_TABLE_100();
102: a5 := JTF_VARCHAR2_TABLE_100();

Line 100: a3 := JTF_NUMBER_TABLE();

96: if t is null or t.count = 0 then
97: a0 := JTF_VARCHAR2_TABLE_300();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_NUMBER_TABLE();
101: a4 := JTF_VARCHAR2_TABLE_100();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();

Line 103: a6 := JTF_NUMBER_TABLE();

99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_NUMBER_TABLE();
101: a4 := JTF_VARCHAR2_TABLE_100();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_VARCHAR2_TABLE_100();
106: a9 := JTF_VARCHAR2_TABLE_100();
107: a10 := JTF_VARCHAR2_TABLE_100();

Line 108: a11 := JTF_NUMBER_TABLE();

104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_VARCHAR2_TABLE_100();
106: a9 := JTF_VARCHAR2_TABLE_100();
107: a10 := JTF_VARCHAR2_TABLE_100();
108: a11 := JTF_NUMBER_TABLE();
109: a12 := JTF_VARCHAR2_TABLE_100();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_VARCHAR2_TABLE_100();
112: a15 := JTF_VARCHAR2_TABLE_100();

Line 110: a13 := JTF_NUMBER_TABLE();

106: a9 := JTF_VARCHAR2_TABLE_100();
107: a10 := JTF_VARCHAR2_TABLE_100();
108: a11 := JTF_NUMBER_TABLE();
109: a12 := JTF_VARCHAR2_TABLE_100();
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();

Line 119: a1 := JTF_NUMBER_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();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
123: a5 := JTF_VARCHAR2_TABLE_100();

Line 121: a3 := JTF_NUMBER_TABLE();

117: else
118: a0 := JTF_VARCHAR2_TABLE_300();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
123: a5 := JTF_VARCHAR2_TABLE_100();
124: a6 := JTF_NUMBER_TABLE();
125: a7 := JTF_VARCHAR2_TABLE_100();

Line 124: a6 := JTF_NUMBER_TABLE();

120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
123: a5 := JTF_VARCHAR2_TABLE_100();
124: a6 := JTF_NUMBER_TABLE();
125: a7 := JTF_VARCHAR2_TABLE_100();
126: a8 := JTF_VARCHAR2_TABLE_100();
127: a9 := JTF_VARCHAR2_TABLE_100();
128: a10 := JTF_VARCHAR2_TABLE_100();

Line 129: a11 := JTF_NUMBER_TABLE();

125: a7 := JTF_VARCHAR2_TABLE_100();
126: a8 := JTF_VARCHAR2_TABLE_100();
127: a9 := JTF_VARCHAR2_TABLE_100();
128: a10 := JTF_VARCHAR2_TABLE_100();
129: a11 := JTF_NUMBER_TABLE();
130: a12 := JTF_VARCHAR2_TABLE_100();
131: a13 := JTF_NUMBER_TABLE();
132: a14 := JTF_VARCHAR2_TABLE_100();
133: a15 := JTF_VARCHAR2_TABLE_100();

Line 131: a13 := JTF_NUMBER_TABLE();

127: a9 := JTF_VARCHAR2_TABLE_100();
128: a10 := JTF_VARCHAR2_TABLE_100();
129: a11 := JTF_NUMBER_TABLE();
130: a12 := 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();

Line 194: , a2 JTF_NUMBER_TABLE

190: end rosetta_table_copy_out_p5;
191:
192: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
193: , a1 JTF_VARCHAR2_TABLE_100
194: , a2 JTF_NUMBER_TABLE
195: , a3 JTF_VARCHAR2_TABLE_100
196: , a4 JTF_VARCHAR2_TABLE_100
197: , a5 JTF_NUMBER_TABLE
198: , a6 JTF_VARCHAR2_TABLE_100

Line 197: , a5 JTF_NUMBER_TABLE

193: , a1 JTF_VARCHAR2_TABLE_100
194: , a2 JTF_NUMBER_TABLE
195: , a3 JTF_VARCHAR2_TABLE_100
196: , a4 JTF_VARCHAR2_TABLE_100
197: , a5 JTF_NUMBER_TABLE
198: , a6 JTF_VARCHAR2_TABLE_100
199: , a7 JTF_VARCHAR2_TABLE_100
200: , a8 JTF_VARCHAR2_TABLE_100
201: , a9 JTF_VARCHAR2_TABLE_100

Line 255: , a2 out nocopy JTF_NUMBER_TABLE

251: end if;
252: end rosetta_table_copy_in_p6;
253: procedure rosetta_table_copy_out_p6(t ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
254: , a1 out nocopy JTF_VARCHAR2_TABLE_100
255: , a2 out nocopy JTF_NUMBER_TABLE
256: , a3 out nocopy JTF_VARCHAR2_TABLE_100
257: , a4 out nocopy JTF_VARCHAR2_TABLE_100
258: , a5 out nocopy JTF_NUMBER_TABLE
259: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 258: , a5 out nocopy JTF_NUMBER_TABLE

254: , a1 out nocopy JTF_VARCHAR2_TABLE_100
255: , a2 out nocopy JTF_NUMBER_TABLE
256: , a3 out nocopy JTF_VARCHAR2_TABLE_100
257: , a4 out nocopy JTF_VARCHAR2_TABLE_100
258: , a5 out nocopy JTF_NUMBER_TABLE
259: , a6 out nocopy JTF_VARCHAR2_TABLE_100
260: , a7 out nocopy JTF_VARCHAR2_TABLE_100
261: , a8 out nocopy JTF_VARCHAR2_TABLE_100
262: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 281: a2 := JTF_NUMBER_TABLE();

277: begin
278: if t is null or t.count = 0 then
279: a0 := JTF_VARCHAR2_TABLE_300();
280: a1 := JTF_VARCHAR2_TABLE_100();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_VARCHAR2_TABLE_100();
283: a4 := JTF_VARCHAR2_TABLE_100();
284: a5 := JTF_NUMBER_TABLE();
285: a6 := JTF_VARCHAR2_TABLE_100();

Line 284: a5 := JTF_NUMBER_TABLE();

280: a1 := JTF_VARCHAR2_TABLE_100();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_VARCHAR2_TABLE_100();
283: a4 := JTF_VARCHAR2_TABLE_100();
284: a5 := JTF_NUMBER_TABLE();
285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();

Line 304: a2 := JTF_NUMBER_TABLE();

300: a21 := JTF_VARCHAR2_TABLE_100();
301: else
302: a0 := JTF_VARCHAR2_TABLE_300();
303: a1 := JTF_VARCHAR2_TABLE_100();
304: a2 := JTF_NUMBER_TABLE();
305: a3 := JTF_VARCHAR2_TABLE_100();
306: a4 := JTF_VARCHAR2_TABLE_100();
307: a5 := JTF_NUMBER_TABLE();
308: a6 := JTF_VARCHAR2_TABLE_100();

Line 307: a5 := JTF_NUMBER_TABLE();

303: a1 := JTF_VARCHAR2_TABLE_100();
304: a2 := JTF_NUMBER_TABLE();
305: a3 := JTF_VARCHAR2_TABLE_100();
306: a4 := JTF_VARCHAR2_TABLE_100();
307: a5 := JTF_NUMBER_TABLE();
308: a6 := JTF_VARCHAR2_TABLE_100();
309: a7 := JTF_VARCHAR2_TABLE_100();
310: a8 := JTF_VARCHAR2_TABLE_100();
311: a9 := JTF_VARCHAR2_TABLE_100();

Line 382: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE

378: end if;
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

Line 403: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE

399: end loop;
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

Line 409: a0 := JTF_NUMBER_TABLE();

405: ) as
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();

Line 412: a0 := JTF_NUMBER_TABLE();

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
415: a0.extend(t.count);
416: a1.extend(t.count);

Line 432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE

428: end if;
429: end if;
430: end rosetta_table_copy_out_p7;
431:
432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE
433: , a1 JTF_VARCHAR2_TABLE_100
434: , a2 JTF_VARCHAR2_TABLE_100
435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_VARCHAR2_TABLE_100

Line 435: , a3 JTF_NUMBER_TABLE

431:
432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE
433: , a1 JTF_VARCHAR2_TABLE_100
434: , a2 JTF_VARCHAR2_TABLE_100
435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_VARCHAR2_TABLE_100
437: , a5 JTF_VARCHAR2_TABLE_100
438: , a6 JTF_VARCHAR2_TABLE_100
439: , a7 JTF_VARCHAR2_TABLE_300

Line 475: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

471: end loop;
472: end if;
473: end if;
474: end rosetta_table_copy_in_p8;
475: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
476: , a1 out nocopy JTF_VARCHAR2_TABLE_100
477: , a2 out nocopy JTF_VARCHAR2_TABLE_100
478: , a3 out nocopy JTF_NUMBER_TABLE
479: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 478: , a3 out nocopy JTF_NUMBER_TABLE

474: end rosetta_table_copy_in_p8;
475: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
476: , a1 out nocopy JTF_VARCHAR2_TABLE_100
477: , a2 out nocopy JTF_VARCHAR2_TABLE_100
478: , a3 out nocopy JTF_NUMBER_TABLE
479: , a4 out nocopy JTF_VARCHAR2_TABLE_100
480: , a5 out nocopy JTF_VARCHAR2_TABLE_100
481: , a6 out nocopy JTF_VARCHAR2_TABLE_100
482: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 492: a0 := JTF_NUMBER_TABLE();

488: ) as
489: ddindx binary_integer; indx binary_integer;
490: begin
491: if t is null or t.count = 0 then
492: a0 := JTF_NUMBER_TABLE();
493: a1 := JTF_VARCHAR2_TABLE_100();
494: a2 := JTF_VARCHAR2_TABLE_100();
495: a3 := JTF_NUMBER_TABLE();
496: a4 := JTF_VARCHAR2_TABLE_100();

Line 495: a3 := JTF_NUMBER_TABLE();

491: if t is null or t.count = 0 then
492: a0 := JTF_NUMBER_TABLE();
493: a1 := JTF_VARCHAR2_TABLE_100();
494: a2 := JTF_VARCHAR2_TABLE_100();
495: a3 := JTF_NUMBER_TABLE();
496: a4 := JTF_VARCHAR2_TABLE_100();
497: a5 := JTF_VARCHAR2_TABLE_100();
498: a6 := JTF_VARCHAR2_TABLE_100();
499: a7 := JTF_VARCHAR2_TABLE_300();

Line 506: a0 := JTF_NUMBER_TABLE();

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();
509: a3 := JTF_NUMBER_TABLE();
510: a4 := JTF_VARCHAR2_TABLE_100();

Line 509: a3 := JTF_NUMBER_TABLE();

505: else
506: a0 := JTF_NUMBER_TABLE();
507: a1 := JTF_VARCHAR2_TABLE_100();
508: a2 := JTF_VARCHAR2_TABLE_100();
509: a3 := JTF_NUMBER_TABLE();
510: a4 := JTF_VARCHAR2_TABLE_100();
511: a5 := JTF_VARCHAR2_TABLE_100();
512: a6 := JTF_VARCHAR2_TABLE_100();
513: a7 := JTF_VARCHAR2_TABLE_300();

Line 559: procedure derive_visit_end_date(p0_a0 in out nocopy JTF_NUMBER_TABLE

555: end if;
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

Line 621: , p6_a2 out nocopy JTF_NUMBER_TABLE

617: , p5_a18 DATE
618: , p5_a19 DATE
619: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
620: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
621: , p6_a2 out nocopy JTF_NUMBER_TABLE
622: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a5 out nocopy JTF_NUMBER_TABLE
625: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 624: , p6_a5 out nocopy JTF_NUMBER_TABLE

620: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
621: , p6_a2 out nocopy JTF_NUMBER_TABLE
622: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a5 out nocopy JTF_NUMBER_TABLE
625: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
628: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 847: , p6_a0 out nocopy JTF_NUMBER_TABLE

843: , p5_a16 VARCHAR2
844: , p5_a17 DATE
845: , p5_a18 DATE
846: , p5_a19 DATE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
849: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
850: , p6_a3 out nocopy JTF_NUMBER_TABLE
851: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 850: , p6_a3 out nocopy JTF_NUMBER_TABLE

846: , p5_a19 DATE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
849: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
850: , p6_a3 out nocopy JTF_NUMBER_TABLE
851: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
852: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300