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_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.menu_table, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300

Line 26: , a4 JTF_VARCHAR2_TABLE_100

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

Line 28: , a6 JTF_VARCHAR2_TABLE_100

24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100

Line 29: , a7 JTF_VARCHAR2_TABLE_100

25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100

Line 31: , a9 JTF_VARCHAR2_TABLE_100

27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100

Line 32: , a10 JTF_VARCHAR2_TABLE_100

28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE

Line 33: , a11 JTF_VARCHAR2_TABLE_100

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

Line 35: , a13 JTF_VARCHAR2_TABLE_100

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

Line 38: , a16 JTF_VARCHAR2_TABLE_100

34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_DATE_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_300
41: ) as
42: ddindx binary_integer; indx binary_integer;

Line 39: , a17 JTF_VARCHAR2_TABLE_100

35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_DATE_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_300
41: ) as
42: ddindx binary_integer; indx binary_integer;
43: begin

Line 78: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 81: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 83: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

79: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
80: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
81: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
82: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
83: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
84: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
85: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
86: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
87: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 84: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

80: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
81: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
82: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
83: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
84: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
85: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
86: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
87: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
88: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 86: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

82: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
83: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
84: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
85: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
86: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
87: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
88: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
90: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 87: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

83: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
84: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
85: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
86: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
87: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
88: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
90: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 88: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 90: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 93: , a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

89: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
90: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
92: , a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
93: , a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94: , a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
95: , a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
96: ) as
97: ddindx binary_integer; indx binary_integer;

Line 94: , a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

90: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
92: , a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
93: , a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94: , a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
95: , a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
96: ) as
97: ddindx binary_integer; indx binary_integer;
98: begin

Line 101: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 104: a4 := JTF_VARCHAR2_TABLE_100();

100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_VARCHAR2_TABLE_100();
102: a2 := JTF_VARCHAR2_TABLE_300();
103: a3 := JTF_NUMBER_TABLE();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_VARCHAR2_TABLE_300();
106: a6 := JTF_VARCHAR2_TABLE_100();
107: a7 := JTF_VARCHAR2_TABLE_100();
108: a8 := JTF_VARCHAR2_TABLE_300();

Line 106: a6 := JTF_VARCHAR2_TABLE_100();

102: a2 := JTF_VARCHAR2_TABLE_300();
103: a3 := JTF_NUMBER_TABLE();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_VARCHAR2_TABLE_300();
106: a6 := JTF_VARCHAR2_TABLE_100();
107: a7 := JTF_VARCHAR2_TABLE_100();
108: a8 := JTF_VARCHAR2_TABLE_300();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();

Line 107: a7 := JTF_VARCHAR2_TABLE_100();

103: a3 := JTF_NUMBER_TABLE();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_VARCHAR2_TABLE_300();
106: a6 := JTF_VARCHAR2_TABLE_100();
107: a7 := JTF_VARCHAR2_TABLE_100();
108: a8 := JTF_VARCHAR2_TABLE_300();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_100();

Line 109: a9 := JTF_VARCHAR2_TABLE_100();

105: a5 := JTF_VARCHAR2_TABLE_300();
106: a6 := JTF_VARCHAR2_TABLE_100();
107: a7 := JTF_VARCHAR2_TABLE_100();
108: a8 := JTF_VARCHAR2_TABLE_300();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_100();
112: a12 := JTF_NUMBER_TABLE();
113: a13 := JTF_VARCHAR2_TABLE_100();

Line 110: a10 := JTF_VARCHAR2_TABLE_100();

106: a6 := JTF_VARCHAR2_TABLE_100();
107: a7 := JTF_VARCHAR2_TABLE_100();
108: a8 := JTF_VARCHAR2_TABLE_300();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_100();
112: a12 := JTF_NUMBER_TABLE();
113: a13 := JTF_VARCHAR2_TABLE_100();
114: a14 := JTF_NUMBER_TABLE();

Line 111: a11 := JTF_VARCHAR2_TABLE_100();

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

Line 113: a13 := JTF_VARCHAR2_TABLE_100();

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

Line 116: a16 := JTF_VARCHAR2_TABLE_100();

112: a12 := JTF_NUMBER_TABLE();
113: a13 := JTF_VARCHAR2_TABLE_100();
114: a14 := JTF_NUMBER_TABLE();
115: a15 := JTF_DATE_TABLE();
116: a16 := JTF_VARCHAR2_TABLE_100();
117: a17 := JTF_VARCHAR2_TABLE_100();
118: a18 := JTF_VARCHAR2_TABLE_300();
119: else
120: a0 := JTF_NUMBER_TABLE();

Line 117: a17 := JTF_VARCHAR2_TABLE_100();

113: a13 := JTF_VARCHAR2_TABLE_100();
114: a14 := JTF_NUMBER_TABLE();
115: a15 := JTF_DATE_TABLE();
116: a16 := JTF_VARCHAR2_TABLE_100();
117: a17 := JTF_VARCHAR2_TABLE_100();
118: a18 := JTF_VARCHAR2_TABLE_300();
119: else
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_VARCHAR2_TABLE_100();

Line 121: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 124: a4 := JTF_VARCHAR2_TABLE_100();

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

Line 126: a6 := JTF_VARCHAR2_TABLE_100();

122: a2 := JTF_VARCHAR2_TABLE_300();
123: a3 := JTF_NUMBER_TABLE();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_VARCHAR2_TABLE_300();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_VARCHAR2_TABLE_100();
128: a8 := JTF_VARCHAR2_TABLE_300();
129: a9 := JTF_VARCHAR2_TABLE_100();
130: a10 := JTF_VARCHAR2_TABLE_100();

Line 127: a7 := JTF_VARCHAR2_TABLE_100();

123: a3 := JTF_NUMBER_TABLE();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_VARCHAR2_TABLE_300();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_VARCHAR2_TABLE_100();
128: a8 := JTF_VARCHAR2_TABLE_300();
129: a9 := JTF_VARCHAR2_TABLE_100();
130: a10 := JTF_VARCHAR2_TABLE_100();
131: a11 := JTF_VARCHAR2_TABLE_100();

Line 129: a9 := JTF_VARCHAR2_TABLE_100();

125: a5 := JTF_VARCHAR2_TABLE_300();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_VARCHAR2_TABLE_100();
128: a8 := JTF_VARCHAR2_TABLE_300();
129: a9 := JTF_VARCHAR2_TABLE_100();
130: a10 := JTF_VARCHAR2_TABLE_100();
131: a11 := JTF_VARCHAR2_TABLE_100();
132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_VARCHAR2_TABLE_100();

Line 130: a10 := JTF_VARCHAR2_TABLE_100();

126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_VARCHAR2_TABLE_100();
128: a8 := JTF_VARCHAR2_TABLE_300();
129: a9 := JTF_VARCHAR2_TABLE_100();
130: a10 := JTF_VARCHAR2_TABLE_100();
131: a11 := JTF_VARCHAR2_TABLE_100();
132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_VARCHAR2_TABLE_100();
134: a14 := JTF_NUMBER_TABLE();

Line 131: a11 := JTF_VARCHAR2_TABLE_100();

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

Line 133: a13 := JTF_VARCHAR2_TABLE_100();

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

Line 136: a16 := JTF_VARCHAR2_TABLE_100();

132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_VARCHAR2_TABLE_100();
134: a14 := JTF_NUMBER_TABLE();
135: a15 := JTF_DATE_TABLE();
136: a16 := JTF_VARCHAR2_TABLE_100();
137: a17 := JTF_VARCHAR2_TABLE_100();
138: a18 := JTF_VARCHAR2_TABLE_300();
139: if t.count > 0 then
140: a0.extend(t.count);

Line 137: a17 := JTF_VARCHAR2_TABLE_100();

133: a13 := JTF_VARCHAR2_TABLE_100();
134: a14 := JTF_NUMBER_TABLE();
135: a15 := JTF_DATE_TABLE();
136: a16 := JTF_VARCHAR2_TABLE_100();
137: a17 := JTF_VARCHAR2_TABLE_100();
138: a18 := JTF_VARCHAR2_TABLE_300();
139: if t.count > 0 then
140: a0.extend(t.count);
141: a1.extend(t.count);

Line 233: , a1 JTF_VARCHAR2_TABLE_100

229: end if;
230: end rosetta_table_copy_out_p4;
231:
232: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.responsibility_table, a0 JTF_NUMBER_TABLE
233: , a1 JTF_VARCHAR2_TABLE_100
234: ) as
235: ddindx binary_integer; indx binary_integer;
236: begin
237: if a0 is not null and a0.count > 0 then

Line 254: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

250: end if;
251: end if;
252: end rosetta_table_copy_in_p5;
253: procedure rosetta_table_copy_out_p5(t jtf_menu_pub.responsibility_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
254: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then

Line 260: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 263: a1 := JTF_VARCHAR2_TABLE_100();

259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_VARCHAR2_TABLE_100();
261: else
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_VARCHAR2_TABLE_100();
264: if t.count > 0 then
265: a0.extend(t.count);
266: a1.extend(t.count);
267: ddindx := t.first;

Line 287: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 293: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 296: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 298: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

294: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
295: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
296: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
297: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
298: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
299: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
300: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
301: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
302: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 299: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

295: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
296: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
297: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
298: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
299: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
300: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
301: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
302: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
303: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 301: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

297: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
298: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
299: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
300: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
301: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
302: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
303: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
304: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
305: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 302: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

298: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
299: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
300: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
301: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
302: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
303: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
304: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
305: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
306: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 303: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 305: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 308: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

304: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
305: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
306: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
307: , p6_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
308: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
309: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
310: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
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

Line 309: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

305: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
306: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
307: , p6_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
308: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
309: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
310: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
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

Line 313: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 316: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 318: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

314: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
315: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
316: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
317: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
318: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
319: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
320: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
321: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
322: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 319: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

315: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
316: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
317: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
318: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
319: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
320: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
321: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
322: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
323: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 321: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

317: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
318: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
319: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
320: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
321: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
322: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
323: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
324: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
325: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 322: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

318: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
319: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
320: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
321: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
322: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
323: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
324: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
325: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
326: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 323: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 325: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 328: , p8_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 329: , p8_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

325: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
326: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
327: , p8_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
328: , p8_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
329: , p8_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
330: , p8_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
331: )
332:
333: as

Line 426: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 432: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 435: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 437: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

433: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
434: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
435: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
436: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
437: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
438: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
439: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
440: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
441: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 438: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

434: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
435: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
436: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
437: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
438: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
439: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
440: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
441: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
442: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 440: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

436: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
437: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
438: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
439: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
440: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
441: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
442: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
443: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
444: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 441: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

437: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
438: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
439: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
440: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
441: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
442: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
443: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
444: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
445: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 442: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 444: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 447: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 448: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

444: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
445: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
446: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
447: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
448: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
449: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
450: )
451:
452: as

Line 513: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 519: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 522: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 524: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

520: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
521: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
522: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
523: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
524: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
525: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
526: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
527: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
528: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 525: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

521: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
522: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
523: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
524: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
525: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
526: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
527: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
528: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
529: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 527: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

523: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
524: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
525: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
526: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
527: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
528: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
529: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
530: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
531: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 528: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

524: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
525: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
526: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
527: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
528: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
529: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
530: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
531: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
532: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 529: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 531: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 534: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 535: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

531: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
532: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
533: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
534: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
535: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
536: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
537: )
538:
539: as

Line 599: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 605: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 608: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 610: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

606: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
607: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
608: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
609: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
610: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
611: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
612: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
613: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
614: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 611: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

607: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
608: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
609: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
610: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
611: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
612: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
613: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
614: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
615: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 613: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

609: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
610: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
611: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
612: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
613: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
614: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
615: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
616: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
617: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 614: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

610: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
611: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
612: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
613: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
614: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
615: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
616: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
617: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
618: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 615: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 617: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 620: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 621: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

617: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
618: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
619: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
620: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
621: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
622: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
623: )
624:
625: as

Line 684: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

680: , p_menu_id NUMBER
681: , p_respid NUMBER
682: , p_appid NUMBER
683: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
684: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
685: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
686: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
687: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
688: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 687: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 689: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

685: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
686: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
687: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
688: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
689: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
690: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
691: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
692: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
693: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 690: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

686: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
687: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
688: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
689: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
690: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
691: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
692: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
693: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
694: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 692: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

688: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
689: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
690: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
691: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
692: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
693: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
694: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
695: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
696: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 693: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

689: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
690: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
691: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
692: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
693: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
694: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
695: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
696: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
697: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 694: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 696: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 699: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 700: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

696: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
697: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
698: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
699: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
700: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
701: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
702: )
703:
704: as

Line 752: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 755: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 757: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

753: , p2_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
754: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
755: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
756: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
757: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
758: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
759: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
760: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
761: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 758: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

754: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
755: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
756: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
757: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
758: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
759: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
760: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
761: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
762: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 760: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

756: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
757: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
758: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
759: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
760: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
761: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
762: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
763: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
764: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 761: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

757: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
758: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
759: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
760: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
761: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
762: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
763: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
764: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
765: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 762: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 764: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 767: , p2_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 768: , p2_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

764: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
765: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
766: , p2_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
767: , p2_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
768: , p2_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
769: , p2_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
770: )
771:
772: as

Line 813: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 816: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

812: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
813: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
814: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
815: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
816: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
817: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
818: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
819: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
820: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 818: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

814: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
815: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
816: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
817: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
818: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
819: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
820: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
821: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
822: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 819: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

815: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
816: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
817: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
818: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
819: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
820: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
821: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
822: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
823: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 821: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

817: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
818: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
819: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
820: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
821: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
822: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
823: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
824: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
825: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 822: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

818: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
819: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
820: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
821: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
822: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
823: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
824: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
825: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
826: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 823: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 825: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 828: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 829: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

825: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
826: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
827: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
828: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
829: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
830: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
831: )
832:
833: as

Line 871: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 874: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

870: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
871: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
872: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
873: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
874: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
875: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
876: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
877: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
878: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 876: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

872: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
873: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
874: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
875: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
876: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
877: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
878: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
879: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
880: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 877: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

873: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
874: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
875: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
876: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
877: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
878: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
879: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
880: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
881: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 879: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

875: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
876: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
877: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
878: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
879: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
880: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
881: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
882: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
883: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 880: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

876: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
877: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
878: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
879: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
880: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
881: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
882: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
883: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
884: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 881: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 883: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 886: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 887: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

883: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
884: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
885: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
886: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
887: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
888: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
889: )
890:
891: as