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_MENU_PUB_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.menu_table, 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_p3(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.menu_table, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.menu_table, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100

Line 34: , a12 JTF_NUMBER_TABLE

30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_DATE_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100

Line 36: , a14 JTF_NUMBER_TABLE

32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_DATE_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_300

Line 77: procedure rosetta_table_copy_out_p3(t jtf_menu_pub.menu_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

73: end loop;
74: end if;
75: end if;
76: end rosetta_table_copy_in_p3;
77: procedure rosetta_table_copy_out_p3(t jtf_menu_pub.menu_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
78: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
79: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
80: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
81: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 80: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

76: end rosetta_table_copy_in_p3;
77: procedure rosetta_table_copy_out_p3(t jtf_menu_pub.menu_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
78: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
79: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
80: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
81: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
82: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
83: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
84: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 89: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

85: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
86: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
87: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
88: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
90: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
92: , a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
93: , a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 91: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

87: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
88: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
90: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
92: , a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
93: , a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94: , a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
95: , a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 100: a0 := JTF_NUMBER_TABLE();

96: ) as
97: ddindx binary_integer; indx binary_integer;
98: begin
99: if t is null or t.count = 0 then
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_VARCHAR2_TABLE_100();
102: a2 := JTF_VARCHAR2_TABLE_300();
103: a3 := JTF_NUMBER_TABLE();
104: a4 := JTF_VARCHAR2_TABLE_100();

Line 103: a3 := JTF_NUMBER_TABLE();

99: if t is null or t.count = 0 then
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_VARCHAR2_TABLE_100();
102: a2 := JTF_VARCHAR2_TABLE_300();
103: a3 := JTF_NUMBER_TABLE();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_VARCHAR2_TABLE_300();
106: a6 := JTF_VARCHAR2_TABLE_100();
107: a7 := JTF_VARCHAR2_TABLE_100();

Line 112: a12 := JTF_NUMBER_TABLE();

108: a8 := JTF_VARCHAR2_TABLE_300();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_100();
112: a12 := JTF_NUMBER_TABLE();
113: a13 := JTF_VARCHAR2_TABLE_100();
114: a14 := JTF_NUMBER_TABLE();
115: a15 := JTF_DATE_TABLE();
116: a16 := JTF_VARCHAR2_TABLE_100();

Line 114: a14 := JTF_NUMBER_TABLE();

110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_100();
112: a12 := JTF_NUMBER_TABLE();
113: a13 := JTF_VARCHAR2_TABLE_100();
114: a14 := JTF_NUMBER_TABLE();
115: a15 := JTF_DATE_TABLE();
116: a16 := JTF_VARCHAR2_TABLE_100();
117: a17 := JTF_VARCHAR2_TABLE_100();
118: a18 := JTF_VARCHAR2_TABLE_300();

Line 120: a0 := JTF_NUMBER_TABLE();

116: a16 := JTF_VARCHAR2_TABLE_100();
117: a17 := JTF_VARCHAR2_TABLE_100();
118: a18 := JTF_VARCHAR2_TABLE_300();
119: else
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_VARCHAR2_TABLE_100();
122: a2 := JTF_VARCHAR2_TABLE_300();
123: a3 := JTF_NUMBER_TABLE();
124: a4 := JTF_VARCHAR2_TABLE_100();

Line 123: a3 := JTF_NUMBER_TABLE();

119: else
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_VARCHAR2_TABLE_100();
122: a2 := JTF_VARCHAR2_TABLE_300();
123: a3 := JTF_NUMBER_TABLE();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_VARCHAR2_TABLE_300();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_VARCHAR2_TABLE_100();

Line 132: a12 := JTF_NUMBER_TABLE();

128: a8 := JTF_VARCHAR2_TABLE_300();
129: a9 := JTF_VARCHAR2_TABLE_100();
130: a10 := JTF_VARCHAR2_TABLE_100();
131: a11 := JTF_VARCHAR2_TABLE_100();
132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_VARCHAR2_TABLE_100();
134: a14 := JTF_NUMBER_TABLE();
135: a15 := JTF_DATE_TABLE();
136: a16 := JTF_VARCHAR2_TABLE_100();

Line 134: a14 := JTF_NUMBER_TABLE();

130: a10 := JTF_VARCHAR2_TABLE_100();
131: a11 := JTF_VARCHAR2_TABLE_100();
132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_VARCHAR2_TABLE_100();
134: a14 := JTF_NUMBER_TABLE();
135: a15 := JTF_DATE_TABLE();
136: a16 := JTF_VARCHAR2_TABLE_100();
137: a17 := JTF_VARCHAR2_TABLE_100();
138: a18 := JTF_VARCHAR2_TABLE_300();

Line 191: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.number_table, a0 JTF_NUMBER_TABLE) as

187: end if;
188: end if;
189: end rosetta_table_copy_out_p3;
190:
191: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.number_table, a0 JTF_NUMBER_TABLE) as
192: ddindx binary_integer; indx binary_integer;
193: begin
194: if a0 is not null and a0.count > 0 then
195: if a0.count > 0 then

Line 209: procedure rosetta_table_copy_out_p4(t jtf_menu_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE) as

205: end loop;
206: end if;
207: end if;
208: end rosetta_table_copy_in_p4;
209: procedure rosetta_table_copy_out_p4(t jtf_menu_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE) as
210: ddindx binary_integer; indx binary_integer;
211: begin
212: if t is null or t.count = 0 then
213: a0 := JTF_NUMBER_TABLE();

Line 213: a0 := JTF_NUMBER_TABLE();

209: procedure rosetta_table_copy_out_p4(t jtf_menu_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE) as
210: ddindx binary_integer; indx binary_integer;
211: begin
212: if t is null or t.count = 0 then
213: a0 := JTF_NUMBER_TABLE();
214: else
215: a0 := JTF_NUMBER_TABLE();
216: if t.count > 0 then
217: a0.extend(t.count);

Line 215: a0 := JTF_NUMBER_TABLE();

211: begin
212: if t is null or t.count = 0 then
213: a0 := JTF_NUMBER_TABLE();
214: else
215: a0 := JTF_NUMBER_TABLE();
216: if t.count > 0 then
217: a0.extend(t.count);
218: ddindx := t.first;
219: indx := 1;

Line 232: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.responsibility_table, a0 JTF_NUMBER_TABLE

228: end if;
229: end if;
230: end rosetta_table_copy_out_p4;
231:
232: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.responsibility_table, a0 JTF_NUMBER_TABLE
233: , a1 JTF_VARCHAR2_TABLE_100
234: ) as
235: ddindx binary_integer; indx binary_integer;
236: begin

Line 253: procedure rosetta_table_copy_out_p5(t jtf_menu_pub.responsibility_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

249: end loop;
250: end if;
251: end if;
252: end rosetta_table_copy_in_p5;
253: procedure rosetta_table_copy_out_p5(t jtf_menu_pub.responsibility_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
254: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin

Line 259: a0 := JTF_NUMBER_TABLE();

255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_VARCHAR2_TABLE_100();
261: else
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_VARCHAR2_TABLE_100();

Line 262: a0 := JTF_NUMBER_TABLE();

258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_VARCHAR2_TABLE_100();
261: else
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_VARCHAR2_TABLE_100();
264: if t.count > 0 then
265: a0.extend(t.count);
266: a1.extend(t.count);

Line 286: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

282: procedure get_excl_entire_menu_tree_tl(p_lang VARCHAR2
283: , p_respid NUMBER
284: , p_appid NUMBER
285: , p_max_depth NUMBER
286: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
287: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
288: , p5_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
289: , p5_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
290: , p5_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 292: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

288: , p5_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
289: , p5_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
290: , p5_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
291: , p5_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
292: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
293: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
294: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
295: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
296: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 295: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

291: , p5_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
292: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
293: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
294: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
295: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
296: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
297: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
298: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
299: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 304: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

300: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
301: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
302: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
303: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
304: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
305: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
306: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
307: , p6_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
308: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 306: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

302: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
303: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
304: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
305: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
306: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
307: , p6_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
308: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
309: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
310: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 311: , p_kids_menu_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

307: , p6_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
308: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
309: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
310: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
311: , p_kids_menu_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
312: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
313: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
314: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
315: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

308: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
309: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
310: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
311: , p_kids_menu_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
312: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
313: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
314: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
315: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
316: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 315: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

311: , p_kids_menu_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
312: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
313: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
314: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
315: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
316: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
317: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
318: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
319: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 324: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

320: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
321: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
322: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
323: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
324: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
325: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
326: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
327: , p8_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
328: , p8_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 326: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

322: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
323: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
324: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
325: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
326: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
327: , p8_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
328: , p8_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
329: , p8_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
330: , p8_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 425: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

421:
422: procedure get_excluded_root_menu_tl(p_lang VARCHAR2
423: , p_respid NUMBER
424: , p_appid NUMBER
425: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
426: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
427: , p4_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
428: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
429: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 431: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

427: , p4_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
428: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
429: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
430: , p4_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
431: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
432: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
433: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
434: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
435: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 434: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

430: , p4_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
431: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
432: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
433: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
434: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
435: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
436: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
437: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
438: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 443: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

439: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
440: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
441: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
442: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
443: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
444: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
445: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
446: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
447: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 445: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

441: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
442: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
443: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
444: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
445: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
446: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
447: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
448: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
449: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 512: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

508:
509: procedure get_root_menu_tl(p_lang VARCHAR2
510: , p_respid NUMBER
511: , p_appid NUMBER
512: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
513: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
514: , p4_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
515: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
516: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 518: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

514: , p4_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
515: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
516: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
517: , p4_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
518: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
519: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
520: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
521: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
522: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 521: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

517: , p4_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
518: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
519: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
520: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
521: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
522: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
523: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
524: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
525: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 530: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

526: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
527: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
528: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
529: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
530: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
531: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
532: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
533: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
534: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 532: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

528: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
529: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
530: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
531: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
532: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
533: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
534: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
535: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
536: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 598: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

594: end;
595:
596: procedure get_root_menu(p_respid NUMBER
597: , p_appid NUMBER
598: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
599: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
600: , p3_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
601: , p3_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
602: , p3_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 604: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

600: , p3_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
601: , p3_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
602: , p3_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
603: , p3_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
604: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
605: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
606: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
607: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
608: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 607: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

603: , p3_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
604: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
605: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
606: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
607: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
608: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
609: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
610: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
611: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 616: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

612: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
613: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
614: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
615: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
616: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
617: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
618: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
619: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
620: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 618: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

614: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
615: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
616: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
617: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
618: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
619: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
620: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
621: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
622: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 683: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

679: procedure get_excluded_menu_entries_tl(p_lang VARCHAR2
680: , p_menu_id NUMBER
681: , p_respid NUMBER
682: , p_appid NUMBER
683: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
684: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
685: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
686: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
687: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 686: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

682: , p_appid NUMBER
683: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
684: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
685: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
686: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
687: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
688: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
689: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
690: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 695: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

691: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
692: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
693: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
694: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
695: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
696: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
697: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
698: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
699: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 697: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

693: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
694: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
695: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
696: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
697: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
698: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
699: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
700: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
701: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 751: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

747: end;
748:
749: procedure get_menu_entries_tl(p_lang VARCHAR2
750: , p_menu_id NUMBER
751: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
752: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
753: , p2_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
754: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
755: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 754: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

750: , p_menu_id NUMBER
751: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
752: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
753: , p2_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
754: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
755: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
756: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
757: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
758: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 763: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

759: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
760: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
761: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
762: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
763: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
764: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
765: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
766: , p2_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
767: , p2_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 765: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

761: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
762: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
763: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
764: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
765: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
766: , p2_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
767: , p2_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
768: , p2_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
769: , p2_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 812: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

808: );
809: end;
810:
811: procedure get_menu_entries(p_menu_id NUMBER
812: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
813: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
814: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
815: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
816: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 815: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

811: procedure get_menu_entries(p_menu_id NUMBER
812: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
813: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
814: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
815: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
816: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
817: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
818: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
819: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 824: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

820: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
821: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
822: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
823: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
824: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
825: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
826: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
827: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
828: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 826: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

822: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
823: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
824: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
825: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
826: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
827: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
828: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
829: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
830: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 870: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

866: );
867: end;
868:
869: procedure get_func_entries(p_menu_id NUMBER
870: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
871: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
872: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
873: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
874: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 873: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

869: procedure get_func_entries(p_menu_id NUMBER
870: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
871: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
872: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
873: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
874: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
875: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
876: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
877: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 882: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

878: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
879: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
880: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
881: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
882: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
883: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
884: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
885: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
886: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 884: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

880: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
881: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
882: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
883: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
884: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
885: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
886: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
887: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
888: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300