DBA Data[Home] [Help]

APPS.JTF_CAL_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_pvt.callsttbltype, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_400
19: , a3 JTF_VARCHAR2_TABLE_100
20: ) as

Line 41: procedure rosetta_table_copy_out_p1(t jtf_cal_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE

37: end loop;
38: end if;
39: end if;
40: end rosetta_table_copy_in_p1;
41: procedure rosetta_table_copy_out_p1(t jtf_cal_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_VARCHAR2_TABLE_400
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: ) as

Line 49: a0 := JTF_NUMBER_TABLE();

45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_400();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: else

Line 54: a0 := JTF_NUMBER_TABLE();

50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_400();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_VARCHAR2_TABLE_100();
56: a2 := JTF_VARCHAR2_TABLE_400();
57: a3 := JTF_VARCHAR2_TABLE_100();
58: if t.count > 0 then

Line 80: procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_pvt.weektimepreftbltype, a0 JTF_NUMBER_TABLE

76: end if;
77: end if;
78: end rosetta_table_copy_out_p1;
79:
80: procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_pvt.weektimepreftbltype, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: ) as
83: ddindx binary_integer; indx binary_integer;
84: begin

Line 81: , a1 JTF_NUMBER_TABLE

77: end if;
78: end rosetta_table_copy_out_p1;
79:
80: procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_pvt.weektimepreftbltype, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: ) as
83: ddindx binary_integer; indx binary_integer;
84: begin
85: if a0 is not null and a0.count > 0 then

Line 101: procedure rosetta_table_copy_out_p3(t jtf_cal_pvt.weektimepreftbltype, a0 out nocopy JTF_NUMBER_TABLE

97: end loop;
98: end if;
99: end if;
100: end rosetta_table_copy_in_p3;
101: procedure rosetta_table_copy_out_p3(t jtf_cal_pvt.weektimepreftbltype, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: ) as
104: ddindx binary_integer; indx binary_integer;
105: begin

Line 102: , a1 out nocopy JTF_NUMBER_TABLE

98: end if;
99: end if;
100: end rosetta_table_copy_in_p3;
101: procedure rosetta_table_copy_out_p3(t jtf_cal_pvt.weektimepreftbltype, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: ) as
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then

Line 107: a0 := JTF_NUMBER_TABLE();

103: ) as
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_NUMBER_TABLE();
109: else
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_NUMBER_TABLE();

Line 108: a1 := JTF_NUMBER_TABLE();

104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_NUMBER_TABLE();
109: else
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_NUMBER_TABLE();
112: if t.count > 0 then

Line 110: a0 := JTF_NUMBER_TABLE();

106: if t is null or t.count = 0 then
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_NUMBER_TABLE();
109: else
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_NUMBER_TABLE();
112: if t.count > 0 then
113: a0.extend(t.count);
114: a1.extend(t.count);

Line 111: a1 := JTF_NUMBER_TABLE();

107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_NUMBER_TABLE();
109: else
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_NUMBER_TABLE();
112: if t.count > 0 then
113: a0.extend(t.count);
114: a1.extend(t.count);
115: ddindx := t.first;

Line 130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE

126: end if;
127: end if;
128: end rosetta_table_copy_out_p3;
129:
130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE

Line 131: , a1 JTF_NUMBER_TABLE

127: end if;
128: end rosetta_table_copy_out_p3;
129:
130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE

Line 134: , a4 JTF_NUMBER_TABLE

130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100

Line 135: , a5 JTF_NUMBER_TABLE

131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100
139: , a9 JTF_NUMBER_TABLE

Line 137: , a7 JTF_NUMBER_TABLE

133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100
139: , a9 JTF_NUMBER_TABLE
140: , a10 JTF_NUMBER_TABLE
141: , a11 JTF_DATE_TABLE

Line 139: , a9 JTF_NUMBER_TABLE

135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100
139: , a9 JTF_NUMBER_TABLE
140: , a10 JTF_NUMBER_TABLE
141: , a11 JTF_DATE_TABLE
142: , a12 JTF_DATE_TABLE
143: , a13 JTF_VARCHAR2_TABLE_2000

Line 140: , a10 JTF_NUMBER_TABLE

136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100
139: , a9 JTF_NUMBER_TABLE
140: , a10 JTF_NUMBER_TABLE
141: , a11 JTF_DATE_TABLE
142: , a12 JTF_DATE_TABLE
143: , a13 JTF_VARCHAR2_TABLE_2000
144: , a14 JTF_VARCHAR2_TABLE_2000

Line 145: , a15 JTF_NUMBER_TABLE

141: , a11 JTF_DATE_TABLE
142: , a12 JTF_DATE_TABLE
143: , a13 JTF_VARCHAR2_TABLE_2000
144: , a14 JTF_VARCHAR2_TABLE_2000
145: , a15 JTF_NUMBER_TABLE
146: , a16 JTF_VARCHAR2_TABLE_100
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100

Line 147: , a17 JTF_NUMBER_TABLE

143: , a13 JTF_VARCHAR2_TABLE_2000
144: , a14 JTF_VARCHAR2_TABLE_2000
145: , a15 JTF_NUMBER_TABLE
146: , a16 JTF_VARCHAR2_TABLE_100
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
150: , a20 JTF_NUMBER_TABLE
151: , a21 JTF_NUMBER_TABLE

Line 150: , a20 JTF_NUMBER_TABLE

146: , a16 JTF_VARCHAR2_TABLE_100
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
150: , a20 JTF_NUMBER_TABLE
151: , a21 JTF_NUMBER_TABLE
152: , a22 JTF_NUMBER_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;

Line 151: , a21 JTF_NUMBER_TABLE

147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
150: , a20 JTF_NUMBER_TABLE
151: , a21 JTF_NUMBER_TABLE
152: , a22 JTF_NUMBER_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin

Line 152: , a22 JTF_NUMBER_TABLE

148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
150: , a20 JTF_NUMBER_TABLE
151: , a21 JTF_NUMBER_TABLE
152: , a22 JTF_NUMBER_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin
156: if a0 is not null and a0.count > 0 then

Line 193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE

189: end loop;
190: end if;
191: end if;
192: end rosetta_table_copy_in_p7;
193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE

Line 194: , a1 out nocopy JTF_NUMBER_TABLE

190: end if;
191: end if;
192: end rosetta_table_copy_in_p7;
193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE

Line 197: , a4 out nocopy JTF_NUMBER_TABLE

193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE
201: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 198: , a5 out nocopy JTF_NUMBER_TABLE

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

Line 200: , a7 out nocopy JTF_NUMBER_TABLE

196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE
201: , a8 out nocopy JTF_VARCHAR2_TABLE_100
202: , a9 out nocopy JTF_NUMBER_TABLE
203: , a10 out nocopy JTF_NUMBER_TABLE
204: , a11 out nocopy JTF_DATE_TABLE

Line 202: , a9 out nocopy JTF_NUMBER_TABLE

198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE
201: , a8 out nocopy JTF_VARCHAR2_TABLE_100
202: , a9 out nocopy JTF_NUMBER_TABLE
203: , a10 out nocopy JTF_NUMBER_TABLE
204: , a11 out nocopy JTF_DATE_TABLE
205: , a12 out nocopy JTF_DATE_TABLE
206: , a13 out nocopy JTF_VARCHAR2_TABLE_2000

Line 203: , a10 out nocopy JTF_NUMBER_TABLE

199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE
201: , a8 out nocopy JTF_VARCHAR2_TABLE_100
202: , a9 out nocopy JTF_NUMBER_TABLE
203: , a10 out nocopy JTF_NUMBER_TABLE
204: , a11 out nocopy JTF_DATE_TABLE
205: , a12 out nocopy JTF_DATE_TABLE
206: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
207: , a14 out nocopy JTF_VARCHAR2_TABLE_2000

Line 208: , a15 out nocopy JTF_NUMBER_TABLE

204: , a11 out nocopy JTF_DATE_TABLE
205: , a12 out nocopy JTF_DATE_TABLE
206: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
207: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
208: , a15 out nocopy JTF_NUMBER_TABLE
209: , a16 out nocopy JTF_VARCHAR2_TABLE_100
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 210: , a17 out nocopy JTF_NUMBER_TABLE

206: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
207: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
208: , a15 out nocopy JTF_NUMBER_TABLE
209: , a16 out nocopy JTF_VARCHAR2_TABLE_100
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
213: , a20 out nocopy JTF_NUMBER_TABLE
214: , a21 out nocopy JTF_NUMBER_TABLE

Line 213: , a20 out nocopy JTF_NUMBER_TABLE

209: , a16 out nocopy JTF_VARCHAR2_TABLE_100
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
213: , a20 out nocopy JTF_NUMBER_TABLE
214: , a21 out nocopy JTF_NUMBER_TABLE
215: , a22 out nocopy JTF_NUMBER_TABLE
216: ) as
217: ddindx binary_integer; indx binary_integer;

Line 214: , a21 out nocopy JTF_NUMBER_TABLE

210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
213: , a20 out nocopy JTF_NUMBER_TABLE
214: , a21 out nocopy JTF_NUMBER_TABLE
215: , a22 out nocopy JTF_NUMBER_TABLE
216: ) as
217: ddindx binary_integer; indx binary_integer;
218: begin

Line 215: , a22 out nocopy JTF_NUMBER_TABLE

211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
213: , a20 out nocopy JTF_NUMBER_TABLE
214: , a21 out nocopy JTF_NUMBER_TABLE
215: , a22 out nocopy JTF_NUMBER_TABLE
216: ) as
217: ddindx binary_integer; indx binary_integer;
218: begin
219: if t is null or t.count = 0 then

Line 220: a0 := JTF_NUMBER_TABLE();

216: ) as
217: ddindx binary_integer; indx binary_integer;
218: begin
219: if t is null or t.count = 0 then
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_100();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();

Line 221: a1 := JTF_NUMBER_TABLE();

217: ddindx binary_integer; indx binary_integer;
218: begin
219: if t is null or t.count = 0 then
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_100();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();

Line 224: a4 := JTF_NUMBER_TABLE();

220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_100();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();

Line 225: a5 := JTF_NUMBER_TABLE();

221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_100();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();
229: a9 := JTF_NUMBER_TABLE();

Line 227: a7 := JTF_NUMBER_TABLE();

223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_DATE_TABLE();

Line 229: a9 := JTF_NUMBER_TABLE();

225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_DATE_TABLE();
232: a12 := JTF_DATE_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();

Line 230: a10 := JTF_NUMBER_TABLE();

226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_DATE_TABLE();
232: a12 := JTF_DATE_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();

Line 235: a15 := JTF_NUMBER_TABLE();

231: a11 := JTF_DATE_TABLE();
232: a12 := JTF_DATE_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();
235: a15 := JTF_NUMBER_TABLE();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();

Line 237: a17 := JTF_NUMBER_TABLE();

233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();
235: a15 := JTF_NUMBER_TABLE();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();

Line 240: a20 := JTF_NUMBER_TABLE();

236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();

Line 241: a21 := JTF_NUMBER_TABLE();

237: a17 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();

Line 242: a22 := JTF_NUMBER_TABLE();

238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();

Line 244: a0 := JTF_NUMBER_TABLE();

240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();

Line 245: a1 := JTF_NUMBER_TABLE();

241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();

Line 248: a4 := JTF_NUMBER_TABLE();

244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();

Line 249: a5 := JTF_NUMBER_TABLE();

245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();

Line 251: a7 := JTF_NUMBER_TABLE();

247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_NUMBER_TABLE();
255: a11 := JTF_DATE_TABLE();

Line 253: a9 := JTF_NUMBER_TABLE();

249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_NUMBER_TABLE();
255: a11 := JTF_DATE_TABLE();
256: a12 := JTF_DATE_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_2000();

Line 254: a10 := JTF_NUMBER_TABLE();

250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_NUMBER_TABLE();
255: a11 := JTF_DATE_TABLE();
256: a12 := JTF_DATE_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_2000();
258: a14 := JTF_VARCHAR2_TABLE_2000();

Line 259: a15 := JTF_NUMBER_TABLE();

255: a11 := JTF_DATE_TABLE();
256: a12 := JTF_DATE_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_2000();
258: a14 := JTF_VARCHAR2_TABLE_2000();
259: a15 := JTF_NUMBER_TABLE();
260: a16 := JTF_VARCHAR2_TABLE_100();
261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();

Line 261: a17 := JTF_NUMBER_TABLE();

257: a13 := JTF_VARCHAR2_TABLE_2000();
258: a14 := JTF_VARCHAR2_TABLE_2000();
259: a15 := JTF_NUMBER_TABLE();
260: a16 := JTF_VARCHAR2_TABLE_100();
261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
264: a20 := JTF_NUMBER_TABLE();
265: a21 := JTF_NUMBER_TABLE();

Line 264: a20 := JTF_NUMBER_TABLE();

260: a16 := JTF_VARCHAR2_TABLE_100();
261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
264: a20 := JTF_NUMBER_TABLE();
265: a21 := JTF_NUMBER_TABLE();
266: a22 := JTF_NUMBER_TABLE();
267: if t.count > 0 then
268: a0.extend(t.count);

Line 265: a21 := JTF_NUMBER_TABLE();

261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
264: a20 := JTF_NUMBER_TABLE();
265: a21 := JTF_NUMBER_TABLE();
266: a22 := JTF_NUMBER_TABLE();
267: if t.count > 0 then
268: a0.extend(t.count);
269: a1.extend(t.count);

Line 266: a22 := JTF_NUMBER_TABLE();

262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
264: a20 := JTF_NUMBER_TABLE();
265: a21 := JTF_NUMBER_TABLE();
266: a22 := JTF_NUMBER_TABLE();
267: if t.count > 0 then
268: a0.extend(t.count);
269: a1.extend(t.count);
270: a2.extend(t.count);

Line 336: , p9_a0 out nocopy JTF_NUMBER_TABLE

332: , x_msg_data out nocopy VARCHAR2
333: , p_resourceid in out nocopy NUMBER
334: , p_resourcetype in out nocopy VARCHAR2
335: , p_userid NUMBER
336: , p9_a0 out nocopy JTF_NUMBER_TABLE
337: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
339: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
340: )

Line 400: , p7_a0 out nocopy JTF_NUMBER_TABLE

396: , p6_a3 NUMBER
397: , p6_a4 VARCHAR2
398: , p6_a5 DATE
399: , p6_a6 NUMBER
400: , p7_a0 out nocopy JTF_NUMBER_TABLE
401: , p7_a1 out nocopy JTF_NUMBER_TABLE
402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE

Line 401: , p7_a1 out nocopy JTF_NUMBER_TABLE

397: , p6_a4 VARCHAR2
398: , p6_a5 DATE
399: , p6_a6 NUMBER
400: , p7_a0 out nocopy JTF_NUMBER_TABLE
401: , p7_a1 out nocopy JTF_NUMBER_TABLE
402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 404: , p7_a4 out nocopy JTF_NUMBER_TABLE

400: , p7_a0 out nocopy JTF_NUMBER_TABLE
401: , p7_a1 out nocopy JTF_NUMBER_TABLE
402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 405: , p7_a5 out nocopy JTF_NUMBER_TABLE

401: , p7_a1 out nocopy JTF_NUMBER_TABLE
402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
409: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 407: , p7_a7 out nocopy JTF_NUMBER_TABLE

403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
409: , p7_a9 out nocopy JTF_NUMBER_TABLE
410: , p7_a10 out nocopy JTF_NUMBER_TABLE
411: , p7_a11 out nocopy JTF_DATE_TABLE

Line 409: , p7_a9 out nocopy JTF_NUMBER_TABLE

405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
409: , p7_a9 out nocopy JTF_NUMBER_TABLE
410: , p7_a10 out nocopy JTF_NUMBER_TABLE
411: , p7_a11 out nocopy JTF_DATE_TABLE
412: , p7_a12 out nocopy JTF_DATE_TABLE
413: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000

Line 410: , p7_a10 out nocopy JTF_NUMBER_TABLE

406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
409: , p7_a9 out nocopy JTF_NUMBER_TABLE
410: , p7_a10 out nocopy JTF_NUMBER_TABLE
411: , p7_a11 out nocopy JTF_DATE_TABLE
412: , p7_a12 out nocopy JTF_DATE_TABLE
413: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000

Line 415: , p7_a15 out nocopy JTF_NUMBER_TABLE

411: , p7_a11 out nocopy JTF_DATE_TABLE
412: , p7_a12 out nocopy JTF_DATE_TABLE
413: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a15 out nocopy JTF_NUMBER_TABLE
416: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
417: , p7_a17 out nocopy JTF_NUMBER_TABLE
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 417: , p7_a17 out nocopy JTF_NUMBER_TABLE

413: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a15 out nocopy JTF_NUMBER_TABLE
416: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
417: , p7_a17 out nocopy JTF_NUMBER_TABLE
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a20 out nocopy JTF_NUMBER_TABLE
421: , p7_a21 out nocopy JTF_NUMBER_TABLE

Line 420: , p7_a20 out nocopy JTF_NUMBER_TABLE

416: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
417: , p7_a17 out nocopy JTF_NUMBER_TABLE
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a20 out nocopy JTF_NUMBER_TABLE
421: , p7_a21 out nocopy JTF_NUMBER_TABLE
422: , p7_a22 out nocopy JTF_NUMBER_TABLE
423: , p8_a0 out nocopy NUMBER
424: , p8_a1 out nocopy VARCHAR2

Line 421: , p7_a21 out nocopy JTF_NUMBER_TABLE

417: , p7_a17 out nocopy JTF_NUMBER_TABLE
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a20 out nocopy JTF_NUMBER_TABLE
421: , p7_a21 out nocopy JTF_NUMBER_TABLE
422: , p7_a22 out nocopy JTF_NUMBER_TABLE
423: , p8_a0 out nocopy NUMBER
424: , p8_a1 out nocopy VARCHAR2
425: , p8_a2 out nocopy VARCHAR2

Line 422: , p7_a22 out nocopy JTF_NUMBER_TABLE

418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a20 out nocopy JTF_NUMBER_TABLE
421: , p7_a21 out nocopy JTF_NUMBER_TABLE
422: , p7_a22 out nocopy JTF_NUMBER_TABLE
423: , p8_a0 out nocopy NUMBER
424: , p8_a1 out nocopy VARCHAR2
425: , p8_a2 out nocopy VARCHAR2
426: , p8_a3 out nocopy VARCHAR2