APPS.JTF_MENU_PUB_W dependencies on JTF_NUMBER_TABLE

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

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

Line 6: , a3 JTF_NUMBER_TABLE

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
10: , a7 JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_NUMBER_TABLE

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
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100

Line 17: , a14 JTF_NUMBER_TABLE

13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
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

Line 23: procedure rosetta_table_copy_out_p3(t jtf_menu_pub.menu_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_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
26: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
27: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
30: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
36: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
36: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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);
46:
47: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.responsibility_table, a0 JTF_NUMBER_TABLE
48: , a1 JTF_VARCHAR2_TABLE_100

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

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);
46:
47: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.responsibility_table, a0 JTF_NUMBER_TABLE
48: , a1 JTF_VARCHAR2_TABLE_100
49: );

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

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);
46:
47: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.responsibility_table, a0 JTF_NUMBER_TABLE
48: , a1 JTF_VARCHAR2_TABLE_100
49: );
50: procedure rosetta_table_copy_out_p5(t jtf_menu_pub.responsibility_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
51: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

46:
47: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.responsibility_table, a0 JTF_NUMBER_TABLE
48: , a1 JTF_VARCHAR2_TABLE_100
49: );
50: procedure rosetta_table_copy_out_p5(t jtf_menu_pub.responsibility_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
51: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
52: );
53:
54: procedure get_excl_entire_menu_tree_tl(p_lang VARCHAR2

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

54: procedure get_excl_entire_menu_tree_tl(p_lang VARCHAR2
55: , p_respid NUMBER
56: , p_appid NUMBER
57: , p_max_depth NUMBER
58: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
60: , p5_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
61: , p5_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: , p5_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

60: , p5_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
61: , p5_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

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

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
71: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
77: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
77: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 83: , p_kids_menu_ids 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
87: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 84: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_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
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

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

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
91: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
97: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
97: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

103: );
104: procedure get_excluded_root_menu_tl(p_lang VARCHAR2
105: , p_respid NUMBER
106: , p_appid NUMBER
107: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
108: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
109: , p4_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
110: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

109: , p4_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
110: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

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

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
120: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
126: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
126: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

132: );
133: procedure get_root_menu_tl(p_lang VARCHAR2
134: , p_respid NUMBER
135: , p_appid NUMBER
136: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
137: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
138: , p4_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
139: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

138: , p4_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
139: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

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

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
149: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
155: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
155: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
165: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
166: , p3_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
167: , p3_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
168: , p3_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

166: , p3_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
167: , p3_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

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

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
177: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
183: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
183: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

190: procedure get_excluded_menu_entries_tl(p_lang VARCHAR2
191: , p_menu_id NUMBER
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

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

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
201: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
207: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
207: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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

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

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
223: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
229: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
229: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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

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

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
244: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
250: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
250: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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

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

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
265: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
271: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

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

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
271: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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