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_VARCHAR2_TABLE_300

Line 5: , a2 JTF_VARCHAR2_TABLE_300

1: package jtf_menu_pub_w as
2: /* $Header: jtfmenws.pls 120.2 2005/10/25 05:23:56 psanyal ship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.menu_table, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_VARCHAR2_TABLE_300

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_100

Line 11: , a8 JTF_VARCHAR2_TABLE_300

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE

Line 21: , a18 JTF_VARCHAR2_TABLE_300

17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_300
22: );
23: procedure rosetta_table_copy_out_p3(t jtf_menu_pub.menu_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
24: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
25: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

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

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

24: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
25: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
26: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
27: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
32: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

27: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
32: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
34: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
35: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

37: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
39: , a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
40: , a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
41: , a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
42: );
43:
44: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.number_table, a0 JTF_NUMBER_TABLE);
45: procedure rosetta_table_copy_out_p4(t jtf_menu_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE);

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

62: , p5_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63: , p5_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
65: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
66: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
67: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
68: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
69: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
70: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

65: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
66: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
67: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
68: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
69: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
70: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
71: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
72: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
73: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

68: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
69: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
70: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
71: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
72: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
73: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
74: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
75: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
76: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

78: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
79: , p6_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
80: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
81: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
82: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
83: , p_kids_menu_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
84: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
85: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
86: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

82: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
83: , p_kids_menu_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
84: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
85: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
86: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
87: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
88: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
90: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

85: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
86: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
87: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
88: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
90: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
92: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
93: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

88: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
90: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
92: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
93: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
95: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
96: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

98: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
99: , p8_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
100: , p8_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
101: , p8_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
102: , p8_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
103: );
104: procedure get_excluded_root_menu_tl(p_lang VARCHAR2
105: , p_respid NUMBER
106: , p_appid NUMBER

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

111: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112: , p4_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
114: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
115: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
116: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
117: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
118: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
119: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

114: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
115: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
116: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
117: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
118: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
119: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
120: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
121: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
122: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

117: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
118: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
119: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
120: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
121: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
122: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
123: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
124: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
125: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

127: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
128: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
129: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
130: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
131: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
132: );
133: procedure get_root_menu_tl(p_lang VARCHAR2
134: , p_respid NUMBER
135: , p_appid NUMBER

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

140: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141: , p4_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
142: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
143: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
144: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
145: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
146: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
148: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

143: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
144: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
145: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
146: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
148: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
149: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
151: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

146: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
148: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
149: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
151: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
154: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

156: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
157: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
158: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
159: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
160: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
161: );
162: procedure get_root_menu(p_respid NUMBER
163: , p_appid NUMBER
164: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

168: , p3_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
169: , p3_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
170: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
171: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
172: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
173: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
174: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
175: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
176: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

171: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
172: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
173: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
174: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
175: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
176: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
179: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

174: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
175: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
176: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
179: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
180: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
181: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
182: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

184: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
185: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
186: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
187: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
188: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
189: );
190: procedure get_excluded_menu_entries_tl(p_lang VARCHAR2
191: , p_menu_id NUMBER
192: , p_respid NUMBER

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

192: , p_respid NUMBER
193: , p_appid NUMBER
194: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
195: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
196: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
197: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
198: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
199: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
200: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

195: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
196: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
197: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
198: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
199: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
200: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
201: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
203: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

198: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
199: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
200: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
201: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
203: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
206: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

208: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
209: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
210: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
211: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
212: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
213: );
214: procedure get_menu_entries_tl(p_lang VARCHAR2
215: , p_menu_id NUMBER
216: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

214: procedure get_menu_entries_tl(p_lang VARCHAR2
215: , p_menu_id NUMBER
216: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
217: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
218: , p2_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
219: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
220: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
221: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
222: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

217: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
218: , p2_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
219: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
220: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
221: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
222: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
224: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
225: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

220: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
221: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
222: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
224: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
225: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
226: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
227: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
228: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

230: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
231: , p2_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
232: , p2_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
233: , p2_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
234: , p2_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
235: );
236: procedure get_menu_entries(p_menu_id NUMBER
237: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
238: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

235: );
236: procedure get_menu_entries(p_menu_id NUMBER
237: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
238: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
239: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
240: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
241: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
242: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
243: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

238: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
239: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
240: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
241: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
242: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
243: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
244: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
245: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
246: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

241: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
242: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
243: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
244: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
245: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
246: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
247: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
248: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
249: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

251: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
252: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
253: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
254: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
255: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
256: );
257: procedure get_func_entries(p_menu_id NUMBER
258: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
259: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

256: );
257: procedure get_func_entries(p_menu_id NUMBER
258: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
259: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
260: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
261: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
262: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
263: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
264: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

259: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
260: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
261: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
262: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
263: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
264: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
265: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
267: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

262: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
263: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
264: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
265: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
267: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
268: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
269: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
270: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

272: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
273: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
274: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
277: );
278: end jtf_menu_pub_w;