eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_QUEUE_MANAGEMENT_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy iem_queue_management_pvt.message_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy iem_queue_management_pvt.message_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_VARCHAR2_TABLE_2000
17: , a4 JTF_VARCHAR2_TABLE_100

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy iem_queue_management_pvt.message_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_VARCHAR2_TABLE_2000
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_400

Line 20: , a7 JTF_NUMBER_TABLE

16: , a3 JTF_VARCHAR2_TABLE_2000
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_400
19: , a6 JTF_VARCHAR2_TABLE_500
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_DATE_TABLE
24: ) as

Line 21: , a8 JTF_NUMBER_TABLE

17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_400
19: , a6 JTF_VARCHAR2_TABLE_500
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_DATE_TABLE
24: ) as
25: ddindx binary_integer; indx binary_integer;

Line 52: procedure rosetta_table_copy_out_p1(t iem_queue_management_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE

48: end loop;
49: end if;
50: end if;
51: end rosetta_table_copy_in_p1;
52: procedure rosetta_table_copy_out_p1(t iem_queue_management_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE
54: , a2 out nocopy JTF_VARCHAR2_TABLE_300
55: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , a1 out nocopy JTF_NUMBER_TABLE

49: end if;
50: end if;
51: end rosetta_table_copy_in_p1;
52: procedure rosetta_table_copy_out_p1(t iem_queue_management_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE
54: , a2 out nocopy JTF_VARCHAR2_TABLE_300
55: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: , a5 out nocopy JTF_VARCHAR2_TABLE_400

Line 59: , a7 out nocopy JTF_NUMBER_TABLE

55: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: , a5 out nocopy JTF_VARCHAR2_TABLE_400
58: , a6 out nocopy JTF_VARCHAR2_TABLE_500
59: , a7 out nocopy JTF_NUMBER_TABLE
60: , a8 out nocopy JTF_NUMBER_TABLE
61: , a9 out nocopy JTF_VARCHAR2_TABLE_100
62: , a10 out nocopy JTF_DATE_TABLE
63: ) as

Line 60: , a8 out nocopy JTF_NUMBER_TABLE

56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: , a5 out nocopy JTF_VARCHAR2_TABLE_400
58: , a6 out nocopy JTF_VARCHAR2_TABLE_500
59: , a7 out nocopy JTF_NUMBER_TABLE
60: , a8 out nocopy JTF_NUMBER_TABLE
61: , a9 out nocopy JTF_VARCHAR2_TABLE_100
62: , a10 out nocopy JTF_DATE_TABLE
63: ) as
64: ddindx binary_integer; indx binary_integer;

Line 67: a0 := JTF_NUMBER_TABLE();

63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_VARCHAR2_TABLE_300();
70: a3 := JTF_VARCHAR2_TABLE_2000();
71: a4 := JTF_VARCHAR2_TABLE_100();

Line 68: a1 := JTF_NUMBER_TABLE();

64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_VARCHAR2_TABLE_300();
70: a3 := JTF_VARCHAR2_TABLE_2000();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_VARCHAR2_TABLE_400();

Line 74: a7 := JTF_NUMBER_TABLE();

70: a3 := JTF_VARCHAR2_TABLE_2000();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_VARCHAR2_TABLE_400();
73: a6 := JTF_VARCHAR2_TABLE_500();
74: a7 := JTF_NUMBER_TABLE();
75: a8 := JTF_NUMBER_TABLE();
76: a9 := JTF_VARCHAR2_TABLE_100();
77: a10 := JTF_DATE_TABLE();
78: else

Line 75: a8 := JTF_NUMBER_TABLE();

71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_VARCHAR2_TABLE_400();
73: a6 := JTF_VARCHAR2_TABLE_500();
74: a7 := JTF_NUMBER_TABLE();
75: a8 := JTF_NUMBER_TABLE();
76: a9 := JTF_VARCHAR2_TABLE_100();
77: a10 := JTF_DATE_TABLE();
78: else
79: a0 := JTF_NUMBER_TABLE();

Line 79: a0 := JTF_NUMBER_TABLE();

75: a8 := JTF_NUMBER_TABLE();
76: a9 := JTF_VARCHAR2_TABLE_100();
77: a10 := JTF_DATE_TABLE();
78: else
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_VARCHAR2_TABLE_300();
82: a3 := JTF_VARCHAR2_TABLE_2000();
83: a4 := JTF_VARCHAR2_TABLE_100();

Line 80: a1 := JTF_NUMBER_TABLE();

76: a9 := JTF_VARCHAR2_TABLE_100();
77: a10 := JTF_DATE_TABLE();
78: else
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_VARCHAR2_TABLE_300();
82: a3 := JTF_VARCHAR2_TABLE_2000();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_400();

Line 86: a7 := JTF_NUMBER_TABLE();

82: a3 := JTF_VARCHAR2_TABLE_2000();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_400();
85: a6 := JTF_VARCHAR2_TABLE_500();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_NUMBER_TABLE();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_DATE_TABLE();
90: if t.count > 0 then

Line 87: a8 := JTF_NUMBER_TABLE();

83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_400();
85: a6 := JTF_VARCHAR2_TABLE_500();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_NUMBER_TABLE();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_DATE_TABLE();
90: if t.count > 0 then
91: a0.extend(t.count);

Line 126: procedure rosetta_table_copy_in_p3(t out nocopy iem_queue_management_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE

122: end if;
123: end if;
124: end rosetta_table_copy_out_p1;
125:
126: procedure rosetta_table_copy_in_p3(t out nocopy iem_queue_management_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
127: , a1 JTF_NUMBER_TABLE
128: , a2 JTF_VARCHAR2_TABLE_300
129: , a3 JTF_VARCHAR2_TABLE_2000
130: , a4 JTF_VARCHAR2_TABLE_100

Line 127: , a1 JTF_NUMBER_TABLE

123: end if;
124: end rosetta_table_copy_out_p1;
125:
126: procedure rosetta_table_copy_in_p3(t out nocopy iem_queue_management_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
127: , a1 JTF_NUMBER_TABLE
128: , a2 JTF_VARCHAR2_TABLE_300
129: , a3 JTF_VARCHAR2_TABLE_2000
130: , a4 JTF_VARCHAR2_TABLE_100
131: , a5 JTF_VARCHAR2_TABLE_400

Line 134: , a8 JTF_NUMBER_TABLE

130: , a4 JTF_VARCHAR2_TABLE_100
131: , a5 JTF_VARCHAR2_TABLE_400
132: , a6 JTF_VARCHAR2_TABLE_500
133: , a7 JTF_VARCHAR2_TABLE_100
134: , a8 JTF_NUMBER_TABLE
135: , a9 JTF_VARCHAR2_TABLE_100
136: ) as
137: ddindx binary_integer; indx binary_integer;
138: begin

Line 163: procedure rosetta_table_copy_out_p3(t iem_queue_management_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE

159: end loop;
160: end if;
161: end if;
162: end rosetta_table_copy_in_p3;
163: procedure rosetta_table_copy_out_p3(t iem_queue_management_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
164: , a1 out nocopy JTF_NUMBER_TABLE
165: , a2 out nocopy JTF_VARCHAR2_TABLE_300
166: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
167: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 164: , a1 out nocopy JTF_NUMBER_TABLE

160: end if;
161: end if;
162: end rosetta_table_copy_in_p3;
163: procedure rosetta_table_copy_out_p3(t iem_queue_management_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
164: , a1 out nocopy JTF_NUMBER_TABLE
165: , a2 out nocopy JTF_VARCHAR2_TABLE_300
166: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
167: , a4 out nocopy JTF_VARCHAR2_TABLE_100
168: , a5 out nocopy JTF_VARCHAR2_TABLE_400

Line 171: , a8 out nocopy JTF_NUMBER_TABLE

167: , a4 out nocopy JTF_VARCHAR2_TABLE_100
168: , a5 out nocopy JTF_VARCHAR2_TABLE_400
169: , a6 out nocopy JTF_VARCHAR2_TABLE_500
170: , a7 out nocopy JTF_VARCHAR2_TABLE_100
171: , a8 out nocopy JTF_NUMBER_TABLE
172: , a9 out nocopy JTF_VARCHAR2_TABLE_100
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin

Line 177: a0 := JTF_NUMBER_TABLE();

173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_300();
180: a3 := JTF_VARCHAR2_TABLE_2000();
181: a4 := JTF_VARCHAR2_TABLE_100();

Line 178: a1 := JTF_NUMBER_TABLE();

174: ddindx binary_integer; indx binary_integer;
175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_300();
180: a3 := JTF_VARCHAR2_TABLE_2000();
181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_VARCHAR2_TABLE_400();

Line 185: a8 := JTF_NUMBER_TABLE();

181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_VARCHAR2_TABLE_400();
183: a6 := JTF_VARCHAR2_TABLE_500();
184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: else
188: a0 := JTF_NUMBER_TABLE();
189: a1 := JTF_NUMBER_TABLE();

Line 188: a0 := JTF_NUMBER_TABLE();

184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: else
188: a0 := JTF_NUMBER_TABLE();
189: a1 := JTF_NUMBER_TABLE();
190: a2 := JTF_VARCHAR2_TABLE_300();
191: a3 := JTF_VARCHAR2_TABLE_2000();
192: a4 := JTF_VARCHAR2_TABLE_100();

Line 189: a1 := JTF_NUMBER_TABLE();

185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: else
188: a0 := JTF_NUMBER_TABLE();
189: a1 := JTF_NUMBER_TABLE();
190: a2 := JTF_VARCHAR2_TABLE_300();
191: a3 := JTF_VARCHAR2_TABLE_2000();
192: a4 := JTF_VARCHAR2_TABLE_100();
193: a5 := JTF_VARCHAR2_TABLE_400();

Line 196: a8 := JTF_NUMBER_TABLE();

192: a4 := JTF_VARCHAR2_TABLE_100();
193: a5 := JTF_VARCHAR2_TABLE_400();
194: a6 := JTF_VARCHAR2_TABLE_500();
195: a7 := JTF_VARCHAR2_TABLE_100();
196: a8 := JTF_NUMBER_TABLE();
197: a9 := JTF_VARCHAR2_TABLE_100();
198: if t.count > 0 then
199: a0.extend(t.count);
200: a1.extend(t.count);

Line 232: procedure rosetta_table_copy_in_p5(t out nocopy iem_queue_management_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE

228: end if;
229: end if;
230: end rosetta_table_copy_out_p3;
231:
232: procedure rosetta_table_copy_in_p5(t out nocopy iem_queue_management_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
233: , a1 JTF_VARCHAR2_TABLE_200
234: , a2 JTF_NUMBER_TABLE
235: , a3 JTF_VARCHAR2_TABLE_500
236: ) as

Line 234: , a2 JTF_NUMBER_TABLE

230: end rosetta_table_copy_out_p3;
231:
232: procedure rosetta_table_copy_in_p5(t out nocopy iem_queue_management_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
233: , a1 JTF_VARCHAR2_TABLE_200
234: , a2 JTF_NUMBER_TABLE
235: , a3 JTF_VARCHAR2_TABLE_500
236: ) as
237: ddindx binary_integer; indx binary_integer;
238: begin

Line 257: procedure rosetta_table_copy_out_p5(t iem_queue_management_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

253: end loop;
254: end if;
255: end if;
256: end rosetta_table_copy_in_p5;
257: procedure rosetta_table_copy_out_p5(t iem_queue_management_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
258: , a1 out nocopy JTF_VARCHAR2_TABLE_200
259: , a2 out nocopy JTF_NUMBER_TABLE
260: , a3 out nocopy JTF_VARCHAR2_TABLE_500
261: ) as

Line 259: , a2 out nocopy JTF_NUMBER_TABLE

255: end if;
256: end rosetta_table_copy_in_p5;
257: procedure rosetta_table_copy_out_p5(t iem_queue_management_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
258: , a1 out nocopy JTF_VARCHAR2_TABLE_200
259: , a2 out nocopy JTF_NUMBER_TABLE
260: , a3 out nocopy JTF_VARCHAR2_TABLE_500
261: ) as
262: ddindx binary_integer; indx binary_integer;
263: begin

Line 265: a0 := JTF_NUMBER_TABLE();

261: ) as
262: ddindx binary_integer; indx binary_integer;
263: begin
264: if t is null or t.count = 0 then
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_VARCHAR2_TABLE_200();
267: a2 := JTF_NUMBER_TABLE();
268: a3 := JTF_VARCHAR2_TABLE_500();
269: else

Line 267: a2 := JTF_NUMBER_TABLE();

263: begin
264: if t is null or t.count = 0 then
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_VARCHAR2_TABLE_200();
267: a2 := JTF_NUMBER_TABLE();
268: a3 := JTF_VARCHAR2_TABLE_500();
269: else
270: a0 := JTF_NUMBER_TABLE();
271: a1 := JTF_VARCHAR2_TABLE_200();

Line 270: a0 := JTF_NUMBER_TABLE();

266: a1 := JTF_VARCHAR2_TABLE_200();
267: a2 := JTF_NUMBER_TABLE();
268: a3 := JTF_VARCHAR2_TABLE_500();
269: else
270: a0 := JTF_NUMBER_TABLE();
271: a1 := JTF_VARCHAR2_TABLE_200();
272: a2 := JTF_NUMBER_TABLE();
273: a3 := JTF_VARCHAR2_TABLE_500();
274: if t.count > 0 then

Line 272: a2 := JTF_NUMBER_TABLE();

268: a3 := JTF_VARCHAR2_TABLE_500();
269: else
270: a0 := JTF_NUMBER_TABLE();
271: a1 := JTF_VARCHAR2_TABLE_200();
272: a2 := JTF_NUMBER_TABLE();
273: a3 := JTF_VARCHAR2_TABLE_500();
274: if t.count > 0 then
275: a0.extend(t.count);
276: a1.extend(t.count);

Line 296: procedure rosetta_table_copy_in_p7(t out nocopy iem_queue_management_pvt.resource_group_count_tbl, a0 JTF_NUMBER_TABLE

292: end if;
293: end if;
294: end rosetta_table_copy_out_p5;
295:
296: procedure rosetta_table_copy_in_p7(t out nocopy iem_queue_management_pvt.resource_group_count_tbl, a0 JTF_NUMBER_TABLE
297: , a1 JTF_VARCHAR2_TABLE_200
298: , a2 JTF_NUMBER_TABLE
299: , a3 JTF_NUMBER_TABLE
300: ) as

Line 298: , a2 JTF_NUMBER_TABLE

294: end rosetta_table_copy_out_p5;
295:
296: procedure rosetta_table_copy_in_p7(t out nocopy iem_queue_management_pvt.resource_group_count_tbl, a0 JTF_NUMBER_TABLE
297: , a1 JTF_VARCHAR2_TABLE_200
298: , a2 JTF_NUMBER_TABLE
299: , a3 JTF_NUMBER_TABLE
300: ) as
301: ddindx binary_integer; indx binary_integer;
302: begin

Line 299: , a3 JTF_NUMBER_TABLE

295:
296: procedure rosetta_table_copy_in_p7(t out nocopy iem_queue_management_pvt.resource_group_count_tbl, a0 JTF_NUMBER_TABLE
297: , a1 JTF_VARCHAR2_TABLE_200
298: , a2 JTF_NUMBER_TABLE
299: , a3 JTF_NUMBER_TABLE
300: ) as
301: ddindx binary_integer; indx binary_integer;
302: begin
303: if a0 is not null and a0.count > 0 then

Line 321: procedure rosetta_table_copy_out_p7(t iem_queue_management_pvt.resource_group_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

317: end loop;
318: end if;
319: end if;
320: end rosetta_table_copy_in_p7;
321: procedure rosetta_table_copy_out_p7(t iem_queue_management_pvt.resource_group_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
322: , a1 out nocopy JTF_VARCHAR2_TABLE_200
323: , a2 out nocopy JTF_NUMBER_TABLE
324: , a3 out nocopy JTF_NUMBER_TABLE
325: ) as

Line 323: , a2 out nocopy JTF_NUMBER_TABLE

319: end if;
320: end rosetta_table_copy_in_p7;
321: procedure rosetta_table_copy_out_p7(t iem_queue_management_pvt.resource_group_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
322: , a1 out nocopy JTF_VARCHAR2_TABLE_200
323: , a2 out nocopy JTF_NUMBER_TABLE
324: , a3 out nocopy JTF_NUMBER_TABLE
325: ) as
326: ddindx binary_integer; indx binary_integer;
327: begin

Line 324: , a3 out nocopy JTF_NUMBER_TABLE

320: end rosetta_table_copy_in_p7;
321: procedure rosetta_table_copy_out_p7(t iem_queue_management_pvt.resource_group_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
322: , a1 out nocopy JTF_VARCHAR2_TABLE_200
323: , a2 out nocopy JTF_NUMBER_TABLE
324: , a3 out nocopy JTF_NUMBER_TABLE
325: ) as
326: ddindx binary_integer; indx binary_integer;
327: begin
328: if t is null or t.count = 0 then

Line 329: a0 := JTF_NUMBER_TABLE();

325: ) as
326: ddindx binary_integer; indx binary_integer;
327: begin
328: if t is null or t.count = 0 then
329: a0 := JTF_NUMBER_TABLE();
330: a1 := JTF_VARCHAR2_TABLE_200();
331: a2 := JTF_NUMBER_TABLE();
332: a3 := JTF_NUMBER_TABLE();
333: else

Line 331: a2 := JTF_NUMBER_TABLE();

327: begin
328: if t is null or t.count = 0 then
329: a0 := JTF_NUMBER_TABLE();
330: a1 := JTF_VARCHAR2_TABLE_200();
331: a2 := JTF_NUMBER_TABLE();
332: a3 := JTF_NUMBER_TABLE();
333: else
334: a0 := JTF_NUMBER_TABLE();
335: a1 := JTF_VARCHAR2_TABLE_200();

Line 332: a3 := JTF_NUMBER_TABLE();

328: if t is null or t.count = 0 then
329: a0 := JTF_NUMBER_TABLE();
330: a1 := JTF_VARCHAR2_TABLE_200();
331: a2 := JTF_NUMBER_TABLE();
332: a3 := JTF_NUMBER_TABLE();
333: else
334: a0 := JTF_NUMBER_TABLE();
335: a1 := JTF_VARCHAR2_TABLE_200();
336: a2 := JTF_NUMBER_TABLE();

Line 334: a0 := JTF_NUMBER_TABLE();

330: a1 := JTF_VARCHAR2_TABLE_200();
331: a2 := JTF_NUMBER_TABLE();
332: a3 := JTF_NUMBER_TABLE();
333: else
334: a0 := JTF_NUMBER_TABLE();
335: a1 := JTF_VARCHAR2_TABLE_200();
336: a2 := JTF_NUMBER_TABLE();
337: a3 := JTF_NUMBER_TABLE();
338: if t.count > 0 then

Line 336: a2 := JTF_NUMBER_TABLE();

332: a3 := JTF_NUMBER_TABLE();
333: else
334: a0 := JTF_NUMBER_TABLE();
335: a1 := JTF_VARCHAR2_TABLE_200();
336: a2 := JTF_NUMBER_TABLE();
337: a3 := JTF_NUMBER_TABLE();
338: if t.count > 0 then
339: a0.extend(t.count);
340: a1.extend(t.count);

Line 337: a3 := JTF_NUMBER_TABLE();

333: else
334: a0 := JTF_NUMBER_TABLE();
335: a1 := JTF_VARCHAR2_TABLE_200();
336: a2 := JTF_NUMBER_TABLE();
337: a3 := JTF_NUMBER_TABLE();
338: if t.count > 0 then
339: a0.extend(t.count);
340: a1.extend(t.count);
341: a2.extend(t.count);

Line 374: , p14_a0 out nocopy JTF_NUMBER_TABLE

370: , p_sent_date_format VARCHAR2
371: , p_group_id NUMBER
372: , p_sort_column NUMBER
373: , p_sort_state VARCHAR2
374: , p14_a0 out nocopy JTF_NUMBER_TABLE
375: , p14_a1 out nocopy JTF_NUMBER_TABLE
376: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_300
377: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_2000
378: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 375: , p14_a1 out nocopy JTF_NUMBER_TABLE

371: , p_group_id NUMBER
372: , p_sort_column NUMBER
373: , p_sort_state VARCHAR2
374: , p14_a0 out nocopy JTF_NUMBER_TABLE
375: , p14_a1 out nocopy JTF_NUMBER_TABLE
376: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_300
377: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_2000
378: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
379: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_400

Line 381: , p14_a7 out nocopy JTF_NUMBER_TABLE

377: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_2000
378: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
379: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_400
380: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_500
381: , p14_a7 out nocopy JTF_NUMBER_TABLE
382: , p14_a8 out nocopy JTF_NUMBER_TABLE
383: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
384: , p14_a10 out nocopy JTF_DATE_TABLE
385: , x_return_status out nocopy VARCHAR2

Line 382: , p14_a8 out nocopy JTF_NUMBER_TABLE

378: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
379: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_400
380: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_500
381: , p14_a7 out nocopy JTF_NUMBER_TABLE
382: , p14_a8 out nocopy JTF_NUMBER_TABLE
383: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
384: , p14_a10 out nocopy JTF_DATE_TABLE
385: , x_return_status out nocopy VARCHAR2
386: , x_msg_count out nocopy NUMBER

Line 472: , p6_a0 out nocopy JTF_NUMBER_TABLE

468: , p_commit VARCHAR2
469: , p_email_account_id NUMBER
470: , p_sort_column NUMBER
471: , p_sort_state VARCHAR2
472: , p6_a0 out nocopy JTF_NUMBER_TABLE
473: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
474: , p6_a2 out nocopy JTF_NUMBER_TABLE
475: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
476: , x_return_status out nocopy VARCHAR2

Line 474: , p6_a2 out nocopy JTF_NUMBER_TABLE

470: , p_sort_column NUMBER
471: , p_sort_state VARCHAR2
472: , p6_a0 out nocopy JTF_NUMBER_TABLE
473: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
474: , p6_a2 out nocopy JTF_NUMBER_TABLE
475: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
476: , x_return_status out nocopy VARCHAR2
477: , x_msg_count out nocopy NUMBER
478: , x_msg_data out nocopy VARCHAR2

Line 532: , p6_a0 out nocopy JTF_NUMBER_TABLE

528: , p_commit VARCHAR2
529: , p_email_account_id NUMBER
530: , p_sort_column NUMBER
531: , p_sort_state VARCHAR2
532: , p6_a0 out nocopy JTF_NUMBER_TABLE
533: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
534: , p6_a2 out nocopy JTF_NUMBER_TABLE
535: , p6_a3 out nocopy JTF_NUMBER_TABLE
536: , x_return_status out nocopy VARCHAR2

Line 534: , p6_a2 out nocopy JTF_NUMBER_TABLE

530: , p_sort_column NUMBER
531: , p_sort_state VARCHAR2
532: , p6_a0 out nocopy JTF_NUMBER_TABLE
533: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
534: , p6_a2 out nocopy JTF_NUMBER_TABLE
535: , p6_a3 out nocopy JTF_NUMBER_TABLE
536: , x_return_status out nocopy VARCHAR2
537: , x_msg_count out nocopy NUMBER
538: , x_msg_data out nocopy VARCHAR2

Line 535: , p6_a3 out nocopy JTF_NUMBER_TABLE

531: , p_sort_state VARCHAR2
532: , p6_a0 out nocopy JTF_NUMBER_TABLE
533: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
534: , p6_a2 out nocopy JTF_NUMBER_TABLE
535: , p6_a3 out nocopy JTF_NUMBER_TABLE
536: , x_return_status out nocopy VARCHAR2
537: , x_msg_count out nocopy NUMBER
538: , x_msg_data out nocopy VARCHAR2
539: )