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.JTF_PERZ_QUERY_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_parameter_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE

Line 25: , a3 JTF_VARCHAR2_TABLE_100

21:
22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_parameter_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: ) as

Line 27: , a5 JTF_VARCHAR2_TABLE_100

23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin

Line 55: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

51: end if;
52: end rosetta_table_copy_in_p1;
53: procedure rosetta_table_copy_out_p1(t jtf_perz_query_pub.query_parameter_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
54: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
55: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
56: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
58: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
59: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 56: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

52: end rosetta_table_copy_in_p1;
53: procedure rosetta_table_copy_out_p1(t jtf_perz_query_pub.query_parameter_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
54: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
55: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
56: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
58: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
59: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
60: ) as

Line 58: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

54: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
55: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
56: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
58: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
59: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin

Line 66: a2 := JTF_VARCHAR2_TABLE_100();

62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_300();
69: a5 := JTF_VARCHAR2_TABLE_100();
70: a6 := JTF_NUMBER_TABLE();

Line 67: a3 := JTF_VARCHAR2_TABLE_100();

63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_300();
69: a5 := JTF_VARCHAR2_TABLE_100();
70: a6 := JTF_NUMBER_TABLE();
71: else

Line 69: a5 := JTF_VARCHAR2_TABLE_100();

65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_300();
69: a5 := JTF_VARCHAR2_TABLE_100();
70: a6 := JTF_NUMBER_TABLE();
71: else
72: a0 := JTF_NUMBER_TABLE();
73: a1 := JTF_NUMBER_TABLE();

Line 74: a2 := JTF_VARCHAR2_TABLE_100();

70: a6 := JTF_NUMBER_TABLE();
71: else
72: a0 := JTF_NUMBER_TABLE();
73: a1 := JTF_NUMBER_TABLE();
74: a2 := JTF_VARCHAR2_TABLE_100();
75: a3 := JTF_VARCHAR2_TABLE_100();
76: a4 := JTF_VARCHAR2_TABLE_300();
77: a5 := JTF_VARCHAR2_TABLE_100();
78: a6 := JTF_NUMBER_TABLE();

Line 75: a3 := JTF_VARCHAR2_TABLE_100();

71: else
72: a0 := JTF_NUMBER_TABLE();
73: a1 := JTF_NUMBER_TABLE();
74: a2 := JTF_VARCHAR2_TABLE_100();
75: a3 := JTF_VARCHAR2_TABLE_100();
76: a4 := JTF_VARCHAR2_TABLE_300();
77: a5 := JTF_VARCHAR2_TABLE_100();
78: a6 := JTF_NUMBER_TABLE();
79: if t.count > 0 then

Line 77: a5 := JTF_VARCHAR2_TABLE_100();

73: a1 := JTF_NUMBER_TABLE();
74: a2 := JTF_VARCHAR2_TABLE_100();
75: a3 := JTF_VARCHAR2_TABLE_100();
76: a4 := JTF_VARCHAR2_TABLE_300();
77: a5 := JTF_VARCHAR2_TABLE_100();
78: a6 := JTF_NUMBER_TABLE();
79: if t.count > 0 then
80: a0.extend(t.count);
81: a1.extend(t.count);

Line 110: , a3 JTF_VARCHAR2_TABLE_100

106:
107: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_out_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_NUMBER_TABLE
110: , a3 JTF_VARCHAR2_TABLE_100
111: , a4 JTF_VARCHAR2_TABLE_100
112: , a5 JTF_VARCHAR2_TABLE_300
113: , a6 JTF_VARCHAR2_TABLE_2000
114: ) as

Line 111: , a4 JTF_VARCHAR2_TABLE_100

107: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_out_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_NUMBER_TABLE
110: , a3 JTF_VARCHAR2_TABLE_100
111: , a4 JTF_VARCHAR2_TABLE_100
112: , a5 JTF_VARCHAR2_TABLE_300
113: , a6 JTF_VARCHAR2_TABLE_2000
114: ) as
115: ddindx binary_integer; indx binary_integer;

Line 141: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

137: end rosetta_table_copy_in_p4;
138: procedure rosetta_table_copy_out_p4(t jtf_perz_query_pub.query_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
139: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
140: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
141: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
142: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
143: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
144: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
145: ) as

Line 142: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

138: procedure rosetta_table_copy_out_p4(t jtf_perz_query_pub.query_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
139: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
140: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
141: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
142: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
143: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
144: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
145: ) as
146: ddindx binary_integer; indx binary_integer;

Line 152: a3 := JTF_VARCHAR2_TABLE_100();

148: if t is null or t.count = 0 then
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_NUMBER_TABLE();
151: a2 := JTF_NUMBER_TABLE();
152: a3 := JTF_VARCHAR2_TABLE_100();
153: a4 := JTF_VARCHAR2_TABLE_100();
154: a5 := JTF_VARCHAR2_TABLE_300();
155: a6 := JTF_VARCHAR2_TABLE_2000();
156: else

Line 153: a4 := JTF_VARCHAR2_TABLE_100();

149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_NUMBER_TABLE();
151: a2 := JTF_NUMBER_TABLE();
152: a3 := JTF_VARCHAR2_TABLE_100();
153: a4 := JTF_VARCHAR2_TABLE_100();
154: a5 := JTF_VARCHAR2_TABLE_300();
155: a6 := JTF_VARCHAR2_TABLE_2000();
156: else
157: a0 := JTF_NUMBER_TABLE();

Line 160: a3 := JTF_VARCHAR2_TABLE_100();

156: else
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_NUMBER_TABLE();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_300();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: if t.count > 0 then

Line 161: a4 := JTF_VARCHAR2_TABLE_100();

157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_NUMBER_TABLE();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_300();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: if t.count > 0 then
165: a0.extend(t.count);

Line 194: , a2 JTF_VARCHAR2_TABLE_100

190: end rosetta_table_copy_out_p4;
191:
192: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_order_by_tbl_type, a0 JTF_NUMBER_TABLE
193: , a1 JTF_NUMBER_TABLE
194: , a2 JTF_VARCHAR2_TABLE_100
195: , a3 JTF_VARCHAR2_TABLE_100
196: , a4 JTF_NUMBER_TABLE
197: ) as
198: ddindx binary_integer; indx binary_integer;

Line 195: , a3 JTF_VARCHAR2_TABLE_100

191:
192: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_order_by_tbl_type, a0 JTF_NUMBER_TABLE
193: , a1 JTF_NUMBER_TABLE
194: , a2 JTF_VARCHAR2_TABLE_100
195: , a3 JTF_VARCHAR2_TABLE_100
196: , a4 JTF_NUMBER_TABLE
197: ) as
198: ddindx binary_integer; indx binary_integer;
199: begin

Line 221: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

217: end if;
218: end rosetta_table_copy_in_p6;
219: procedure rosetta_table_copy_out_p6(t jtf_perz_query_pub.query_order_by_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
220: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
221: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
222: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
224: ) as
225: ddindx binary_integer; indx binary_integer;

Line 222: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

218: end rosetta_table_copy_in_p6;
219: procedure rosetta_table_copy_out_p6(t jtf_perz_query_pub.query_order_by_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
220: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
221: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
222: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
224: ) as
225: ddindx binary_integer; indx binary_integer;
226: begin

Line 230: a2 := JTF_VARCHAR2_TABLE_100();

226: begin
227: if t is null or t.count = 0 then
228: a0 := JTF_NUMBER_TABLE();
229: a1 := JTF_NUMBER_TABLE();
230: a2 := JTF_VARCHAR2_TABLE_100();
231: a3 := JTF_VARCHAR2_TABLE_100();
232: a4 := JTF_NUMBER_TABLE();
233: else
234: a0 := JTF_NUMBER_TABLE();

Line 231: a3 := JTF_VARCHAR2_TABLE_100();

227: if t is null or t.count = 0 then
228: a0 := JTF_NUMBER_TABLE();
229: a1 := JTF_NUMBER_TABLE();
230: a2 := JTF_VARCHAR2_TABLE_100();
231: a3 := JTF_VARCHAR2_TABLE_100();
232: a4 := JTF_NUMBER_TABLE();
233: else
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();

Line 236: a2 := JTF_VARCHAR2_TABLE_100();

232: a4 := JTF_NUMBER_TABLE();
233: else
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();
236: a2 := JTF_VARCHAR2_TABLE_100();
237: a3 := JTF_VARCHAR2_TABLE_100();
238: a4 := JTF_NUMBER_TABLE();
239: if t.count > 0 then
240: a0.extend(t.count);

Line 237: a3 := JTF_VARCHAR2_TABLE_100();

233: else
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();
236: a2 := JTF_VARCHAR2_TABLE_100();
237: a3 := JTF_VARCHAR2_TABLE_100();
238: a4 := JTF_NUMBER_TABLE();
239: if t.count > 0 then
240: a0.extend(t.count);
241: a1.extend(t.count);

Line 272: , p7_a2 JTF_VARCHAR2_TABLE_100

268: , p_profile_name VARCHAR2
269: , p_profile_type VARCHAR2
270: , p7_a0 JTF_NUMBER_TABLE
271: , p7_a1 JTF_NUMBER_TABLE
272: , p7_a2 JTF_VARCHAR2_TABLE_100
273: , p7_a3 JTF_VARCHAR2_TABLE_100
274: , p7_a4 JTF_VARCHAR2_TABLE_100
275: , p_query_id NUMBER
276: , p_query_name VARCHAR2

Line 273: , p7_a3 JTF_VARCHAR2_TABLE_100

269: , p_profile_type VARCHAR2
270: , p7_a0 JTF_NUMBER_TABLE
271: , p7_a1 JTF_NUMBER_TABLE
272: , p7_a2 JTF_VARCHAR2_TABLE_100
273: , p7_a3 JTF_VARCHAR2_TABLE_100
274: , p7_a4 JTF_VARCHAR2_TABLE_100
275: , p_query_id NUMBER
276: , p_query_name VARCHAR2
277: , p_query_type VARCHAR2

Line 274: , p7_a4 JTF_VARCHAR2_TABLE_100

270: , p7_a0 JTF_NUMBER_TABLE
271: , p7_a1 JTF_NUMBER_TABLE
272: , p7_a2 JTF_VARCHAR2_TABLE_100
273: , p7_a3 JTF_VARCHAR2_TABLE_100
274: , p7_a4 JTF_VARCHAR2_TABLE_100
275: , p_query_id NUMBER
276: , p_query_name VARCHAR2
277: , p_query_type VARCHAR2
278: , p_query_desc VARCHAR2

Line 282: , p13_a2 JTF_VARCHAR2_TABLE_100

278: , p_query_desc VARCHAR2
279: , p_query_data_source VARCHAR2
280: , p13_a0 JTF_NUMBER_TABLE
281: , p13_a1 JTF_NUMBER_TABLE
282: , p13_a2 JTF_VARCHAR2_TABLE_100
283: , p13_a3 JTF_VARCHAR2_TABLE_100
284: , p13_a4 JTF_VARCHAR2_TABLE_300
285: , p13_a5 JTF_VARCHAR2_TABLE_100
286: , p13_a6 JTF_NUMBER_TABLE

Line 283: , p13_a3 JTF_VARCHAR2_TABLE_100

279: , p_query_data_source VARCHAR2
280: , p13_a0 JTF_NUMBER_TABLE
281: , p13_a1 JTF_NUMBER_TABLE
282: , p13_a2 JTF_VARCHAR2_TABLE_100
283: , p13_a3 JTF_VARCHAR2_TABLE_100
284: , p13_a4 JTF_VARCHAR2_TABLE_300
285: , p13_a5 JTF_VARCHAR2_TABLE_100
286: , p13_a6 JTF_NUMBER_TABLE
287: , p14_a0 JTF_NUMBER_TABLE

Line 285: , p13_a5 JTF_VARCHAR2_TABLE_100

281: , p13_a1 JTF_NUMBER_TABLE
282: , p13_a2 JTF_VARCHAR2_TABLE_100
283: , p13_a3 JTF_VARCHAR2_TABLE_100
284: , p13_a4 JTF_VARCHAR2_TABLE_300
285: , p13_a5 JTF_VARCHAR2_TABLE_100
286: , p13_a6 JTF_NUMBER_TABLE
287: , p14_a0 JTF_NUMBER_TABLE
288: , p14_a1 JTF_NUMBER_TABLE
289: , p14_a2 JTF_VARCHAR2_TABLE_100

Line 289: , p14_a2 JTF_VARCHAR2_TABLE_100

285: , p13_a5 JTF_VARCHAR2_TABLE_100
286: , p13_a6 JTF_NUMBER_TABLE
287: , p14_a0 JTF_NUMBER_TABLE
288: , p14_a1 JTF_NUMBER_TABLE
289: , p14_a2 JTF_VARCHAR2_TABLE_100
290: , p14_a3 JTF_VARCHAR2_TABLE_100
291: , p14_a4 JTF_NUMBER_TABLE
292: , p15_a0 NUMBER
293: , p15_a1 NUMBER

Line 290: , p14_a3 JTF_VARCHAR2_TABLE_100

286: , p13_a6 JTF_NUMBER_TABLE
287: , p14_a0 JTF_NUMBER_TABLE
288: , p14_a1 JTF_NUMBER_TABLE
289: , p14_a2 JTF_VARCHAR2_TABLE_100
290: , p14_a3 JTF_VARCHAR2_TABLE_100
291: , p14_a4 JTF_NUMBER_TABLE
292: , p15_a0 NUMBER
293: , p15_a1 NUMBER
294: , p15_a2 VARCHAR2

Line 420: , p11_a2 JTF_VARCHAR2_TABLE_100

416: , p_query_desc VARCHAR2
417: , p_query_data_source VARCHAR2
418: , p11_a0 JTF_NUMBER_TABLE
419: , p11_a1 JTF_NUMBER_TABLE
420: , p11_a2 JTF_VARCHAR2_TABLE_100
421: , p11_a3 JTF_VARCHAR2_TABLE_100
422: , p11_a4 JTF_VARCHAR2_TABLE_300
423: , p11_a5 JTF_VARCHAR2_TABLE_100
424: , p11_a6 JTF_NUMBER_TABLE

Line 421: , p11_a3 JTF_VARCHAR2_TABLE_100

417: , p_query_data_source VARCHAR2
418: , p11_a0 JTF_NUMBER_TABLE
419: , p11_a1 JTF_NUMBER_TABLE
420: , p11_a2 JTF_VARCHAR2_TABLE_100
421: , p11_a3 JTF_VARCHAR2_TABLE_100
422: , p11_a4 JTF_VARCHAR2_TABLE_300
423: , p11_a5 JTF_VARCHAR2_TABLE_100
424: , p11_a6 JTF_NUMBER_TABLE
425: , p12_a0 JTF_NUMBER_TABLE

Line 423: , p11_a5 JTF_VARCHAR2_TABLE_100

419: , p11_a1 JTF_NUMBER_TABLE
420: , p11_a2 JTF_VARCHAR2_TABLE_100
421: , p11_a3 JTF_VARCHAR2_TABLE_100
422: , p11_a4 JTF_VARCHAR2_TABLE_300
423: , p11_a5 JTF_VARCHAR2_TABLE_100
424: , p11_a6 JTF_NUMBER_TABLE
425: , p12_a0 JTF_NUMBER_TABLE
426: , p12_a1 JTF_NUMBER_TABLE
427: , p12_a2 JTF_VARCHAR2_TABLE_100

Line 427: , p12_a2 JTF_VARCHAR2_TABLE_100

423: , p11_a5 JTF_VARCHAR2_TABLE_100
424: , p11_a6 JTF_NUMBER_TABLE
425: , p12_a0 JTF_NUMBER_TABLE
426: , p12_a1 JTF_NUMBER_TABLE
427: , p12_a2 JTF_VARCHAR2_TABLE_100
428: , p12_a3 JTF_VARCHAR2_TABLE_100
429: , p12_a4 JTF_NUMBER_TABLE
430: , p13_a0 NUMBER
431: , p13_a1 NUMBER

Line 428: , p12_a3 JTF_VARCHAR2_TABLE_100

424: , p11_a6 JTF_NUMBER_TABLE
425: , p12_a0 JTF_NUMBER_TABLE
426: , p12_a1 JTF_NUMBER_TABLE
427: , p12_a2 JTF_VARCHAR2_TABLE_100
428: , p12_a3 JTF_VARCHAR2_TABLE_100
429: , p12_a4 JTF_NUMBER_TABLE
430: , p13_a0 NUMBER
431: , p13_a1 NUMBER
432: , p13_a2 VARCHAR2

Line 547: , p13_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

543: , x_query_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
544: , x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2
545: , p13_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
546: , p13_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
547: , p13_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
548: , p13_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
549: , p13_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
550: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
551: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 548: , p13_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

544: , x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2
545: , p13_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
546: , p13_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
547: , p13_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
548: , p13_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
549: , p13_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
550: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
551: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
552: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 550: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

546: , p13_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
547: , p13_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
548: , p13_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
549: , p13_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
550: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
551: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
552: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
553: , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
554: , p14_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 554: , p14_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

550: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
551: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
552: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
553: , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
554: , p14_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
555: , p14_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
556: , p14_a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
557: , p15_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
558: , p15_a1 OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 555: , p14_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

551: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
552: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
553: , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
554: , p14_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
555: , p14_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
556: , p14_a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
557: , p15_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
558: , p15_a1 OUT NOCOPY /* file.sql.39 change */ NUMBER
559: , p15_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 672: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

668: , p_query_type VARCHAR2
669: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
670: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
671: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
672: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
673: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
674: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
675: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
676: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 673: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

669: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
670: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
671: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
672: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
673: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
674: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
675: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
676: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
677: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 747: , p10_a2 JTF_VARCHAR2_TABLE_100

743: , p_query_desc VARCHAR2
744: , p_query_data_source VARCHAR2
745: , p10_a0 JTF_NUMBER_TABLE
746: , p10_a1 JTF_NUMBER_TABLE
747: , p10_a2 JTF_VARCHAR2_TABLE_100
748: , p10_a3 JTF_VARCHAR2_TABLE_100
749: , p10_a4 JTF_VARCHAR2_TABLE_300
750: , p10_a5 JTF_VARCHAR2_TABLE_100
751: , p10_a6 JTF_NUMBER_TABLE

Line 748: , p10_a3 JTF_VARCHAR2_TABLE_100

744: , p_query_data_source VARCHAR2
745: , p10_a0 JTF_NUMBER_TABLE
746: , p10_a1 JTF_NUMBER_TABLE
747: , p10_a2 JTF_VARCHAR2_TABLE_100
748: , p10_a3 JTF_VARCHAR2_TABLE_100
749: , p10_a4 JTF_VARCHAR2_TABLE_300
750: , p10_a5 JTF_VARCHAR2_TABLE_100
751: , p10_a6 JTF_NUMBER_TABLE
752: , p11_a0 JTF_NUMBER_TABLE

Line 750: , p10_a5 JTF_VARCHAR2_TABLE_100

746: , p10_a1 JTF_NUMBER_TABLE
747: , p10_a2 JTF_VARCHAR2_TABLE_100
748: , p10_a3 JTF_VARCHAR2_TABLE_100
749: , p10_a4 JTF_VARCHAR2_TABLE_300
750: , p10_a5 JTF_VARCHAR2_TABLE_100
751: , p10_a6 JTF_NUMBER_TABLE
752: , p11_a0 JTF_NUMBER_TABLE
753: , p11_a1 JTF_NUMBER_TABLE
754: , p11_a2 JTF_VARCHAR2_TABLE_100

Line 754: , p11_a2 JTF_VARCHAR2_TABLE_100

750: , p10_a5 JTF_VARCHAR2_TABLE_100
751: , p10_a6 JTF_NUMBER_TABLE
752: , p11_a0 JTF_NUMBER_TABLE
753: , p11_a1 JTF_NUMBER_TABLE
754: , p11_a2 JTF_VARCHAR2_TABLE_100
755: , p11_a3 JTF_VARCHAR2_TABLE_100
756: , p11_a4 JTF_NUMBER_TABLE
757: , p12_a0 NUMBER
758: , p12_a1 NUMBER

Line 755: , p11_a3 JTF_VARCHAR2_TABLE_100

751: , p10_a6 JTF_NUMBER_TABLE
752: , p11_a0 JTF_NUMBER_TABLE
753: , p11_a1 JTF_NUMBER_TABLE
754: , p11_a2 JTF_VARCHAR2_TABLE_100
755: , p11_a3 JTF_VARCHAR2_TABLE_100
756: , p11_a4 JTF_NUMBER_TABLE
757: , p12_a0 NUMBER
758: , p12_a1 NUMBER
759: , p12_a2 VARCHAR2