[Home] [Help]
PACKAGE: APPS.AMV_CHANNEL_PVT_W
Source
1 package amv_channel_pvt_w as
2 /* $Header: amvwchas.pls 120.2 2005/06/30 07:50 appldev ship $ */
3 procedure rosetta_table_copy_in_p0(t out nocopy amv_channel_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4 procedure rosetta_table_copy_out_p0(t amv_channel_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5
6 procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7 procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8
9 procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE
10 , a1 JTF_NUMBER_TABLE
11 , a2 JTF_VARCHAR2_TABLE_100
12 , a3 JTF_VARCHAR2_TABLE_2000
13 , a4 JTF_VARCHAR2_TABLE_100
14 , a5 JTF_NUMBER_TABLE
15 , a6 JTF_VARCHAR2_TABLE_100
16 , a7 JTF_NUMBER_TABLE
17 , a8 JTF_NUMBER_TABLE
18 , a9 JTF_DATE_TABLE
19 , a10 JTF_DATE_TABLE
20 , a11 JTF_VARCHAR2_TABLE_100
21 , a12 JTF_VARCHAR2_TABLE_100
22 , a13 JTF_VARCHAR2_TABLE_100
23 , a14 JTF_VARCHAR2_TABLE_100
24 , a15 JTF_VARCHAR2_TABLE_100
25 , a16 JTF_VARCHAR2_TABLE_100
26 , a17 JTF_VARCHAR2_TABLE_100
27 , a18 JTF_VARCHAR2_TABLE_100
28 , a19 JTF_VARCHAR2_TABLE_100
29 , a20 JTF_VARCHAR2_TABLE_100
30 , a21 JTF_NUMBER_TABLE
31 , a22 JTF_VARCHAR2_TABLE_100
32 , a23 JTF_NUMBER_TABLE
33 , a24 JTF_DATE_TABLE
34 , a25 JTF_VARCHAR2_TABLE_100
35 , a26 JTF_DATE_TABLE
36 , a27 JTF_VARCHAR2_TABLE_100
37 , a28 JTF_VARCHAR2_TABLE_200
38 , a29 JTF_VARCHAR2_TABLE_200
39 , a30 JTF_VARCHAR2_TABLE_200
40 , a31 JTF_VARCHAR2_TABLE_200
41 , a32 JTF_VARCHAR2_TABLE_200
42 , a33 JTF_VARCHAR2_TABLE_200
43 , a34 JTF_VARCHAR2_TABLE_200
44 , a35 JTF_VARCHAR2_TABLE_200
45 , a36 JTF_VARCHAR2_TABLE_200
46 , a37 JTF_VARCHAR2_TABLE_200
47 , a38 JTF_VARCHAR2_TABLE_200
48 , a39 JTF_VARCHAR2_TABLE_200
49 , a40 JTF_VARCHAR2_TABLE_200
50 , a41 JTF_VARCHAR2_TABLE_200
51 , a42 JTF_VARCHAR2_TABLE_200
52 );
53 procedure rosetta_table_copy_out_p5(t amv_channel_pvt.amv_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
54 , a1 out nocopy JTF_NUMBER_TABLE
55 , a2 out nocopy JTF_VARCHAR2_TABLE_100
56 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
57 , a4 out nocopy JTF_VARCHAR2_TABLE_100
58 , a5 out nocopy JTF_NUMBER_TABLE
59 , a6 out nocopy JTF_VARCHAR2_TABLE_100
60 , a7 out nocopy JTF_NUMBER_TABLE
61 , a8 out nocopy JTF_NUMBER_TABLE
62 , a9 out nocopy JTF_DATE_TABLE
63 , a10 out nocopy JTF_DATE_TABLE
64 , a11 out nocopy JTF_VARCHAR2_TABLE_100
65 , a12 out nocopy JTF_VARCHAR2_TABLE_100
66 , a13 out nocopy JTF_VARCHAR2_TABLE_100
67 , a14 out nocopy JTF_VARCHAR2_TABLE_100
68 , a15 out nocopy JTF_VARCHAR2_TABLE_100
69 , a16 out nocopy JTF_VARCHAR2_TABLE_100
70 , a17 out nocopy JTF_VARCHAR2_TABLE_100
71 , a18 out nocopy JTF_VARCHAR2_TABLE_100
72 , a19 out nocopy JTF_VARCHAR2_TABLE_100
73 , a20 out nocopy JTF_VARCHAR2_TABLE_100
74 , a21 out nocopy JTF_NUMBER_TABLE
75 , a22 out nocopy JTF_VARCHAR2_TABLE_100
76 , a23 out nocopy JTF_NUMBER_TABLE
77 , a24 out nocopy JTF_DATE_TABLE
78 , a25 out nocopy JTF_VARCHAR2_TABLE_100
79 , a26 out nocopy JTF_DATE_TABLE
80 , a27 out nocopy JTF_VARCHAR2_TABLE_100
81 , a28 out nocopy JTF_VARCHAR2_TABLE_200
82 , a29 out nocopy JTF_VARCHAR2_TABLE_200
83 , a30 out nocopy JTF_VARCHAR2_TABLE_200
84 , a31 out nocopy JTF_VARCHAR2_TABLE_200
85 , a32 out nocopy JTF_VARCHAR2_TABLE_200
86 , a33 out nocopy JTF_VARCHAR2_TABLE_200
87 , a34 out nocopy JTF_VARCHAR2_TABLE_200
88 , a35 out nocopy JTF_VARCHAR2_TABLE_200
89 , a36 out nocopy JTF_VARCHAR2_TABLE_200
90 , a37 out nocopy JTF_VARCHAR2_TABLE_200
91 , a38 out nocopy JTF_VARCHAR2_TABLE_200
92 , a39 out nocopy JTF_VARCHAR2_TABLE_200
93 , a40 out nocopy JTF_VARCHAR2_TABLE_200
94 , a41 out nocopy JTF_VARCHAR2_TABLE_200
95 , a42 out nocopy JTF_VARCHAR2_TABLE_200
96 );
97
98 procedure add_channel(p_api_version NUMBER
99 , p_init_msg_list VARCHAR2
100 , p_commit VARCHAR2
101 , p_validation_level NUMBER
102 , x_return_status out nocopy VARCHAR2
103 , x_msg_count out nocopy NUMBER
104 , x_msg_data out nocopy VARCHAR2
105 , p_check_login_user VARCHAR2
106 , x_channel_id out nocopy NUMBER
107 , p8_a0 NUMBER := 0-1962.0724
108 , p8_a1 NUMBER := 0-1962.0724
109 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
110 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
111 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
112 , p8_a5 NUMBER := 0-1962.0724
113 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
114 , p8_a7 NUMBER := 0-1962.0724
115 , p8_a8 NUMBER := 0-1962.0724
116 , p8_a9 DATE := fnd_api.g_miss_date
117 , p8_a10 DATE := fnd_api.g_miss_date
118 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
119 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
120 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
121 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
122 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
123 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
124 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
125 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
126 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
127 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
128 , p8_a21 NUMBER := 0-1962.0724
129 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
130 , p8_a23 NUMBER := 0-1962.0724
131 , p8_a24 DATE := fnd_api.g_miss_date
132 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
133 , p8_a26 DATE := fnd_api.g_miss_date
134 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
135 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
136 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
137 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
138 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
139 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
140 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
141 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
142 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
143 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
144 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
145 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
146 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
147 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
148 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
149 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
150 );
151 procedure add_publicchannel(p_api_version NUMBER
152 , p_init_msg_list VARCHAR2
153 , p_commit VARCHAR2
154 , p_validation_level NUMBER
155 , x_return_status out nocopy VARCHAR2
156 , x_msg_count out nocopy NUMBER
157 , x_msg_data out nocopy VARCHAR2
158 , p_check_login_user VARCHAR2
159 , x_channel_id out nocopy NUMBER
160 , p8_a0 NUMBER := 0-1962.0724
161 , p8_a1 NUMBER := 0-1962.0724
162 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
163 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
164 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
165 , p8_a5 NUMBER := 0-1962.0724
166 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
167 , p8_a7 NUMBER := 0-1962.0724
168 , p8_a8 NUMBER := 0-1962.0724
169 , p8_a9 DATE := fnd_api.g_miss_date
170 , p8_a10 DATE := fnd_api.g_miss_date
171 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
172 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
173 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
174 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
175 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
176 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
177 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
178 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
179 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
180 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
181 , p8_a21 NUMBER := 0-1962.0724
182 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
183 , p8_a23 NUMBER := 0-1962.0724
184 , p8_a24 DATE := fnd_api.g_miss_date
185 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
186 , p8_a26 DATE := fnd_api.g_miss_date
187 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
188 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
189 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
190 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
191 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
192 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
193 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
194 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
195 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
196 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
197 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
198 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
199 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
200 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
201 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
202 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
203 );
204 procedure add_protectedchannel(p_api_version NUMBER
205 , p_init_msg_list VARCHAR2
206 , p_commit VARCHAR2
207 , p_validation_level NUMBER
208 , x_return_status out nocopy VARCHAR2
209 , x_msg_count out nocopy NUMBER
210 , x_msg_data out nocopy VARCHAR2
211 , p_check_login_user VARCHAR2
212 , x_channel_id out nocopy NUMBER
213 , p8_a0 NUMBER := 0-1962.0724
214 , p8_a1 NUMBER := 0-1962.0724
215 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
216 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
217 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
218 , p8_a5 NUMBER := 0-1962.0724
219 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
220 , p8_a7 NUMBER := 0-1962.0724
221 , p8_a8 NUMBER := 0-1962.0724
222 , p8_a9 DATE := fnd_api.g_miss_date
223 , p8_a10 DATE := fnd_api.g_miss_date
224 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
225 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
226 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
227 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
228 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
229 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
230 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
231 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
232 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
233 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
234 , p8_a21 NUMBER := 0-1962.0724
235 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
236 , p8_a23 NUMBER := 0-1962.0724
237 , p8_a24 DATE := fnd_api.g_miss_date
238 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
239 , p8_a26 DATE := fnd_api.g_miss_date
240 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
241 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
242 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
243 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
244 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
245 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
246 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
247 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
248 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
249 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
250 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
251 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
252 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
253 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
254 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
255 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
256 );
257 procedure add_privatechannel(p_api_version NUMBER
258 , p_init_msg_list VARCHAR2
259 , p_commit VARCHAR2
260 , p_validation_level NUMBER
261 , x_return_status out nocopy VARCHAR2
262 , x_msg_count out nocopy NUMBER
263 , x_msg_data out nocopy VARCHAR2
264 , p_check_login_user VARCHAR2
265 , x_channel_id out nocopy NUMBER
266 , p8_a0 NUMBER := 0-1962.0724
267 , p8_a1 NUMBER := 0-1962.0724
268 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
269 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
270 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
271 , p8_a5 NUMBER := 0-1962.0724
272 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
273 , p8_a7 NUMBER := 0-1962.0724
274 , p8_a8 NUMBER := 0-1962.0724
275 , p8_a9 DATE := fnd_api.g_miss_date
276 , p8_a10 DATE := fnd_api.g_miss_date
277 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
278 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
279 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
280 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
281 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
282 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
283 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
284 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
285 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
286 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
287 , p8_a21 NUMBER := 0-1962.0724
288 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
289 , p8_a23 NUMBER := 0-1962.0724
290 , p8_a24 DATE := fnd_api.g_miss_date
291 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
292 , p8_a26 DATE := fnd_api.g_miss_date
293 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
294 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
295 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
296 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
297 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
298 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
299 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
300 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
301 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
302 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
303 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
304 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
305 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
306 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
307 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
308 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
309 );
310 procedure add_groupchannel(p_api_version NUMBER
311 , p_init_msg_list VARCHAR2
312 , p_commit VARCHAR2
313 , p_validation_level NUMBER
314 , x_return_status out nocopy VARCHAR2
315 , x_msg_count out nocopy NUMBER
316 , x_msg_data out nocopy VARCHAR2
317 , p_check_login_user VARCHAR2
318 , p_group_id NUMBER
319 , x_channel_id out nocopy NUMBER
320 , p9_a0 NUMBER := 0-1962.0724
321 , p9_a1 NUMBER := 0-1962.0724
322 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
323 , p9_a3 VARCHAR2 := fnd_api.g_miss_char
324 , p9_a4 VARCHAR2 := fnd_api.g_miss_char
325 , p9_a5 NUMBER := 0-1962.0724
326 , p9_a6 VARCHAR2 := fnd_api.g_miss_char
327 , p9_a7 NUMBER := 0-1962.0724
328 , p9_a8 NUMBER := 0-1962.0724
329 , p9_a9 DATE := fnd_api.g_miss_date
330 , p9_a10 DATE := fnd_api.g_miss_date
331 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
332 , p9_a12 VARCHAR2 := fnd_api.g_miss_char
333 , p9_a13 VARCHAR2 := fnd_api.g_miss_char
334 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
335 , p9_a15 VARCHAR2 := fnd_api.g_miss_char
336 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
337 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
338 , p9_a18 VARCHAR2 := fnd_api.g_miss_char
339 , p9_a19 VARCHAR2 := fnd_api.g_miss_char
340 , p9_a20 VARCHAR2 := fnd_api.g_miss_char
341 , p9_a21 NUMBER := 0-1962.0724
342 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
343 , p9_a23 NUMBER := 0-1962.0724
344 , p9_a24 DATE := fnd_api.g_miss_date
345 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
346 , p9_a26 DATE := fnd_api.g_miss_date
347 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
348 , p9_a28 VARCHAR2 := fnd_api.g_miss_char
349 , p9_a29 VARCHAR2 := fnd_api.g_miss_char
350 , p9_a30 VARCHAR2 := fnd_api.g_miss_char
351 , p9_a31 VARCHAR2 := fnd_api.g_miss_char
352 , p9_a32 VARCHAR2 := fnd_api.g_miss_char
353 , p9_a33 VARCHAR2 := fnd_api.g_miss_char
354 , p9_a34 VARCHAR2 := fnd_api.g_miss_char
355 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
356 , p9_a36 VARCHAR2 := fnd_api.g_miss_char
357 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
358 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
362 , p9_a42 VARCHAR2 := fnd_api.g_miss_char
359 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
360 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
361 , p9_a41 VARCHAR2 := fnd_api.g_miss_char
363 );
364 procedure update_channel(p_api_version NUMBER
365 , p_init_msg_list VARCHAR2
366 , p_commit VARCHAR2
367 , p_validation_level NUMBER
368 , x_return_status out nocopy VARCHAR2
369 , x_msg_count out nocopy NUMBER
370 , x_msg_data out nocopy VARCHAR2
371 , p_check_login_user VARCHAR2
372 , p8_a0 NUMBER := 0-1962.0724
373 , p8_a1 NUMBER := 0-1962.0724
374 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
375 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
376 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
377 , p8_a5 NUMBER := 0-1962.0724
378 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
379 , p8_a7 NUMBER := 0-1962.0724
380 , p8_a8 NUMBER := 0-1962.0724
381 , p8_a9 DATE := fnd_api.g_miss_date
382 , p8_a10 DATE := fnd_api.g_miss_date
383 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
384 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
385 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
386 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
387 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
388 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
389 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
390 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
391 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
392 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
393 , p8_a21 NUMBER := 0-1962.0724
394 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
395 , p8_a23 NUMBER := 0-1962.0724
396 , p8_a24 DATE := fnd_api.g_miss_date
397 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
398 , p8_a26 DATE := fnd_api.g_miss_date
399 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
400 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
401 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
402 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
403 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
404 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
405 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
406 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
407 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
408 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
409 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
410 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
411 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
412 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
413 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
414 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
415 );
416 procedure get_channel(p_api_version NUMBER
417 , p_init_msg_list VARCHAR2
418 , p_validation_level NUMBER
419 , x_return_status out nocopy VARCHAR2
420 , x_msg_count out nocopy NUMBER
421 , x_msg_data out nocopy VARCHAR2
422 , p_check_login_user VARCHAR2
423 , p_channel_id NUMBER
424 , p_channel_name VARCHAR2
425 , p_category_id NUMBER
426 , p10_a0 out nocopy NUMBER
427 , p10_a1 out nocopy NUMBER
428 , p10_a2 out nocopy VARCHAR2
429 , p10_a3 out nocopy VARCHAR2
430 , p10_a4 out nocopy VARCHAR2
431 , p10_a5 out nocopy NUMBER
432 , p10_a6 out nocopy VARCHAR2
433 , p10_a7 out nocopy NUMBER
434 , p10_a8 out nocopy NUMBER
435 , p10_a9 out nocopy DATE
436 , p10_a10 out nocopy DATE
437 , p10_a11 out nocopy VARCHAR2
438 , p10_a12 out nocopy VARCHAR2
439 , p10_a13 out nocopy VARCHAR2
440 , p10_a14 out nocopy VARCHAR2
441 , p10_a15 out nocopy VARCHAR2
442 , p10_a16 out nocopy VARCHAR2
443 , p10_a17 out nocopy VARCHAR2
444 , p10_a18 out nocopy VARCHAR2
445 , p10_a19 out nocopy VARCHAR2
446 , p10_a20 out nocopy VARCHAR2
447 , p10_a21 out nocopy NUMBER
448 , p10_a22 out nocopy VARCHAR2
449 , p10_a23 out nocopy NUMBER
450 , p10_a24 out nocopy DATE
451 , p10_a25 out nocopy VARCHAR2
452 , p10_a26 out nocopy DATE
453 , p10_a27 out nocopy VARCHAR2
454 , p10_a28 out nocopy VARCHAR2
455 , p10_a29 out nocopy VARCHAR2
456 , p10_a30 out nocopy VARCHAR2
457 , p10_a31 out nocopy VARCHAR2
458 , p10_a32 out nocopy VARCHAR2
459 , p10_a33 out nocopy VARCHAR2
460 , p10_a34 out nocopy VARCHAR2
461 , p10_a35 out nocopy VARCHAR2
462 , p10_a36 out nocopy VARCHAR2
463 , p10_a37 out nocopy VARCHAR2
464 , p10_a38 out nocopy VARCHAR2
465 , p10_a39 out nocopy VARCHAR2
466 , p10_a40 out nocopy VARCHAR2
467 , p10_a41 out nocopy VARCHAR2
468 , p10_a42 out nocopy VARCHAR2
469 );
470 procedure set_channelcontenttypes(p_api_version NUMBER
471 , p_init_msg_list VARCHAR2
472 , p_commit VARCHAR2
473 , p_validation_level NUMBER
474 , x_return_status out nocopy VARCHAR2
475 , x_msg_count out nocopy NUMBER
476 , x_msg_data out nocopy VARCHAR2
477 , p_check_login_user VARCHAR2
478 , p_channel_id NUMBER
479 , p_channel_name VARCHAR2
480 , p_category_id NUMBER
481 , p_content_type_id_array JTF_NUMBER_TABLE
482 );
483 procedure get_channelcontenttypes(p_api_version NUMBER
484 , p_init_msg_list VARCHAR2
485 , p_validation_level NUMBER
486 , x_return_status out nocopy VARCHAR2
487 , x_msg_count out nocopy NUMBER
491 , p_channel_name VARCHAR2
488 , x_msg_data out nocopy VARCHAR2
489 , p_check_login_user VARCHAR2
490 , p_channel_id NUMBER
492 , p_category_id NUMBER
493 , x_content_type_id_array out nocopy JTF_NUMBER_TABLE
494 );
495 procedure set_channelperspectives(p_api_version NUMBER
496 , p_init_msg_list VARCHAR2
497 , p_commit VARCHAR2
498 , p_validation_level NUMBER
499 , x_return_status out nocopy VARCHAR2
500 , x_msg_count out nocopy NUMBER
501 , x_msg_data out nocopy VARCHAR2
502 , p_check_login_user VARCHAR2
503 , p_channel_id NUMBER
504 , p_channel_name VARCHAR2
505 , p_category_id NUMBER
506 , p_perspective_id_array JTF_NUMBER_TABLE
507 );
508 procedure get_channelperspectives(p_api_version NUMBER
509 , p_init_msg_list VARCHAR2
510 , p_validation_level NUMBER
511 , x_return_status out nocopy VARCHAR2
512 , x_msg_count out nocopy NUMBER
513 , x_msg_data out nocopy VARCHAR2
514 , p_check_login_user VARCHAR2
515 , p_channel_id NUMBER
516 , p_channel_name VARCHAR2
517 , p_category_id NUMBER
518 , x_perspective_id_array out nocopy JTF_NUMBER_TABLE
519 );
520 procedure set_channelitemtypes(p_api_version NUMBER
521 , p_init_msg_list VARCHAR2
522 , p_commit VARCHAR2
523 , p_validation_level NUMBER
524 , x_return_status out nocopy VARCHAR2
525 , x_msg_count out nocopy NUMBER
526 , x_msg_data out nocopy VARCHAR2
527 , p_check_login_user VARCHAR2
528 , p_channel_id NUMBER
529 , p_channel_name VARCHAR2
530 , p_category_id NUMBER
531 , p_item_type_array JTF_VARCHAR2_TABLE_4000
532 );
533 procedure get_channelitemtypes(p_api_version NUMBER
534 , p_init_msg_list VARCHAR2
535 , p_validation_level NUMBER
536 , x_return_status out nocopy VARCHAR2
537 , x_msg_count out nocopy NUMBER
538 , x_msg_data out nocopy VARCHAR2
539 , p_check_login_user VARCHAR2
540 , p_channel_id NUMBER
541 , p_channel_name VARCHAR2
542 , p_category_id NUMBER
543 , x_item_type_array out nocopy JTF_VARCHAR2_TABLE_4000
544 );
545 procedure set_channelkeywords(p_api_version NUMBER
546 , p_init_msg_list VARCHAR2
547 , p_commit VARCHAR2
548 , p_validation_level NUMBER
549 , x_return_status out nocopy VARCHAR2
550 , x_msg_count out nocopy NUMBER
551 , x_msg_data out nocopy VARCHAR2
552 , p_check_login_user VARCHAR2
553 , p_channel_id NUMBER
554 , p_channel_name VARCHAR2
555 , p_category_id NUMBER
556 , p_keywords_array JTF_VARCHAR2_TABLE_4000
557 );
558 procedure get_channelkeywords(p_api_version NUMBER
559 , p_init_msg_list VARCHAR2
560 , p_validation_level NUMBER
561 , x_return_status out nocopy VARCHAR2
562 , x_msg_count out nocopy NUMBER
563 , x_msg_data out nocopy VARCHAR2
564 , p_check_login_user VARCHAR2
565 , p_channel_id NUMBER
566 , p_channel_name VARCHAR2
567 , p_category_id NUMBER
568 , x_keywords_array out nocopy JTF_VARCHAR2_TABLE_4000
569 );
570 procedure set_channelauthors(p_api_version NUMBER
571 , p_init_msg_list VARCHAR2
572 , p_commit VARCHAR2
573 , p_validation_level NUMBER
574 , x_return_status out nocopy VARCHAR2
575 , x_msg_count out nocopy NUMBER
576 , x_msg_data out nocopy VARCHAR2
577 , p_check_login_user VARCHAR2
578 , p_channel_id NUMBER
579 , p_channel_name VARCHAR2
580 , p_category_id NUMBER
581 , p_authors_array JTF_VARCHAR2_TABLE_4000
582 );
583 procedure get_channelauthors(p_api_version NUMBER
584 , p_init_msg_list VARCHAR2
585 , p_validation_level NUMBER
586 , x_return_status out nocopy VARCHAR2
587 , x_msg_count out nocopy NUMBER
588 , x_msg_data out nocopy VARCHAR2
589 , p_check_login_user VARCHAR2
590 , p_channel_id NUMBER
591 , p_channel_name VARCHAR2
592 , p_category_id NUMBER
593 , x_authors_array out nocopy JTF_VARCHAR2_TABLE_4000
594 );
595 procedure get_itemsperchannel(p_api_version NUMBER
596 , p_init_msg_list VARCHAR2
597 , p_validation_level NUMBER
598 , x_return_status out nocopy VARCHAR2
599 , x_msg_count out nocopy NUMBER
600 , x_msg_data out nocopy VARCHAR2
601 , p_check_login_user VARCHAR2
602 , p_channel_id NUMBER
603 , p_channel_name VARCHAR2
604 , p_category_id NUMBER
605 , p_item_status VARCHAR2
606 , p12_a0 out nocopy NUMBER
607 , p12_a1 out nocopy NUMBER
608 , p12_a2 out nocopy NUMBER
609 , x_document_id_array out nocopy JTF_NUMBER_TABLE
610 , p11_a0 NUMBER := 0-1962.0724
611 , p11_a1 NUMBER := 0-1962.0724
612 , p11_a2 VARCHAR2 := fnd_api.g_miss_char
613 );
614 procedure find_channels(p_api_version NUMBER
615 , p_init_msg_list VARCHAR2
616 , p_validation_level NUMBER
617 , x_return_status out nocopy VARCHAR2
618 , x_msg_count out nocopy NUMBER
619 , x_msg_data out nocopy VARCHAR2
620 , p_check_login_user VARCHAR2
621 , p_sort_by VARCHAR2
622 , p10_a0 out nocopy NUMBER
623 , p10_a1 out nocopy NUMBER
624 , p10_a2 out nocopy NUMBER
625 , p11_a0 out nocopy JTF_NUMBER_TABLE
626 , p11_a1 out nocopy JTF_NUMBER_TABLE
627 , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
633 , p11_a8 out nocopy JTF_NUMBER_TABLE
628 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
629 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
630 , p11_a5 out nocopy JTF_NUMBER_TABLE
631 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
632 , p11_a7 out nocopy JTF_NUMBER_TABLE
634 , p11_a9 out nocopy JTF_DATE_TABLE
635 , p11_a10 out nocopy JTF_DATE_TABLE
636 , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
637 , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
638 , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
639 , p11_a14 out nocopy JTF_VARCHAR2_TABLE_100
640 , p11_a15 out nocopy JTF_VARCHAR2_TABLE_100
641 , p11_a16 out nocopy JTF_VARCHAR2_TABLE_100
642 , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
643 , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
644 , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
645 , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
646 , p11_a21 out nocopy JTF_NUMBER_TABLE
647 , p11_a22 out nocopy JTF_VARCHAR2_TABLE_100
648 , p11_a23 out nocopy JTF_NUMBER_TABLE
649 , p11_a24 out nocopy JTF_DATE_TABLE
650 , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
651 , p11_a26 out nocopy JTF_DATE_TABLE
652 , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100
653 , p11_a28 out nocopy JTF_VARCHAR2_TABLE_200
654 , p11_a29 out nocopy JTF_VARCHAR2_TABLE_200
655 , p11_a30 out nocopy JTF_VARCHAR2_TABLE_200
656 , p11_a31 out nocopy JTF_VARCHAR2_TABLE_200
657 , p11_a32 out nocopy JTF_VARCHAR2_TABLE_200
658 , p11_a33 out nocopy JTF_VARCHAR2_TABLE_200
659 , p11_a34 out nocopy JTF_VARCHAR2_TABLE_200
660 , p11_a35 out nocopy JTF_VARCHAR2_TABLE_200
661 , p11_a36 out nocopy JTF_VARCHAR2_TABLE_200
662 , p11_a37 out nocopy JTF_VARCHAR2_TABLE_200
663 , p11_a38 out nocopy JTF_VARCHAR2_TABLE_200
664 , p11_a39 out nocopy JTF_VARCHAR2_TABLE_200
665 , p11_a40 out nocopy JTF_VARCHAR2_TABLE_200
666 , p11_a41 out nocopy JTF_VARCHAR2_TABLE_200
667 , p11_a42 out nocopy JTF_VARCHAR2_TABLE_200
668 , p7_a0 NUMBER := 0-1962.0724
669 , p7_a1 NUMBER := 0-1962.0724
670 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
671 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
672 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
673 , p7_a5 NUMBER := 0-1962.0724
674 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
675 , p7_a7 NUMBER := 0-1962.0724
676 , p7_a8 NUMBER := 0-1962.0724
677 , p7_a9 DATE := fnd_api.g_miss_date
678 , p7_a10 DATE := fnd_api.g_miss_date
679 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
680 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
681 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
682 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
683 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
684 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
685 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
686 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
687 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
688 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
689 , p7_a21 NUMBER := 0-1962.0724
690 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
691 , p7_a23 NUMBER := 0-1962.0724
692 , p7_a24 DATE := fnd_api.g_miss_date
693 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
694 , p7_a26 DATE := fnd_api.g_miss_date
695 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
696 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
697 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
698 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
699 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
700 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
701 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
702 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
703 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
704 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
705 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
706 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
707 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
708 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
709 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
710 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
711 , p9_a0 NUMBER := 0-1962.0724
712 , p9_a1 NUMBER := 0-1962.0724
713 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
714 );
715 end amv_channel_pvt_w;