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
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
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
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
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
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
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
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
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();
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();
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();
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();
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();
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();
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();
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();
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
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();
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);
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;
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
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
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();
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);
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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