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