DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_SCHEDULE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 18: , a2 JTF_VARCHAR2_TABLE_100

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
22: , a6 JTF_NUMBER_TABLE

Line 20: , a4 JTF_VARCHAR2_TABLE_100

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
24: , a8 JTF_VARCHAR2_TABLE_100

Line 21: , a5 JTF_VARCHAR2_TABLE_100

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
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100

Line 23: , a7 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
27: , a11 JTF_NUMBER_TABLE

Line 24: , a8 JTF_VARCHAR2_TABLE_100

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

Line 25: , a9 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
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_NUMBER_TABLE

Line 26: , a10 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
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100

Line 28: , a12 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
32: , a16 JTF_VARCHAR2_TABLE_100

Line 30: , a14 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
34: , a18 JTF_DATE_TABLE

Line 31: , a15 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
34: , a18 JTF_DATE_TABLE
35: , a19 JTF_DATE_TABLE

Line 32: , a16 JTF_VARCHAR2_TABLE_100

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
34: , a18 JTF_DATE_TABLE
35: , a19 JTF_DATE_TABLE
36: ) as

Line 75: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
79: , a6 out nocopy JTF_NUMBER_TABLE

Line 77: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
81: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 78: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
81: , a8 out nocopy JTF_VARCHAR2_TABLE_100
82: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 80: , a7 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
84: , a11 out nocopy JTF_NUMBER_TABLE

Line 81: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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

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

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

Line 85: , a12 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
89: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 87: , a14 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
91: , a18 out nocopy JTF_DATE_TABLE

Line 88: , a15 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
91: , a18 out nocopy JTF_DATE_TABLE
92: , a19 out nocopy JTF_DATE_TABLE

Line 89: , a16 out nocopy JTF_VARCHAR2_TABLE_100

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
91: , a18 out nocopy JTF_DATE_TABLE
92: , a19 out nocopy JTF_DATE_TABLE
93: ) as

Line 99: a2 := JTF_VARCHAR2_TABLE_100();

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();
103: a6 := JTF_NUMBER_TABLE();

Line 101: a4 := JTF_VARCHAR2_TABLE_100();

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();
105: a8 := JTF_VARCHAR2_TABLE_100();

Line 102: a5 := JTF_VARCHAR2_TABLE_100();

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();
105: a8 := JTF_VARCHAR2_TABLE_100();
106: a9 := JTF_VARCHAR2_TABLE_100();

Line 104: a7 := 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();
108: a11 := JTF_NUMBER_TABLE();

Line 105: a8 := JTF_VARCHAR2_TABLE_100();

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

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

Line 107: a10 := 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();
108: a11 := JTF_NUMBER_TABLE();
109: a12 := JTF_VARCHAR2_TABLE_100();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_VARCHAR2_TABLE_100();

Line 109: a12 := 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();
113: a16 := JTF_VARCHAR2_TABLE_100();

Line 111: a14 := 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();
115: a18 := JTF_DATE_TABLE();

Line 112: a15 := 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();
115: a18 := JTF_DATE_TABLE();
116: a19 := JTF_DATE_TABLE();

Line 113: a16 := JTF_VARCHAR2_TABLE_100();

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();
115: a18 := JTF_DATE_TABLE();
116: a19 := JTF_DATE_TABLE();
117: else

Line 120: a2 := JTF_VARCHAR2_TABLE_100();

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();
124: a6 := JTF_NUMBER_TABLE();

Line 122: a4 := JTF_VARCHAR2_TABLE_100();

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();
126: a8 := JTF_VARCHAR2_TABLE_100();

Line 123: a5 := JTF_VARCHAR2_TABLE_100();

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();
126: a8 := JTF_VARCHAR2_TABLE_100();
127: a9 := JTF_VARCHAR2_TABLE_100();

Line 125: a7 := 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();
129: a11 := JTF_NUMBER_TABLE();

Line 126: a8 := JTF_VARCHAR2_TABLE_100();

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

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

Line 128: a10 := 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();
129: a11 := JTF_NUMBER_TABLE();
130: a12 := JTF_VARCHAR2_TABLE_100();
131: a13 := JTF_NUMBER_TABLE();
132: a14 := JTF_VARCHAR2_TABLE_100();

Line 130: a12 := 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();
134: a16 := JTF_VARCHAR2_TABLE_100();

Line 132: a14 := 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();
136: a18 := JTF_DATE_TABLE();

Line 133: a15 := 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();
136: a18 := JTF_DATE_TABLE();
137: a19 := JTF_DATE_TABLE();

Line 134: a16 := JTF_VARCHAR2_TABLE_100();

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();
136: a18 := JTF_DATE_TABLE();
137: a19 := JTF_DATE_TABLE();
138: if t.count > 0 then

Line 193: , a1 JTF_VARCHAR2_TABLE_100

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

Line 195: , a3 JTF_VARCHAR2_TABLE_100

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
199: , a7 JTF_VARCHAR2_TABLE_100

Line 196: , a4 JTF_VARCHAR2_TABLE_100

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
199: , a7 JTF_VARCHAR2_TABLE_100
200: , a8 JTF_VARCHAR2_TABLE_100

Line 198: , a6 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
202: , a10 JTF_VARCHAR2_TABLE_100

Line 199: , a7 JTF_VARCHAR2_TABLE_100

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
202: , a10 JTF_VARCHAR2_TABLE_100
203: , a11 JTF_VARCHAR2_TABLE_100

Line 200: , a8 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
202: , a10 JTF_VARCHAR2_TABLE_100
203: , a11 JTF_VARCHAR2_TABLE_100
204: , a12 JTF_VARCHAR2_TABLE_100

Line 201: , a9 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
202: , a10 JTF_VARCHAR2_TABLE_100
203: , a11 JTF_VARCHAR2_TABLE_100
204: , a12 JTF_VARCHAR2_TABLE_100
205: , a13 JTF_VARCHAR2_TABLE_100

Line 202: , a10 JTF_VARCHAR2_TABLE_100

198: , a6 JTF_VARCHAR2_TABLE_100
199: , a7 JTF_VARCHAR2_TABLE_100
200: , a8 JTF_VARCHAR2_TABLE_100
201: , a9 JTF_VARCHAR2_TABLE_100
202: , a10 JTF_VARCHAR2_TABLE_100
203: , a11 JTF_VARCHAR2_TABLE_100
204: , a12 JTF_VARCHAR2_TABLE_100
205: , a13 JTF_VARCHAR2_TABLE_100
206: , a14 JTF_VARCHAR2_TABLE_100

Line 203: , a11 JTF_VARCHAR2_TABLE_100

199: , a7 JTF_VARCHAR2_TABLE_100
200: , a8 JTF_VARCHAR2_TABLE_100
201: , a9 JTF_VARCHAR2_TABLE_100
202: , a10 JTF_VARCHAR2_TABLE_100
203: , a11 JTF_VARCHAR2_TABLE_100
204: , a12 JTF_VARCHAR2_TABLE_100
205: , a13 JTF_VARCHAR2_TABLE_100
206: , a14 JTF_VARCHAR2_TABLE_100
207: , a15 JTF_VARCHAR2_TABLE_100

Line 204: , a12 JTF_VARCHAR2_TABLE_100

200: , a8 JTF_VARCHAR2_TABLE_100
201: , a9 JTF_VARCHAR2_TABLE_100
202: , a10 JTF_VARCHAR2_TABLE_100
203: , a11 JTF_VARCHAR2_TABLE_100
204: , a12 JTF_VARCHAR2_TABLE_100
205: , a13 JTF_VARCHAR2_TABLE_100
206: , a14 JTF_VARCHAR2_TABLE_100
207: , a15 JTF_VARCHAR2_TABLE_100
208: , a16 JTF_VARCHAR2_TABLE_100

Line 205: , a13 JTF_VARCHAR2_TABLE_100

201: , a9 JTF_VARCHAR2_TABLE_100
202: , a10 JTF_VARCHAR2_TABLE_100
203: , a11 JTF_VARCHAR2_TABLE_100
204: , a12 JTF_VARCHAR2_TABLE_100
205: , a13 JTF_VARCHAR2_TABLE_100
206: , a14 JTF_VARCHAR2_TABLE_100
207: , a15 JTF_VARCHAR2_TABLE_100
208: , a16 JTF_VARCHAR2_TABLE_100
209: , a17 JTF_VARCHAR2_TABLE_100

Line 206: , a14 JTF_VARCHAR2_TABLE_100

202: , a10 JTF_VARCHAR2_TABLE_100
203: , a11 JTF_VARCHAR2_TABLE_100
204: , a12 JTF_VARCHAR2_TABLE_100
205: , a13 JTF_VARCHAR2_TABLE_100
206: , a14 JTF_VARCHAR2_TABLE_100
207: , a15 JTF_VARCHAR2_TABLE_100
208: , a16 JTF_VARCHAR2_TABLE_100
209: , a17 JTF_VARCHAR2_TABLE_100
210: , a18 JTF_VARCHAR2_TABLE_100

Line 207: , a15 JTF_VARCHAR2_TABLE_100

203: , a11 JTF_VARCHAR2_TABLE_100
204: , a12 JTF_VARCHAR2_TABLE_100
205: , a13 JTF_VARCHAR2_TABLE_100
206: , a14 JTF_VARCHAR2_TABLE_100
207: , a15 JTF_VARCHAR2_TABLE_100
208: , a16 JTF_VARCHAR2_TABLE_100
209: , a17 JTF_VARCHAR2_TABLE_100
210: , a18 JTF_VARCHAR2_TABLE_100
211: , a19 JTF_VARCHAR2_TABLE_100

Line 208: , a16 JTF_VARCHAR2_TABLE_100

204: , a12 JTF_VARCHAR2_TABLE_100
205: , a13 JTF_VARCHAR2_TABLE_100
206: , a14 JTF_VARCHAR2_TABLE_100
207: , a15 JTF_VARCHAR2_TABLE_100
208: , a16 JTF_VARCHAR2_TABLE_100
209: , a17 JTF_VARCHAR2_TABLE_100
210: , a18 JTF_VARCHAR2_TABLE_100
211: , a19 JTF_VARCHAR2_TABLE_100
212: , a20 JTF_VARCHAR2_TABLE_100

Line 209: , a17 JTF_VARCHAR2_TABLE_100

205: , a13 JTF_VARCHAR2_TABLE_100
206: , a14 JTF_VARCHAR2_TABLE_100
207: , a15 JTF_VARCHAR2_TABLE_100
208: , a16 JTF_VARCHAR2_TABLE_100
209: , a17 JTF_VARCHAR2_TABLE_100
210: , a18 JTF_VARCHAR2_TABLE_100
211: , a19 JTF_VARCHAR2_TABLE_100
212: , a20 JTF_VARCHAR2_TABLE_100
213: , a21 JTF_VARCHAR2_TABLE_100

Line 210: , a18 JTF_VARCHAR2_TABLE_100

206: , a14 JTF_VARCHAR2_TABLE_100
207: , a15 JTF_VARCHAR2_TABLE_100
208: , a16 JTF_VARCHAR2_TABLE_100
209: , a17 JTF_VARCHAR2_TABLE_100
210: , a18 JTF_VARCHAR2_TABLE_100
211: , a19 JTF_VARCHAR2_TABLE_100
212: , a20 JTF_VARCHAR2_TABLE_100
213: , a21 JTF_VARCHAR2_TABLE_100
214: ) as

Line 211: , a19 JTF_VARCHAR2_TABLE_100

207: , a15 JTF_VARCHAR2_TABLE_100
208: , a16 JTF_VARCHAR2_TABLE_100
209: , a17 JTF_VARCHAR2_TABLE_100
210: , a18 JTF_VARCHAR2_TABLE_100
211: , a19 JTF_VARCHAR2_TABLE_100
212: , a20 JTF_VARCHAR2_TABLE_100
213: , a21 JTF_VARCHAR2_TABLE_100
214: ) as
215: ddindx binary_integer; indx binary_integer;

Line 212: , a20 JTF_VARCHAR2_TABLE_100

208: , a16 JTF_VARCHAR2_TABLE_100
209: , a17 JTF_VARCHAR2_TABLE_100
210: , a18 JTF_VARCHAR2_TABLE_100
211: , a19 JTF_VARCHAR2_TABLE_100
212: , a20 JTF_VARCHAR2_TABLE_100
213: , a21 JTF_VARCHAR2_TABLE_100
214: ) as
215: ddindx binary_integer; indx binary_integer;
216: begin

Line 213: , a21 JTF_VARCHAR2_TABLE_100

209: , a17 JTF_VARCHAR2_TABLE_100
210: , a18 JTF_VARCHAR2_TABLE_100
211: , a19 JTF_VARCHAR2_TABLE_100
212: , a20 JTF_VARCHAR2_TABLE_100
213: , a21 JTF_VARCHAR2_TABLE_100
214: ) as
215: ddindx binary_integer; indx binary_integer;
216: begin
217: if a0 is not null and a0.count > 0 then

Line 254: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 256: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
260: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 257: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
260: , a7 out nocopy JTF_VARCHAR2_TABLE_100
261: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 259: , a6 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
263: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 260: , a7 out nocopy JTF_VARCHAR2_TABLE_100

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
263: , a10 out nocopy JTF_VARCHAR2_TABLE_100
264: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 261: , a8 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
263: , a10 out nocopy JTF_VARCHAR2_TABLE_100
264: , a11 out nocopy JTF_VARCHAR2_TABLE_100
265: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 262: , a9 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
263: , a10 out nocopy JTF_VARCHAR2_TABLE_100
264: , a11 out nocopy JTF_VARCHAR2_TABLE_100
265: , a12 out nocopy JTF_VARCHAR2_TABLE_100
266: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 263: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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
263: , a10 out nocopy JTF_VARCHAR2_TABLE_100
264: , a11 out nocopy JTF_VARCHAR2_TABLE_100
265: , a12 out nocopy JTF_VARCHAR2_TABLE_100
266: , a13 out nocopy JTF_VARCHAR2_TABLE_100
267: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 264: , a11 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
263: , a10 out nocopy JTF_VARCHAR2_TABLE_100
264: , a11 out nocopy JTF_VARCHAR2_TABLE_100
265: , a12 out nocopy JTF_VARCHAR2_TABLE_100
266: , a13 out nocopy JTF_VARCHAR2_TABLE_100
267: , a14 out nocopy JTF_VARCHAR2_TABLE_100
268: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , a12 out nocopy JTF_VARCHAR2_TABLE_100

261: , a8 out nocopy JTF_VARCHAR2_TABLE_100
262: , a9 out nocopy JTF_VARCHAR2_TABLE_100
263: , a10 out nocopy JTF_VARCHAR2_TABLE_100
264: , a11 out nocopy JTF_VARCHAR2_TABLE_100
265: , a12 out nocopy JTF_VARCHAR2_TABLE_100
266: , a13 out nocopy JTF_VARCHAR2_TABLE_100
267: , a14 out nocopy JTF_VARCHAR2_TABLE_100
268: , a15 out nocopy JTF_VARCHAR2_TABLE_100
269: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 266: , a13 out nocopy JTF_VARCHAR2_TABLE_100

262: , a9 out nocopy JTF_VARCHAR2_TABLE_100
263: , a10 out nocopy JTF_VARCHAR2_TABLE_100
264: , a11 out nocopy JTF_VARCHAR2_TABLE_100
265: , a12 out nocopy JTF_VARCHAR2_TABLE_100
266: , a13 out nocopy JTF_VARCHAR2_TABLE_100
267: , a14 out nocopy JTF_VARCHAR2_TABLE_100
268: , a15 out nocopy JTF_VARCHAR2_TABLE_100
269: , a16 out nocopy JTF_VARCHAR2_TABLE_100
270: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , a14 out nocopy JTF_VARCHAR2_TABLE_100

263: , a10 out nocopy JTF_VARCHAR2_TABLE_100
264: , a11 out nocopy JTF_VARCHAR2_TABLE_100
265: , a12 out nocopy JTF_VARCHAR2_TABLE_100
266: , a13 out nocopy JTF_VARCHAR2_TABLE_100
267: , a14 out nocopy JTF_VARCHAR2_TABLE_100
268: , a15 out nocopy JTF_VARCHAR2_TABLE_100
269: , a16 out nocopy JTF_VARCHAR2_TABLE_100
270: , a17 out nocopy JTF_VARCHAR2_TABLE_100
271: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , a15 out nocopy JTF_VARCHAR2_TABLE_100

264: , a11 out nocopy JTF_VARCHAR2_TABLE_100
265: , a12 out nocopy JTF_VARCHAR2_TABLE_100
266: , a13 out nocopy JTF_VARCHAR2_TABLE_100
267: , a14 out nocopy JTF_VARCHAR2_TABLE_100
268: , a15 out nocopy JTF_VARCHAR2_TABLE_100
269: , a16 out nocopy JTF_VARCHAR2_TABLE_100
270: , a17 out nocopy JTF_VARCHAR2_TABLE_100
271: , a18 out nocopy JTF_VARCHAR2_TABLE_100
272: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 269: , a16 out nocopy JTF_VARCHAR2_TABLE_100

265: , a12 out nocopy JTF_VARCHAR2_TABLE_100
266: , a13 out nocopy JTF_VARCHAR2_TABLE_100
267: , a14 out nocopy JTF_VARCHAR2_TABLE_100
268: , a15 out nocopy JTF_VARCHAR2_TABLE_100
269: , a16 out nocopy JTF_VARCHAR2_TABLE_100
270: , a17 out nocopy JTF_VARCHAR2_TABLE_100
271: , a18 out nocopy JTF_VARCHAR2_TABLE_100
272: , a19 out nocopy JTF_VARCHAR2_TABLE_100
273: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 270: , a17 out nocopy JTF_VARCHAR2_TABLE_100

266: , a13 out nocopy JTF_VARCHAR2_TABLE_100
267: , a14 out nocopy JTF_VARCHAR2_TABLE_100
268: , a15 out nocopy JTF_VARCHAR2_TABLE_100
269: , a16 out nocopy JTF_VARCHAR2_TABLE_100
270: , a17 out nocopy JTF_VARCHAR2_TABLE_100
271: , a18 out nocopy JTF_VARCHAR2_TABLE_100
272: , a19 out nocopy JTF_VARCHAR2_TABLE_100
273: , a20 out nocopy JTF_VARCHAR2_TABLE_100
274: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 271: , a18 out nocopy JTF_VARCHAR2_TABLE_100

267: , a14 out nocopy JTF_VARCHAR2_TABLE_100
268: , a15 out nocopy JTF_VARCHAR2_TABLE_100
269: , a16 out nocopy JTF_VARCHAR2_TABLE_100
270: , a17 out nocopy JTF_VARCHAR2_TABLE_100
271: , a18 out nocopy JTF_VARCHAR2_TABLE_100
272: , a19 out nocopy JTF_VARCHAR2_TABLE_100
273: , a20 out nocopy JTF_VARCHAR2_TABLE_100
274: , a21 out nocopy JTF_VARCHAR2_TABLE_100
275: ) as

Line 272: , a19 out nocopy JTF_VARCHAR2_TABLE_100

268: , a15 out nocopy JTF_VARCHAR2_TABLE_100
269: , a16 out nocopy JTF_VARCHAR2_TABLE_100
270: , a17 out nocopy JTF_VARCHAR2_TABLE_100
271: , a18 out nocopy JTF_VARCHAR2_TABLE_100
272: , a19 out nocopy JTF_VARCHAR2_TABLE_100
273: , a20 out nocopy JTF_VARCHAR2_TABLE_100
274: , a21 out nocopy JTF_VARCHAR2_TABLE_100
275: ) as
276: ddindx binary_integer; indx binary_integer;

Line 273: , a20 out nocopy JTF_VARCHAR2_TABLE_100

269: , a16 out nocopy JTF_VARCHAR2_TABLE_100
270: , a17 out nocopy JTF_VARCHAR2_TABLE_100
271: , a18 out nocopy JTF_VARCHAR2_TABLE_100
272: , a19 out nocopy JTF_VARCHAR2_TABLE_100
273: , a20 out nocopy JTF_VARCHAR2_TABLE_100
274: , a21 out nocopy JTF_VARCHAR2_TABLE_100
275: ) as
276: ddindx binary_integer; indx binary_integer;
277: begin

Line 274: , a21 out nocopy JTF_VARCHAR2_TABLE_100

270: , a17 out nocopy JTF_VARCHAR2_TABLE_100
271: , a18 out nocopy JTF_VARCHAR2_TABLE_100
272: , a19 out nocopy JTF_VARCHAR2_TABLE_100
273: , a20 out nocopy JTF_VARCHAR2_TABLE_100
274: , a21 out nocopy JTF_VARCHAR2_TABLE_100
275: ) as
276: ddindx binary_integer; indx binary_integer;
277: begin
278: if t is null or t.count = 0 then

Line 280: a1 := JTF_VARCHAR2_TABLE_100();

276: ddindx binary_integer; indx binary_integer;
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();

Line 282: a3 := JTF_VARCHAR2_TABLE_100();

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();
286: a7 := JTF_VARCHAR2_TABLE_100();

Line 283: a4 := JTF_VARCHAR2_TABLE_100();

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();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();

Line 285: a6 := 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();
289: a10 := JTF_VARCHAR2_TABLE_100();

Line 286: a7 := JTF_VARCHAR2_TABLE_100();

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();
289: a10 := JTF_VARCHAR2_TABLE_100();
290: a11 := JTF_VARCHAR2_TABLE_100();

Line 287: a8 := 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();
289: a10 := JTF_VARCHAR2_TABLE_100();
290: a11 := JTF_VARCHAR2_TABLE_100();
291: a12 := JTF_VARCHAR2_TABLE_100();

Line 288: a9 := 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();
289: a10 := JTF_VARCHAR2_TABLE_100();
290: a11 := JTF_VARCHAR2_TABLE_100();
291: a12 := JTF_VARCHAR2_TABLE_100();
292: a13 := JTF_VARCHAR2_TABLE_100();

Line 289: a10 := JTF_VARCHAR2_TABLE_100();

285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: a10 := JTF_VARCHAR2_TABLE_100();
290: a11 := JTF_VARCHAR2_TABLE_100();
291: a12 := JTF_VARCHAR2_TABLE_100();
292: a13 := JTF_VARCHAR2_TABLE_100();
293: a14 := JTF_VARCHAR2_TABLE_100();

Line 290: a11 := JTF_VARCHAR2_TABLE_100();

286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: a10 := JTF_VARCHAR2_TABLE_100();
290: a11 := JTF_VARCHAR2_TABLE_100();
291: a12 := JTF_VARCHAR2_TABLE_100();
292: a13 := JTF_VARCHAR2_TABLE_100();
293: a14 := JTF_VARCHAR2_TABLE_100();
294: a15 := JTF_VARCHAR2_TABLE_100();

Line 291: a12 := JTF_VARCHAR2_TABLE_100();

287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: a10 := JTF_VARCHAR2_TABLE_100();
290: a11 := JTF_VARCHAR2_TABLE_100();
291: a12 := JTF_VARCHAR2_TABLE_100();
292: a13 := JTF_VARCHAR2_TABLE_100();
293: a14 := JTF_VARCHAR2_TABLE_100();
294: a15 := JTF_VARCHAR2_TABLE_100();
295: a16 := JTF_VARCHAR2_TABLE_100();

Line 292: a13 := JTF_VARCHAR2_TABLE_100();

288: a9 := JTF_VARCHAR2_TABLE_100();
289: a10 := JTF_VARCHAR2_TABLE_100();
290: a11 := JTF_VARCHAR2_TABLE_100();
291: a12 := JTF_VARCHAR2_TABLE_100();
292: a13 := JTF_VARCHAR2_TABLE_100();
293: a14 := JTF_VARCHAR2_TABLE_100();
294: a15 := JTF_VARCHAR2_TABLE_100();
295: a16 := JTF_VARCHAR2_TABLE_100();
296: a17 := JTF_VARCHAR2_TABLE_100();

Line 293: a14 := JTF_VARCHAR2_TABLE_100();

289: a10 := JTF_VARCHAR2_TABLE_100();
290: a11 := JTF_VARCHAR2_TABLE_100();
291: a12 := JTF_VARCHAR2_TABLE_100();
292: a13 := JTF_VARCHAR2_TABLE_100();
293: a14 := JTF_VARCHAR2_TABLE_100();
294: a15 := JTF_VARCHAR2_TABLE_100();
295: a16 := JTF_VARCHAR2_TABLE_100();
296: a17 := JTF_VARCHAR2_TABLE_100();
297: a18 := JTF_VARCHAR2_TABLE_100();

Line 294: a15 := JTF_VARCHAR2_TABLE_100();

290: a11 := JTF_VARCHAR2_TABLE_100();
291: a12 := JTF_VARCHAR2_TABLE_100();
292: a13 := JTF_VARCHAR2_TABLE_100();
293: a14 := JTF_VARCHAR2_TABLE_100();
294: a15 := JTF_VARCHAR2_TABLE_100();
295: a16 := JTF_VARCHAR2_TABLE_100();
296: a17 := JTF_VARCHAR2_TABLE_100();
297: a18 := JTF_VARCHAR2_TABLE_100();
298: a19 := JTF_VARCHAR2_TABLE_100();

Line 295: a16 := JTF_VARCHAR2_TABLE_100();

291: a12 := JTF_VARCHAR2_TABLE_100();
292: a13 := JTF_VARCHAR2_TABLE_100();
293: a14 := JTF_VARCHAR2_TABLE_100();
294: a15 := JTF_VARCHAR2_TABLE_100();
295: a16 := JTF_VARCHAR2_TABLE_100();
296: a17 := JTF_VARCHAR2_TABLE_100();
297: a18 := JTF_VARCHAR2_TABLE_100();
298: a19 := JTF_VARCHAR2_TABLE_100();
299: a20 := JTF_VARCHAR2_TABLE_100();

Line 296: a17 := JTF_VARCHAR2_TABLE_100();

292: a13 := JTF_VARCHAR2_TABLE_100();
293: a14 := JTF_VARCHAR2_TABLE_100();
294: a15 := JTF_VARCHAR2_TABLE_100();
295: a16 := JTF_VARCHAR2_TABLE_100();
296: a17 := JTF_VARCHAR2_TABLE_100();
297: a18 := JTF_VARCHAR2_TABLE_100();
298: a19 := JTF_VARCHAR2_TABLE_100();
299: a20 := JTF_VARCHAR2_TABLE_100();
300: a21 := JTF_VARCHAR2_TABLE_100();

Line 297: a18 := JTF_VARCHAR2_TABLE_100();

293: a14 := JTF_VARCHAR2_TABLE_100();
294: a15 := JTF_VARCHAR2_TABLE_100();
295: a16 := JTF_VARCHAR2_TABLE_100();
296: a17 := JTF_VARCHAR2_TABLE_100();
297: a18 := JTF_VARCHAR2_TABLE_100();
298: a19 := JTF_VARCHAR2_TABLE_100();
299: a20 := JTF_VARCHAR2_TABLE_100();
300: a21 := JTF_VARCHAR2_TABLE_100();
301: else

Line 298: a19 := JTF_VARCHAR2_TABLE_100();

294: a15 := JTF_VARCHAR2_TABLE_100();
295: a16 := JTF_VARCHAR2_TABLE_100();
296: a17 := JTF_VARCHAR2_TABLE_100();
297: a18 := JTF_VARCHAR2_TABLE_100();
298: a19 := JTF_VARCHAR2_TABLE_100();
299: a20 := JTF_VARCHAR2_TABLE_100();
300: a21 := JTF_VARCHAR2_TABLE_100();
301: else
302: a0 := JTF_VARCHAR2_TABLE_300();

Line 299: a20 := JTF_VARCHAR2_TABLE_100();

295: a16 := JTF_VARCHAR2_TABLE_100();
296: a17 := JTF_VARCHAR2_TABLE_100();
297: a18 := JTF_VARCHAR2_TABLE_100();
298: a19 := JTF_VARCHAR2_TABLE_100();
299: a20 := JTF_VARCHAR2_TABLE_100();
300: a21 := JTF_VARCHAR2_TABLE_100();
301: else
302: a0 := JTF_VARCHAR2_TABLE_300();
303: a1 := JTF_VARCHAR2_TABLE_100();

Line 300: a21 := JTF_VARCHAR2_TABLE_100();

296: a17 := JTF_VARCHAR2_TABLE_100();
297: a18 := JTF_VARCHAR2_TABLE_100();
298: a19 := JTF_VARCHAR2_TABLE_100();
299: a20 := JTF_VARCHAR2_TABLE_100();
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();

Line 303: a1 := JTF_VARCHAR2_TABLE_100();

299: a20 := JTF_VARCHAR2_TABLE_100();
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();

Line 305: a3 := 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();
309: a7 := JTF_VARCHAR2_TABLE_100();

Line 306: a4 := JTF_VARCHAR2_TABLE_100();

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();
309: a7 := JTF_VARCHAR2_TABLE_100();
310: a8 := JTF_VARCHAR2_TABLE_100();

Line 308: a6 := 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();
312: a10 := JTF_VARCHAR2_TABLE_100();

Line 309: a7 := JTF_VARCHAR2_TABLE_100();

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();
312: a10 := JTF_VARCHAR2_TABLE_100();
313: a11 := JTF_VARCHAR2_TABLE_100();

Line 310: a8 := 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();
312: a10 := JTF_VARCHAR2_TABLE_100();
313: a11 := JTF_VARCHAR2_TABLE_100();
314: a12 := JTF_VARCHAR2_TABLE_100();

Line 311: a9 := 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();
312: a10 := JTF_VARCHAR2_TABLE_100();
313: a11 := JTF_VARCHAR2_TABLE_100();
314: a12 := JTF_VARCHAR2_TABLE_100();
315: a13 := JTF_VARCHAR2_TABLE_100();

Line 312: a10 := JTF_VARCHAR2_TABLE_100();

308: a6 := JTF_VARCHAR2_TABLE_100();
309: a7 := JTF_VARCHAR2_TABLE_100();
310: a8 := JTF_VARCHAR2_TABLE_100();
311: a9 := JTF_VARCHAR2_TABLE_100();
312: a10 := JTF_VARCHAR2_TABLE_100();
313: a11 := JTF_VARCHAR2_TABLE_100();
314: a12 := JTF_VARCHAR2_TABLE_100();
315: a13 := JTF_VARCHAR2_TABLE_100();
316: a14 := JTF_VARCHAR2_TABLE_100();

Line 313: a11 := JTF_VARCHAR2_TABLE_100();

309: a7 := JTF_VARCHAR2_TABLE_100();
310: a8 := JTF_VARCHAR2_TABLE_100();
311: a9 := JTF_VARCHAR2_TABLE_100();
312: a10 := JTF_VARCHAR2_TABLE_100();
313: a11 := JTF_VARCHAR2_TABLE_100();
314: a12 := JTF_VARCHAR2_TABLE_100();
315: a13 := JTF_VARCHAR2_TABLE_100();
316: a14 := JTF_VARCHAR2_TABLE_100();
317: a15 := JTF_VARCHAR2_TABLE_100();

Line 314: a12 := JTF_VARCHAR2_TABLE_100();

310: a8 := JTF_VARCHAR2_TABLE_100();
311: a9 := JTF_VARCHAR2_TABLE_100();
312: a10 := JTF_VARCHAR2_TABLE_100();
313: a11 := JTF_VARCHAR2_TABLE_100();
314: a12 := JTF_VARCHAR2_TABLE_100();
315: a13 := JTF_VARCHAR2_TABLE_100();
316: a14 := JTF_VARCHAR2_TABLE_100();
317: a15 := JTF_VARCHAR2_TABLE_100();
318: a16 := JTF_VARCHAR2_TABLE_100();

Line 315: a13 := JTF_VARCHAR2_TABLE_100();

311: a9 := JTF_VARCHAR2_TABLE_100();
312: a10 := JTF_VARCHAR2_TABLE_100();
313: a11 := JTF_VARCHAR2_TABLE_100();
314: a12 := JTF_VARCHAR2_TABLE_100();
315: a13 := JTF_VARCHAR2_TABLE_100();
316: a14 := JTF_VARCHAR2_TABLE_100();
317: a15 := JTF_VARCHAR2_TABLE_100();
318: a16 := JTF_VARCHAR2_TABLE_100();
319: a17 := JTF_VARCHAR2_TABLE_100();

Line 316: a14 := JTF_VARCHAR2_TABLE_100();

312: a10 := JTF_VARCHAR2_TABLE_100();
313: a11 := JTF_VARCHAR2_TABLE_100();
314: a12 := JTF_VARCHAR2_TABLE_100();
315: a13 := JTF_VARCHAR2_TABLE_100();
316: a14 := JTF_VARCHAR2_TABLE_100();
317: a15 := JTF_VARCHAR2_TABLE_100();
318: a16 := JTF_VARCHAR2_TABLE_100();
319: a17 := JTF_VARCHAR2_TABLE_100();
320: a18 := JTF_VARCHAR2_TABLE_100();

Line 317: a15 := JTF_VARCHAR2_TABLE_100();

313: a11 := JTF_VARCHAR2_TABLE_100();
314: a12 := JTF_VARCHAR2_TABLE_100();
315: a13 := JTF_VARCHAR2_TABLE_100();
316: a14 := JTF_VARCHAR2_TABLE_100();
317: a15 := JTF_VARCHAR2_TABLE_100();
318: a16 := JTF_VARCHAR2_TABLE_100();
319: a17 := JTF_VARCHAR2_TABLE_100();
320: a18 := JTF_VARCHAR2_TABLE_100();
321: a19 := JTF_VARCHAR2_TABLE_100();

Line 318: a16 := JTF_VARCHAR2_TABLE_100();

314: a12 := JTF_VARCHAR2_TABLE_100();
315: a13 := JTF_VARCHAR2_TABLE_100();
316: a14 := JTF_VARCHAR2_TABLE_100();
317: a15 := JTF_VARCHAR2_TABLE_100();
318: a16 := JTF_VARCHAR2_TABLE_100();
319: a17 := JTF_VARCHAR2_TABLE_100();
320: a18 := JTF_VARCHAR2_TABLE_100();
321: a19 := JTF_VARCHAR2_TABLE_100();
322: a20 := JTF_VARCHAR2_TABLE_100();

Line 319: a17 := JTF_VARCHAR2_TABLE_100();

315: a13 := JTF_VARCHAR2_TABLE_100();
316: a14 := JTF_VARCHAR2_TABLE_100();
317: a15 := JTF_VARCHAR2_TABLE_100();
318: a16 := JTF_VARCHAR2_TABLE_100();
319: a17 := JTF_VARCHAR2_TABLE_100();
320: a18 := JTF_VARCHAR2_TABLE_100();
321: a19 := JTF_VARCHAR2_TABLE_100();
322: a20 := JTF_VARCHAR2_TABLE_100();
323: a21 := JTF_VARCHAR2_TABLE_100();

Line 320: a18 := JTF_VARCHAR2_TABLE_100();

316: a14 := JTF_VARCHAR2_TABLE_100();
317: a15 := JTF_VARCHAR2_TABLE_100();
318: a16 := JTF_VARCHAR2_TABLE_100();
319: a17 := JTF_VARCHAR2_TABLE_100();
320: a18 := JTF_VARCHAR2_TABLE_100();
321: a19 := JTF_VARCHAR2_TABLE_100();
322: a20 := JTF_VARCHAR2_TABLE_100();
323: a21 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then

Line 321: a19 := JTF_VARCHAR2_TABLE_100();

317: a15 := JTF_VARCHAR2_TABLE_100();
318: a16 := JTF_VARCHAR2_TABLE_100();
319: a17 := JTF_VARCHAR2_TABLE_100();
320: a18 := JTF_VARCHAR2_TABLE_100();
321: a19 := JTF_VARCHAR2_TABLE_100();
322: a20 := JTF_VARCHAR2_TABLE_100();
323: a21 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
325: a0.extend(t.count);

Line 322: a20 := JTF_VARCHAR2_TABLE_100();

318: a16 := JTF_VARCHAR2_TABLE_100();
319: a17 := JTF_VARCHAR2_TABLE_100();
320: a18 := JTF_VARCHAR2_TABLE_100();
321: a19 := JTF_VARCHAR2_TABLE_100();
322: a20 := JTF_VARCHAR2_TABLE_100();
323: a21 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
325: a0.extend(t.count);
326: a1.extend(t.count);

Line 323: a21 := JTF_VARCHAR2_TABLE_100();

319: a17 := JTF_VARCHAR2_TABLE_100();
320: a18 := JTF_VARCHAR2_TABLE_100();
321: a19 := JTF_VARCHAR2_TABLE_100();
322: a20 := JTF_VARCHAR2_TABLE_100();
323: a21 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
325: a0.extend(t.count);
326: a1.extend(t.count);
327: a2.extend(t.count);

Line 433: , a1 JTF_VARCHAR2_TABLE_100

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
437: , a5 JTF_VARCHAR2_TABLE_100

Line 434: , a2 JTF_VARCHAR2_TABLE_100

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
437: , a5 JTF_VARCHAR2_TABLE_100
438: , a6 JTF_VARCHAR2_TABLE_100

Line 436: , a4 JTF_VARCHAR2_TABLE_100

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
440: , a8 JTF_VARCHAR2_TABLE_100

Line 437: , a5 JTF_VARCHAR2_TABLE_100

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
440: , a8 JTF_VARCHAR2_TABLE_100
441: , a9 JTF_VARCHAR2_TABLE_100

Line 438: , a6 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
440: , a8 JTF_VARCHAR2_TABLE_100
441: , a9 JTF_VARCHAR2_TABLE_100
442: , a10 JTF_DATE_TABLE

Line 440: , a8 JTF_VARCHAR2_TABLE_100

436: , a4 JTF_VARCHAR2_TABLE_100
437: , a5 JTF_VARCHAR2_TABLE_100
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

Line 441: , a9 JTF_VARCHAR2_TABLE_100

437: , a5 JTF_VARCHAR2_TABLE_100
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

Line 476: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
480: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 477: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
480: , a5 out nocopy JTF_VARCHAR2_TABLE_100
481: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 479: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
483: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 480: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
483: , a8 out nocopy JTF_VARCHAR2_TABLE_100
484: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 481: , a6 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
483: , a8 out nocopy JTF_VARCHAR2_TABLE_100
484: , a9 out nocopy JTF_VARCHAR2_TABLE_100
485: , a10 out nocopy JTF_DATE_TABLE

Line 483: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 484: , a9 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
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

Line 493: a1 := JTF_VARCHAR2_TABLE_100();

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();
497: a5 := JTF_VARCHAR2_TABLE_100();

Line 494: a2 := JTF_VARCHAR2_TABLE_100();

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();
497: a5 := JTF_VARCHAR2_TABLE_100();
498: a6 := JTF_VARCHAR2_TABLE_100();

Line 496: a4 := JTF_VARCHAR2_TABLE_100();

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();
500: a8 := JTF_VARCHAR2_TABLE_100();

Line 497: a5 := JTF_VARCHAR2_TABLE_100();

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();
500: a8 := JTF_VARCHAR2_TABLE_100();
501: a9 := JTF_VARCHAR2_TABLE_100();

Line 498: a6 := 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();
500: a8 := JTF_VARCHAR2_TABLE_100();
501: a9 := JTF_VARCHAR2_TABLE_100();
502: a10 := JTF_DATE_TABLE();

Line 500: a8 := JTF_VARCHAR2_TABLE_100();

496: a4 := JTF_VARCHAR2_TABLE_100();
497: a5 := JTF_VARCHAR2_TABLE_100();
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();

Line 501: a9 := JTF_VARCHAR2_TABLE_100();

497: a5 := JTF_VARCHAR2_TABLE_100();
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

Line 507: a1 := JTF_VARCHAR2_TABLE_100();

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();
511: a5 := JTF_VARCHAR2_TABLE_100();

Line 508: a2 := JTF_VARCHAR2_TABLE_100();

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();
511: a5 := JTF_VARCHAR2_TABLE_100();
512: a6 := JTF_VARCHAR2_TABLE_100();

Line 510: a4 := JTF_VARCHAR2_TABLE_100();

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();
514: a8 := JTF_VARCHAR2_TABLE_100();

Line 511: a5 := JTF_VARCHAR2_TABLE_100();

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();
514: a8 := JTF_VARCHAR2_TABLE_100();
515: a9 := JTF_VARCHAR2_TABLE_100();

Line 512: a6 := 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();
514: a8 := JTF_VARCHAR2_TABLE_100();
515: a9 := JTF_VARCHAR2_TABLE_100();
516: a10 := JTF_DATE_TABLE();

Line 514: a8 := JTF_VARCHAR2_TABLE_100();

510: a4 := JTF_VARCHAR2_TABLE_100();
511: a5 := 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();

Line 515: a9 := JTF_VARCHAR2_TABLE_100();

511: a5 := 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

Line 620: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

616: , p5_a17 DATE
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

Line 622: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
626: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 623: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
626: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 625: , p6_a6 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
629: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 626: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

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
629: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
630: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 627: , p6_a8 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
629: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
630: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 628: , p6_a9 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
629: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
630: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
632: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 629: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

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
629: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
630: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
632: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 630: , p6_a11 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
629: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
630: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
632: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 631: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

627: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
628: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
629: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
630: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
632: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 632: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

628: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
629: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
630: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
632: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

629: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
630: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
632: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 634: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

630: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
632: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
638: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 635: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

631: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
632: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
638: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
639: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

632: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
638: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
639: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
640: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

633: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
638: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
639: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
640: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
641: , p7_a0 out nocopy VARCHAR2

Line 638: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

634: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
638: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
639: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
640: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
641: , p7_a0 out nocopy VARCHAR2
642: , p7_a1 out nocopy DATE

Line 639: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

635: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
638: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
639: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
640: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
641: , p7_a0 out nocopy VARCHAR2
642: , p7_a1 out nocopy DATE
643: , p7_a2 out nocopy DATE

Line 640: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

636: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
638: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
639: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
640: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
641: , p7_a0 out nocopy VARCHAR2
642: , p7_a1 out nocopy DATE
643: , p7_a2 out nocopy DATE
644: , p7_a3 out nocopy VARCHAR2

Line 848: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
852: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 849: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
852: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 851: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 852: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 853: , p6_a6 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
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

Line 855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 856: , p6_a9 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
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