DBA Data[Home] [Help]

APPS.JTF_MENU_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 24: , a2 JTF_VARCHAR2_TABLE_300

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
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100

Line 27: , a5 JTF_VARCHAR2_TABLE_300

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

Line 30: , a8 JTF_VARCHAR2_TABLE_300

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

Line 40: , a18 JTF_VARCHAR2_TABLE_300

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
41: ) as
42: ddindx binary_integer; indx binary_integer;
43: begin
44: if a0 is not null and a0.count > 0 then

Line 79: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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
82: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
83: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 82: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 85: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 95: , a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 102: a2 := JTF_VARCHAR2_TABLE_300();

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();
105: a5 := JTF_VARCHAR2_TABLE_300();
106: a6 := JTF_VARCHAR2_TABLE_100();

Line 105: a5 := JTF_VARCHAR2_TABLE_300();

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

Line 108: a8 := JTF_VARCHAR2_TABLE_300();

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

Line 118: a18 := JTF_VARCHAR2_TABLE_300();

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();
119: else
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_VARCHAR2_TABLE_100();
122: a2 := JTF_VARCHAR2_TABLE_300();

Line 122: a2 := JTF_VARCHAR2_TABLE_300();

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();
125: a5 := JTF_VARCHAR2_TABLE_300();
126: a6 := JTF_VARCHAR2_TABLE_100();

Line 125: a5 := JTF_VARCHAR2_TABLE_300();

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

Line 128: a8 := JTF_VARCHAR2_TABLE_300();

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

Line 138: a18 := JTF_VARCHAR2_TABLE_300();

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();
139: if t.count > 0 then
140: a0.extend(t.count);
141: a1.extend(t.count);
142: a2.extend(t.count);

Line 294: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 297: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 300: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 310: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 314: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 317: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 320: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 330: , p8_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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
331: )
332:
333: as
334: ddp_responsibility_table jtf_menu_pub.responsibility_table;

Line 433: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 436: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 439: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 449: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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
450: )
451:
452: as
453: ddp_responsibility_table jtf_menu_pub.responsibility_table;

Line 520: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 523: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 526: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 536: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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
537: )
538:
539: as
540: ddp_responsibility_table jtf_menu_pub.responsibility_table;

Line 606: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 609: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 612: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 622: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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
623: )
624:
625: as
626: ddp_responsibility_table jtf_menu_pub.responsibility_table;

Line 685: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 688: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 691: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 701: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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
702: )
703:
704: as
705: ddp_menu_table jtf_menu_pub.menu_table;

Line 753: , p2_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 756: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 759: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 769: , p2_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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
770: )
771:
772: as
773: ddp_menu_table jtf_menu_pub.menu_table;

Line 814: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 817: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 820: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 830: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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
831: )
832:
833: as
834: ddp_menu_table jtf_menu_pub.menu_table;

Line 872: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 875: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 878: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 888: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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
889: )
890:
891: as
892: ddp_menu_table jtf_menu_pub.menu_table;