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_NUMBER_TABLE

Line 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

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
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

Line 23: , a1 JTF_NUMBER_TABLE

19: return d;
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

Line 28: , a6 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
32: if a0 is not null and a0.count > 0 then

Line 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

49: end loop;
50: end if;
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

Line 54: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 59: , a6 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
63: if t is null or t.count = 0 then

Line 64: a0 := JTF_NUMBER_TABLE();

60: ) as
61: ddindx binary_integer; indx binary_integer;
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();

Line 65: a1 := JTF_NUMBER_TABLE();

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

Line 70: a6 := 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();
74: a2 := JTF_VARCHAR2_TABLE_100();

Line 72: a0 := JTF_NUMBER_TABLE();

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();
74: a2 := JTF_VARCHAR2_TABLE_100();
75: a3 := JTF_VARCHAR2_TABLE_100();
76: a4 := JTF_VARCHAR2_TABLE_300();

Line 73: a1 := JTF_NUMBER_TABLE();

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

Line 78: a6 := 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);
82: a2.extend(t.count);

Line 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

103: end if;
104: end if;
105: end rosetta_table_copy_out_p1;
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

Line 108: , a1 JTF_NUMBER_TABLE

104: end if;
105: end rosetta_table_copy_out_p1;
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

Line 109: , a2 JTF_NUMBER_TABLE

105: end rosetta_table_copy_out_p1;
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

Line 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

134: end loop;
135: end if;
136: end if;
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

Line 139: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 140: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 149: a0 := JTF_NUMBER_TABLE();

145: ) as
146: ddindx binary_integer; indx binary_integer;
147: begin
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();

Line 150: a1 := JTF_NUMBER_TABLE();

146: ddindx binary_integer; indx binary_integer;
147: begin
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();

Line 151: a2 := JTF_NUMBER_TABLE();

147: begin
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();

Line 157: a0 := JTF_NUMBER_TABLE();

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();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_NUMBER_TABLE();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();

Line 158: a1 := JTF_NUMBER_TABLE();

154: a5 := JTF_VARCHAR2_TABLE_300();
155: a6 := JTF_VARCHAR2_TABLE_2000();
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();

Line 159: a2 := JTF_NUMBER_TABLE();

155: a6 := JTF_VARCHAR2_TABLE_2000();
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();

Line 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

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

Line 193: , a1 JTF_NUMBER_TABLE

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

Line 196: , a4 JTF_NUMBER_TABLE

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
200: if a0 is not null and a0.count > 0 then

Line 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

215: end loop;
216: end if;
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

Line 220: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 223: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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
227: if t is null or t.count = 0 then

Line 228: a0 := JTF_NUMBER_TABLE();

224: ) as
225: ddindx binary_integer; indx binary_integer;
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();

Line 229: a1 := JTF_NUMBER_TABLE();

225: ddindx binary_integer; indx binary_integer;
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

Line 232: a4 := JTF_NUMBER_TABLE();

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();
236: a2 := JTF_VARCHAR2_TABLE_100();

Line 234: a0 := 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();
236: a2 := JTF_VARCHAR2_TABLE_100();
237: a3 := JTF_VARCHAR2_TABLE_100();
238: a4 := JTF_NUMBER_TABLE();

Line 235: a1 := JTF_NUMBER_TABLE();

231: a3 := 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

Line 238: a4 := JTF_NUMBER_TABLE();

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);
242: a2.extend(t.count);

Line 270: , p7_a0 JTF_NUMBER_TABLE

266: , p_application_id NUMBER
267: , p_profile_id NUMBER
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

Line 271: , p7_a1 JTF_NUMBER_TABLE

267: , p_profile_id NUMBER
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

Line 280: , p13_a0 JTF_NUMBER_TABLE

276: , p_query_name VARCHAR2
277: , p_query_type VARCHAR2
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

Line 281: , p13_a1 JTF_NUMBER_TABLE

277: , p_query_type VARCHAR2
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

Line 286: , p13_a6 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
290: , p14_a3 JTF_VARCHAR2_TABLE_100

Line 287: , p14_a0 JTF_NUMBER_TABLE

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
290: , p14_a3 JTF_VARCHAR2_TABLE_100
291: , p14_a4 JTF_NUMBER_TABLE

Line 288: , p14_a1 JTF_NUMBER_TABLE

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
290: , p14_a3 JTF_VARCHAR2_TABLE_100
291: , p14_a4 JTF_NUMBER_TABLE
292: , p15_a0 NUMBER

Line 291: , p14_a4 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
295: , p15_a3 VARCHAR2

Line 418: , p11_a0 JTF_NUMBER_TABLE

414: , p_query_name VARCHAR2
415: , p_query_type VARCHAR2
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

Line 419: , p11_a1 JTF_NUMBER_TABLE

415: , p_query_type VARCHAR2
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

Line 424: , p11_a6 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
428: , p12_a3 JTF_VARCHAR2_TABLE_100

Line 425: , p12_a0 JTF_NUMBER_TABLE

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
428: , p12_a3 JTF_VARCHAR2_TABLE_100
429: , p12_a4 JTF_NUMBER_TABLE

Line 426: , p12_a1 JTF_NUMBER_TABLE

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
428: , p12_a3 JTF_VARCHAR2_TABLE_100
429: , p12_a4 JTF_NUMBER_TABLE
430: , p13_a0 NUMBER

Line 429: , p12_a4 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
433: , p13_a3 VARCHAR2

Line 545: , p13_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

541: , x_query_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
542: , x_query_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 546: , p13_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

542: , x_query_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 551: , p13_a6 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
555: , p14_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 552: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 553: , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 556: , p14_a4 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
560: , p15_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 669: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

665: , p_profile_name VARCHAR2
666: , p_query_id NUMBER
667: , p_query_name VARCHAR2
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

Line 670: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

666: , p_query_id NUMBER
667: , p_query_name VARCHAR2
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

Line 671: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

667: , p_query_name VARCHAR2
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

Line 745: , p10_a0 JTF_NUMBER_TABLE

741: , p_query_name VARCHAR2
742: , p_query_type VARCHAR2
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

Line 746: , p10_a1 JTF_NUMBER_TABLE

742: , p_query_type VARCHAR2
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

Line 751: , p10_a6 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
755: , p11_a3 JTF_VARCHAR2_TABLE_100

Line 752: , p11_a0 JTF_NUMBER_TABLE

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
755: , p11_a3 JTF_VARCHAR2_TABLE_100
756: , p11_a4 JTF_NUMBER_TABLE

Line 753: , p11_a1 JTF_NUMBER_TABLE

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
755: , p11_a3 JTF_VARCHAR2_TABLE_100
756: , p11_a4 JTF_NUMBER_TABLE
757: , p12_a0 NUMBER

Line 756: , p11_a4 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
760: , p12_a3 VARCHAR2