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.CAC_VIEW_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body cac_view_pvt_w as
2: /* $Header: cacvpwb.pls 120.3 2006/02/22 07:23:26 sankgupt noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_VARCHAR2_TABLE_100
7: ) as
8: ddindx binary_integer; indx binary_integer;

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: cacvpwb.pls 120.3 2006/02/22 07:23:26 sankgupt noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_VARCHAR2_TABLE_100
7: ) as
8: ddindx binary_integer; indx binary_integer;
9: begin
10: if a0 is not null and a0.count > 0 then

Line 29: , a1 out nocopy JTF_VARCHAR2_TABLE_100

25: end if;
26: end if;
27: end rosetta_table_copy_in_p1;
28: procedure rosetta_table_copy_out_p1(t cac_view_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , a2 out nocopy JTF_VARCHAR2_TABLE_400
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: ) as
33: ddindx binary_integer; indx binary_integer;

Line 31: , a3 out nocopy JTF_VARCHAR2_TABLE_100

27: end rosetta_table_copy_in_p1;
28: procedure rosetta_table_copy_out_p1(t cac_view_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , a2 out nocopy JTF_VARCHAR2_TABLE_400
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
35: if t is null or t.count = 0 then

Line 37: a1 := JTF_VARCHAR2_TABLE_100();

33: ddindx binary_integer; indx binary_integer;
34: begin
35: if t is null or t.count = 0 then
36: a0 := JTF_NUMBER_TABLE();
37: a1 := JTF_VARCHAR2_TABLE_100();
38: a2 := JTF_VARCHAR2_TABLE_400();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_NUMBER_TABLE();

Line 39: a3 := JTF_VARCHAR2_TABLE_100();

35: if t is null or t.count = 0 then
36: a0 := JTF_NUMBER_TABLE();
37: a1 := JTF_VARCHAR2_TABLE_100();
38: a2 := JTF_VARCHAR2_TABLE_400();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_100();
43: a2 := JTF_VARCHAR2_TABLE_400();

Line 42: a1 := JTF_VARCHAR2_TABLE_100();

38: a2 := JTF_VARCHAR2_TABLE_400();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_100();
43: a2 := JTF_VARCHAR2_TABLE_400();
44: a3 := JTF_VARCHAR2_TABLE_100();
45: if t.count > 0 then
46: a0.extend(t.count);

Line 44: a3 := JTF_VARCHAR2_TABLE_100();

40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_100();
43: a2 := JTF_VARCHAR2_TABLE_400();
44: a3 := JTF_VARCHAR2_TABLE_100();
45: if t.count > 0 then
46: a0.extend(t.count);
47: a1.extend(t.count);
48: a2.extend(t.count);

Line 69: , a2 JTF_VARCHAR2_TABLE_100

65: end rosetta_table_copy_out_p1;
66:
67: procedure rosetta_table_copy_in_p4(t out nocopy cac_view_pvt.queryouttab, a0 JTF_NUMBER_TABLE
68: , a1 JTF_NUMBER_TABLE
69: , a2 JTF_VARCHAR2_TABLE_100
70: , a3 JTF_VARCHAR2_TABLE_2000
71: , a4 JTF_VARCHAR2_TABLE_2000
72: , a5 JTF_VARCHAR2_TABLE_100
73: , a6 JTF_NUMBER_TABLE

Line 72: , a5 JTF_VARCHAR2_TABLE_100

68: , a1 JTF_NUMBER_TABLE
69: , a2 JTF_VARCHAR2_TABLE_100
70: , a3 JTF_VARCHAR2_TABLE_2000
71: , a4 JTF_VARCHAR2_TABLE_2000
72: , a5 JTF_VARCHAR2_TABLE_100
73: , a6 JTF_NUMBER_TABLE
74: , a7 JTF_NUMBER_TABLE
75: , a8 JTF_NUMBER_TABLE
76: , a9 JTF_NUMBER_TABLE

Line 79: , a12 JTF_VARCHAR2_TABLE_100

75: , a8 JTF_NUMBER_TABLE
76: , a9 JTF_NUMBER_TABLE
77: , a10 JTF_NUMBER_TABLE
78: , a11 JTF_DATE_TABLE
79: , a12 JTF_VARCHAR2_TABLE_100
80: , a13 JTF_DATE_TABLE
81: , a14 JTF_VARCHAR2_TABLE_2000
82: , a15 JTF_VARCHAR2_TABLE_2000
83: , a16 JTF_VARCHAR2_TABLE_2000

Line 85: , a18 JTF_VARCHAR2_TABLE_100

81: , a14 JTF_VARCHAR2_TABLE_2000
82: , a15 JTF_VARCHAR2_TABLE_2000
83: , a16 JTF_VARCHAR2_TABLE_2000
84: , a17 JTF_VARCHAR2_TABLE_4000
85: , a18 JTF_VARCHAR2_TABLE_100
86: , a19 JTF_VARCHAR2_TABLE_100
87: , a20 JTF_VARCHAR2_TABLE_100
88: , a21 JTF_VARCHAR2_TABLE_100
89: , a22 JTF_VARCHAR2_TABLE_100

Line 86: , a19 JTF_VARCHAR2_TABLE_100

82: , a15 JTF_VARCHAR2_TABLE_2000
83: , a16 JTF_VARCHAR2_TABLE_2000
84: , a17 JTF_VARCHAR2_TABLE_4000
85: , a18 JTF_VARCHAR2_TABLE_100
86: , a19 JTF_VARCHAR2_TABLE_100
87: , a20 JTF_VARCHAR2_TABLE_100
88: , a21 JTF_VARCHAR2_TABLE_100
89: , a22 JTF_VARCHAR2_TABLE_100
90: , a23 JTF_VARCHAR2_TABLE_400

Line 87: , a20 JTF_VARCHAR2_TABLE_100

83: , a16 JTF_VARCHAR2_TABLE_2000
84: , a17 JTF_VARCHAR2_TABLE_4000
85: , a18 JTF_VARCHAR2_TABLE_100
86: , a19 JTF_VARCHAR2_TABLE_100
87: , a20 JTF_VARCHAR2_TABLE_100
88: , a21 JTF_VARCHAR2_TABLE_100
89: , a22 JTF_VARCHAR2_TABLE_100
90: , a23 JTF_VARCHAR2_TABLE_400
91: , a24 JTF_VARCHAR2_TABLE_4000

Line 88: , a21 JTF_VARCHAR2_TABLE_100

84: , a17 JTF_VARCHAR2_TABLE_4000
85: , a18 JTF_VARCHAR2_TABLE_100
86: , a19 JTF_VARCHAR2_TABLE_100
87: , a20 JTF_VARCHAR2_TABLE_100
88: , a21 JTF_VARCHAR2_TABLE_100
89: , a22 JTF_VARCHAR2_TABLE_100
90: , a23 JTF_VARCHAR2_TABLE_400
91: , a24 JTF_VARCHAR2_TABLE_4000
92: , a25 JTF_NUMBER_TABLE

Line 89: , a22 JTF_VARCHAR2_TABLE_100

85: , a18 JTF_VARCHAR2_TABLE_100
86: , a19 JTF_VARCHAR2_TABLE_100
87: , a20 JTF_VARCHAR2_TABLE_100
88: , a21 JTF_VARCHAR2_TABLE_100
89: , a22 JTF_VARCHAR2_TABLE_100
90: , a23 JTF_VARCHAR2_TABLE_400
91: , a24 JTF_VARCHAR2_TABLE_4000
92: , a25 JTF_NUMBER_TABLE
93: , a26 JTF_VARCHAR2_TABLE_100

Line 93: , a26 JTF_VARCHAR2_TABLE_100

89: , a22 JTF_VARCHAR2_TABLE_100
90: , a23 JTF_VARCHAR2_TABLE_400
91: , a24 JTF_VARCHAR2_TABLE_4000
92: , a25 JTF_NUMBER_TABLE
93: , a26 JTF_VARCHAR2_TABLE_100
94: , a27 JTF_VARCHAR2_TABLE_100
95: ) as
96: ddindx binary_integer; indx binary_integer;
97: begin

Line 94: , a27 JTF_VARCHAR2_TABLE_100

90: , a23 JTF_VARCHAR2_TABLE_400
91: , a24 JTF_VARCHAR2_TABLE_4000
92: , a25 JTF_NUMBER_TABLE
93: , a26 JTF_VARCHAR2_TABLE_100
94: , a27 JTF_VARCHAR2_TABLE_100
95: ) as
96: ddindx binary_integer; indx binary_integer;
97: begin
98: if a0 is not null and a0.count > 0 then

Line 142: , a2 out nocopy JTF_VARCHAR2_TABLE_100

138: end if;
139: end rosetta_table_copy_in_p4;
140: procedure rosetta_table_copy_out_p4(t cac_view_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , a6 out nocopy JTF_NUMBER_TABLE

Line 145: , a5 out nocopy JTF_VARCHAR2_TABLE_100

141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , a6 out nocopy JTF_NUMBER_TABLE
147: , a7 out nocopy JTF_NUMBER_TABLE
148: , a8 out nocopy JTF_NUMBER_TABLE
149: , a9 out nocopy JTF_NUMBER_TABLE

Line 152: , a12 out nocopy JTF_VARCHAR2_TABLE_100

148: , a8 out nocopy JTF_NUMBER_TABLE
149: , a9 out nocopy JTF_NUMBER_TABLE
150: , a10 out nocopy JTF_NUMBER_TABLE
151: , a11 out nocopy JTF_DATE_TABLE
152: , a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , a13 out nocopy JTF_DATE_TABLE
154: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
155: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a16 out nocopy JTF_VARCHAR2_TABLE_2000

Line 158: , a18 out nocopy JTF_VARCHAR2_TABLE_100

154: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
155: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
158: , a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , a19 out nocopy JTF_VARCHAR2_TABLE_100
160: , a20 out nocopy JTF_VARCHAR2_TABLE_100
161: , a21 out nocopy JTF_VARCHAR2_TABLE_100
162: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 159: , a19 out nocopy JTF_VARCHAR2_TABLE_100

155: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
158: , a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , a19 out nocopy JTF_VARCHAR2_TABLE_100
160: , a20 out nocopy JTF_VARCHAR2_TABLE_100
161: , a21 out nocopy JTF_VARCHAR2_TABLE_100
162: , a22 out nocopy JTF_VARCHAR2_TABLE_100
163: , a23 out nocopy JTF_VARCHAR2_TABLE_400

Line 160: , a20 out nocopy JTF_VARCHAR2_TABLE_100

156: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
158: , a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , a19 out nocopy JTF_VARCHAR2_TABLE_100
160: , a20 out nocopy JTF_VARCHAR2_TABLE_100
161: , a21 out nocopy JTF_VARCHAR2_TABLE_100
162: , a22 out nocopy JTF_VARCHAR2_TABLE_100
163: , a23 out nocopy JTF_VARCHAR2_TABLE_400
164: , a24 out nocopy JTF_VARCHAR2_TABLE_4000

Line 161: , a21 out nocopy JTF_VARCHAR2_TABLE_100

157: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
158: , a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , a19 out nocopy JTF_VARCHAR2_TABLE_100
160: , a20 out nocopy JTF_VARCHAR2_TABLE_100
161: , a21 out nocopy JTF_VARCHAR2_TABLE_100
162: , a22 out nocopy JTF_VARCHAR2_TABLE_100
163: , a23 out nocopy JTF_VARCHAR2_TABLE_400
164: , a24 out nocopy JTF_VARCHAR2_TABLE_4000
165: , a25 out nocopy JTF_NUMBER_TABLE

Line 162: , a22 out nocopy JTF_VARCHAR2_TABLE_100

158: , a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , a19 out nocopy JTF_VARCHAR2_TABLE_100
160: , a20 out nocopy JTF_VARCHAR2_TABLE_100
161: , a21 out nocopy JTF_VARCHAR2_TABLE_100
162: , a22 out nocopy JTF_VARCHAR2_TABLE_100
163: , a23 out nocopy JTF_VARCHAR2_TABLE_400
164: , a24 out nocopy JTF_VARCHAR2_TABLE_4000
165: , a25 out nocopy JTF_NUMBER_TABLE
166: , a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 166: , a26 out nocopy JTF_VARCHAR2_TABLE_100

162: , a22 out nocopy JTF_VARCHAR2_TABLE_100
163: , a23 out nocopy JTF_VARCHAR2_TABLE_400
164: , a24 out nocopy JTF_VARCHAR2_TABLE_4000
165: , a25 out nocopy JTF_NUMBER_TABLE
166: , a26 out nocopy JTF_VARCHAR2_TABLE_100
167: , a27 out nocopy JTF_VARCHAR2_TABLE_100
168: ) as
169: ddindx binary_integer; indx binary_integer;
170: begin

Line 167: , a27 out nocopy JTF_VARCHAR2_TABLE_100

163: , a23 out nocopy JTF_VARCHAR2_TABLE_400
164: , a24 out nocopy JTF_VARCHAR2_TABLE_4000
165: , a25 out nocopy JTF_NUMBER_TABLE
166: , a26 out nocopy JTF_VARCHAR2_TABLE_100
167: , a27 out nocopy JTF_VARCHAR2_TABLE_100
168: ) as
169: ddindx binary_integer; indx binary_integer;
170: begin
171: if t is null or t.count = 0 then

Line 174: a2 := JTF_VARCHAR2_TABLE_100();

170: begin
171: if t is null or t.count = 0 then
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_2000();
176: a4 := JTF_VARCHAR2_TABLE_2000();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_NUMBER_TABLE();

Line 177: a5 := JTF_VARCHAR2_TABLE_100();

173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_2000();
176: a4 := JTF_VARCHAR2_TABLE_2000();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_NUMBER_TABLE();
181: a9 := JTF_NUMBER_TABLE();

Line 184: a12 := JTF_VARCHAR2_TABLE_100();

180: a8 := JTF_NUMBER_TABLE();
181: a9 := JTF_NUMBER_TABLE();
182: a10 := JTF_NUMBER_TABLE();
183: a11 := JTF_DATE_TABLE();
184: a12 := JTF_VARCHAR2_TABLE_100();
185: a13 := JTF_DATE_TABLE();
186: a14 := JTF_VARCHAR2_TABLE_2000();
187: a15 := JTF_VARCHAR2_TABLE_2000();
188: a16 := JTF_VARCHAR2_TABLE_2000();

Line 190: a18 := JTF_VARCHAR2_TABLE_100();

186: a14 := JTF_VARCHAR2_TABLE_2000();
187: a15 := JTF_VARCHAR2_TABLE_2000();
188: a16 := JTF_VARCHAR2_TABLE_2000();
189: a17 := JTF_VARCHAR2_TABLE_4000();
190: a18 := JTF_VARCHAR2_TABLE_100();
191: a19 := JTF_VARCHAR2_TABLE_100();
192: a20 := JTF_VARCHAR2_TABLE_100();
193: a21 := JTF_VARCHAR2_TABLE_100();
194: a22 := JTF_VARCHAR2_TABLE_100();

Line 191: a19 := JTF_VARCHAR2_TABLE_100();

187: a15 := JTF_VARCHAR2_TABLE_2000();
188: a16 := JTF_VARCHAR2_TABLE_2000();
189: a17 := JTF_VARCHAR2_TABLE_4000();
190: a18 := JTF_VARCHAR2_TABLE_100();
191: a19 := JTF_VARCHAR2_TABLE_100();
192: a20 := JTF_VARCHAR2_TABLE_100();
193: a21 := JTF_VARCHAR2_TABLE_100();
194: a22 := JTF_VARCHAR2_TABLE_100();
195: a23 := JTF_VARCHAR2_TABLE_400();

Line 192: a20 := JTF_VARCHAR2_TABLE_100();

188: a16 := JTF_VARCHAR2_TABLE_2000();
189: a17 := JTF_VARCHAR2_TABLE_4000();
190: a18 := JTF_VARCHAR2_TABLE_100();
191: a19 := JTF_VARCHAR2_TABLE_100();
192: a20 := JTF_VARCHAR2_TABLE_100();
193: a21 := JTF_VARCHAR2_TABLE_100();
194: a22 := JTF_VARCHAR2_TABLE_100();
195: a23 := JTF_VARCHAR2_TABLE_400();
196: a24 := JTF_VARCHAR2_TABLE_4000();

Line 193: a21 := JTF_VARCHAR2_TABLE_100();

189: a17 := JTF_VARCHAR2_TABLE_4000();
190: a18 := JTF_VARCHAR2_TABLE_100();
191: a19 := JTF_VARCHAR2_TABLE_100();
192: a20 := JTF_VARCHAR2_TABLE_100();
193: a21 := JTF_VARCHAR2_TABLE_100();
194: a22 := JTF_VARCHAR2_TABLE_100();
195: a23 := JTF_VARCHAR2_TABLE_400();
196: a24 := JTF_VARCHAR2_TABLE_4000();
197: a25 := JTF_NUMBER_TABLE();

Line 194: a22 := JTF_VARCHAR2_TABLE_100();

190: a18 := JTF_VARCHAR2_TABLE_100();
191: a19 := JTF_VARCHAR2_TABLE_100();
192: a20 := JTF_VARCHAR2_TABLE_100();
193: a21 := JTF_VARCHAR2_TABLE_100();
194: a22 := JTF_VARCHAR2_TABLE_100();
195: a23 := JTF_VARCHAR2_TABLE_400();
196: a24 := JTF_VARCHAR2_TABLE_4000();
197: a25 := JTF_NUMBER_TABLE();
198: a26 := JTF_VARCHAR2_TABLE_100();

Line 198: a26 := JTF_VARCHAR2_TABLE_100();

194: a22 := JTF_VARCHAR2_TABLE_100();
195: a23 := JTF_VARCHAR2_TABLE_400();
196: a24 := JTF_VARCHAR2_TABLE_4000();
197: a25 := JTF_NUMBER_TABLE();
198: a26 := JTF_VARCHAR2_TABLE_100();
199: a27 := JTF_VARCHAR2_TABLE_100();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();

Line 199: a27 := JTF_VARCHAR2_TABLE_100();

195: a23 := JTF_VARCHAR2_TABLE_400();
196: a24 := JTF_VARCHAR2_TABLE_4000();
197: a25 := JTF_NUMBER_TABLE();
198: a26 := JTF_VARCHAR2_TABLE_100();
199: a27 := JTF_VARCHAR2_TABLE_100();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_100();

Line 203: a2 := JTF_VARCHAR2_TABLE_100();

199: a27 := JTF_VARCHAR2_TABLE_100();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_VARCHAR2_TABLE_2000();
205: a4 := JTF_VARCHAR2_TABLE_2000();
206: a5 := JTF_VARCHAR2_TABLE_100();
207: a6 := JTF_NUMBER_TABLE();

Line 206: a5 := JTF_VARCHAR2_TABLE_100();

202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_VARCHAR2_TABLE_2000();
205: a4 := JTF_VARCHAR2_TABLE_2000();
206: a5 := JTF_VARCHAR2_TABLE_100();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_NUMBER_TABLE();
209: a8 := JTF_NUMBER_TABLE();
210: a9 := JTF_NUMBER_TABLE();

Line 213: a12 := JTF_VARCHAR2_TABLE_100();

209: a8 := JTF_NUMBER_TABLE();
210: a9 := JTF_NUMBER_TABLE();
211: a10 := JTF_NUMBER_TABLE();
212: a11 := JTF_DATE_TABLE();
213: a12 := JTF_VARCHAR2_TABLE_100();
214: a13 := JTF_DATE_TABLE();
215: a14 := JTF_VARCHAR2_TABLE_2000();
216: a15 := JTF_VARCHAR2_TABLE_2000();
217: a16 := JTF_VARCHAR2_TABLE_2000();

Line 219: a18 := JTF_VARCHAR2_TABLE_100();

215: a14 := JTF_VARCHAR2_TABLE_2000();
216: a15 := JTF_VARCHAR2_TABLE_2000();
217: a16 := JTF_VARCHAR2_TABLE_2000();
218: a17 := JTF_VARCHAR2_TABLE_4000();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();
223: a22 := JTF_VARCHAR2_TABLE_100();

Line 220: a19 := JTF_VARCHAR2_TABLE_100();

216: a15 := JTF_VARCHAR2_TABLE_2000();
217: a16 := JTF_VARCHAR2_TABLE_2000();
218: a17 := JTF_VARCHAR2_TABLE_4000();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();
223: a22 := JTF_VARCHAR2_TABLE_100();
224: a23 := JTF_VARCHAR2_TABLE_400();

Line 221: a20 := JTF_VARCHAR2_TABLE_100();

217: a16 := JTF_VARCHAR2_TABLE_2000();
218: a17 := JTF_VARCHAR2_TABLE_4000();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();
223: a22 := JTF_VARCHAR2_TABLE_100();
224: a23 := JTF_VARCHAR2_TABLE_400();
225: a24 := JTF_VARCHAR2_TABLE_4000();

Line 222: a21 := JTF_VARCHAR2_TABLE_100();

218: a17 := JTF_VARCHAR2_TABLE_4000();
219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();
223: a22 := JTF_VARCHAR2_TABLE_100();
224: a23 := JTF_VARCHAR2_TABLE_400();
225: a24 := JTF_VARCHAR2_TABLE_4000();
226: a25 := JTF_NUMBER_TABLE();

Line 223: a22 := JTF_VARCHAR2_TABLE_100();

219: a18 := JTF_VARCHAR2_TABLE_100();
220: a19 := JTF_VARCHAR2_TABLE_100();
221: a20 := JTF_VARCHAR2_TABLE_100();
222: a21 := JTF_VARCHAR2_TABLE_100();
223: a22 := JTF_VARCHAR2_TABLE_100();
224: a23 := JTF_VARCHAR2_TABLE_400();
225: a24 := JTF_VARCHAR2_TABLE_4000();
226: a25 := JTF_NUMBER_TABLE();
227: a26 := JTF_VARCHAR2_TABLE_100();

Line 227: a26 := JTF_VARCHAR2_TABLE_100();

223: a22 := JTF_VARCHAR2_TABLE_100();
224: a23 := JTF_VARCHAR2_TABLE_400();
225: a24 := JTF_VARCHAR2_TABLE_4000();
226: a25 := JTF_NUMBER_TABLE();
227: a26 := JTF_VARCHAR2_TABLE_100();
228: a27 := JTF_VARCHAR2_TABLE_100();
229: if t.count > 0 then
230: a0.extend(t.count);
231: a1.extend(t.count);

Line 228: a27 := JTF_VARCHAR2_TABLE_100();

224: a23 := JTF_VARCHAR2_TABLE_400();
225: a24 := JTF_VARCHAR2_TABLE_4000();
226: a25 := JTF_NUMBER_TABLE();
227: a26 := JTF_VARCHAR2_TABLE_100();
228: a27 := JTF_VARCHAR2_TABLE_100();
229: if t.count > 0 then
230: a0.extend(t.count);
231: a1.extend(t.count);
232: a2.extend(t.count);

Line 309: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

305: , p_resourceid in out nocopy NUMBER
306: , p_resourcetype in out nocopy VARCHAR2
307: , p_userid NUMBER
308: , p9_a0 out nocopy JTF_NUMBER_TABLE
309: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
310: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
311: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
312: )
313:

Line 311: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

307: , p_userid NUMBER
308: , p9_a0 out nocopy JTF_NUMBER_TABLE
309: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
310: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
311: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
312: )
313:
314: as
315: ddx_calendarlist cac_view_pvt.callsttbltype;

Line 401: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

397: , p6_a32 CHAR
398: , p6_a33 NUMBER
399: , p7_a0 out nocopy JTF_NUMBER_TABLE
400: , p7_a1 out nocopy JTF_NUMBER_TABLE
401: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
402: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000
403: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
404: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
405: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 404: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

400: , p7_a1 out nocopy JTF_NUMBER_TABLE
401: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
402: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000
403: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
404: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
405: , p7_a6 out nocopy JTF_NUMBER_TABLE
406: , p7_a7 out nocopy JTF_NUMBER_TABLE
407: , p7_a8 out nocopy JTF_NUMBER_TABLE
408: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 411: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100

407: , p7_a8 out nocopy JTF_NUMBER_TABLE
408: , p7_a9 out nocopy JTF_NUMBER_TABLE
409: , p7_a10 out nocopy JTF_NUMBER_TABLE
410: , p7_a11 out nocopy JTF_DATE_TABLE
411: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
412: , p7_a13 out nocopy JTF_DATE_TABLE
413: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000

Line 417: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

413: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
416: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
417: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
418: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
419: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
421: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 418: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

414: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
416: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
417: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
418: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
419: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
421: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
422: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400

Line 419: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100

415: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
416: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
417: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
418: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
419: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
421: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
422: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
423: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000

Line 420: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100

416: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
417: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
418: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
419: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
421: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
422: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
423: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000
424: , p7_a25 out nocopy JTF_NUMBER_TABLE

Line 421: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

417: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
418: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
419: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
421: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
422: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
423: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000
424: , p7_a25 out nocopy JTF_NUMBER_TABLE
425: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 425: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

421: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
422: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
423: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000
424: , p7_a25 out nocopy JTF_NUMBER_TABLE
425: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
426: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
427: )
428:
429: as

Line 426: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100

422: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
423: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000
424: , p7_a25 out nocopy JTF_NUMBER_TABLE
425: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
426: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
427: )
428:
429: as
430: ddp_input cac_view_pvt.queryin;