1 PACKAGE amv_channel_pvt AS
2 /* $Header: amvvchas.pls 120.1 2005/06/22 17:31:37 appldev ship $ */
3 --
4 -- NAME
5 -- AMV_CHANNEL_PVT
6 -- PURPOSE
7 --
8 -- HISTORY
9 -- 08/04/1999 SLKRISHN CREATED
10 --
11 --
12 -- This package contains the following procedures
13
14 TYPE AMV_CHAR_VARRAY_TYPE IS TABLE OF VARCHAR2(4000);
15
16 TYPE AMV_NUMBER_VARRAY_TYPE IS TABLE OF NUMBER;
17
18 TYPE amv_return_obj_type IS RECORD(
19 returned_record_count NUMBER,
20 next_record_position NUMBER,
21 total_record_count NUMBER
22 );
23
24 TYPE amv_request_obj_type IS RECORD(
25 records_requested NUMBER,
26 start_record_position NUMBER,
27 return_total_count_flag VARCHAR2(1)
28 );
29
30 TYPE AMV_CHANNEL_OBJ_TYPE IS RECORD(
31 channel_id NUMBER,
32 object_version_number NUMBER,
33 channel_name VARCHAR2(80),
34 description VARCHAR2(2000),
35 channel_type VARCHAR2(30),
36 channel_category_id NUMBER,
37 status VARCHAR2(30),
38 owner_user_id NUMBER,
39 default_approver_user_id NUMBER,
40 effective_start_date DATE,
41 expiration_date DATE,
42 access_level_type VARCHAR2(30),
43 pub_need_approval_flag VARCHAR2(1),
44 sub_need_approval_flag VARCHAR2(1),
45 match_on_all_criteria_flag VARCHAR2(1),
46 match_on_keyword_flag VARCHAR2(1),
47 match_on_author_flag VARCHAR2(1),
48 match_on_perspective_flag VARCHAR2(1),
49 match_on_item_type_flag VARCHAR2(1),
50 match_on_content_type_flag VARCHAR2(1),
51 match_on_time_flag VARCHAR2(1),
52 application_id NUMBER,
53 external_access_flag VARCHAR2(1),
54 item_match_count NUMBER,
55 last_match_time DATE,
56 notification_interval_type VARCHAR2(30),
57 last_notification_time DATE,
58 attribute_category VARCHAR2(30),
59 attribute1 VARCHAR2(150),
60 attribute2 VARCHAR2(150),
61 attribute3 VARCHAR2(150),
62 attribute4 VARCHAR2(150),
63 attribute5 VARCHAR2(150),
64 attribute6 VARCHAR2(150),
65 attribute7 VARCHAR2(150),
66 attribute8 VARCHAR2(150),
67 attribute9 VARCHAR2(150),
68 attribute10 VARCHAR2(150),
69 attribute11 VARCHAR2(150),
70 attribute12 VARCHAR2(150),
71 attribute13 VARCHAR2(150),
72 attribute14 VARCHAR2(150),
73 attribute15 VARCHAR2(150)
74 );
75
76 TYPE AMV_CHANNEL_VARRAY_TYPE IS TABLE OF AMV_CHANNEL_OBJ_TYPE;
77
78 --
79 --------------------------------------------------------------------------------
80 --------------------------------------------------------------------------------
81 --
82 -- Start of comments
83 -- API name : Add_Channel
84 -- Type : Private
85 -- Pre-reqs : None
86 -- Function : Create a new channel
87 -- Parameters :
88 -- IN p_api_version IN NUMBER Required
89 -- p_init_msg_list IN VARCHAR2 Optional
90 -- Default = FND_API.G_FALSE
91 -- p_commit IN VARCHAR2 Optional
92 -- Default = FND_API.G_FALSE
93 -- p_validation_level IN NUMBER Optional
94 -- Default = FND_API.G_VALID_LEVEL_FULL
95 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
96 -- OUT : x_return_status OUT VARCHAR2
97 -- x_msg_count OUT NUMBER
98 -- x_msg_data OUT VARCHAR2
99 -- x_channel_id OUT NUMBER
100 -- Version : Current version 1.0
101 -- Previous version 1.0
102 -- Initial version 1.0
103 -- Notes :
104 --
105 -- End of comments
106 --
107 PROCEDURE Add_Channel
108 ( p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE,
111 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
116 p_channel_record IN AMV_CHANNEL_OBJ_TYPE,
117 x_channel_id OUT NOCOPY NUMBER
118 );
119 --------------------------------------------------------------------------------
120 -- Start of comments
121 -- API name : Add_PublicChannel
122 -- Type : Private
123 -- Pre-reqs : None
124 -- Function : Create a new content public channel
125 -- Parameters :
126 -- IN p_api_version IN NUMBER Required
127 -- p_init_msg_list IN VARCHAR2 Optional
128 -- Default = FND_API.G_FALSE
129 -- p_commit IN VARCHAR2 Optional
130 -- Default = FND_API.G_FALSE
131 -- p_validation_level IN NUMBER Optional
132 -- Default = FND_API.G_VALID_LEVEL_FULL
133 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
134 -- OUT : x_return_status OUT VARCHAR2
135 -- x_msg_count OUT NUMBER
136 -- x_msg_data OUT VARCHAR2
137 -- x_channel_id OUT NUMBER
138 -- Version : Current version 1.0
139 -- Previous version 1.0
140 -- Initial version 1.0
141 -- Notes :
142 --
143 -- End of comments
144 --
145 PROCEDURE Add_PublicChannel
146 ( p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148 p_commit IN VARCHAR2 := FND_API.G_FALSE,
149 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
154 p_channel_record IN AMV_CHANNEL_OBJ_TYPE,
155 x_channel_id OUT NOCOPY NUMBER
156 );
157 --------------------------------------------------------------------------------
158 -- Start of comments
159 -- API name : Add_ProtectedChannel
160 -- Type : Private
161 -- Pre-reqs : None
162 -- Function : Create a new content protected channel
163 -- Parameters :
164 -- IN p_api_version IN NUMBER Required
165 -- p_init_msg_list IN VARCHAR2 Optional
166 -- Default = FND_API.G_FALSE
167 -- p_commit IN VARCHAR2 Optional
168 -- Default = FND_API.G_FALSE
169 -- p_validation_level IN NUMBER Optional
170 -- Default = FND_API.G_VALID_LEVEL_FULL
171 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
172 -- OUT : x_return_status OUT VARCHAR2
173 -- x_msg_count OUT NUMBER
174 -- x_msg_data OUT VARCHAR2
175 -- x_channel_id OUT NUMBER
176 -- Version : Current version 1.0
177 -- Previous version 1.0
178 -- Initial version 1.0
179 -- Notes :
180 --
181 -- End of comments
182 --
183 PROCEDURE Add_ProtectedChannel
184 ( p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186 p_commit IN VARCHAR2 := FND_API.G_FALSE,
187 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
192 p_channel_record IN AMV_CHANNEL_OBJ_TYPE,
193 x_channel_id OUT NOCOPY NUMBER
194 );
195 --------------------------------------------------------------------------------
196 -- Start of comments
197 -- API name : Add_PrivateChannel
198 -- Type : Private
199 -- Pre-reqs : None
200 -- Function : Create a new content private channel
201 -- Parameters :
202 -- IN p_api_version IN NUMBER Required
203 -- p_init_msg_list IN VARCHAR2 Optional
204 -- Default = FND_API.G_FALSE
205 -- p_commit IN VARCHAR2 Optional
206 -- Default = FND_API.G_FALSE
207 -- p_validation_level IN NUMBER Optional
208 -- Default = FND_API.G_VALID_LEVEL_FULL
209 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
210 -- OUT : x_return_status OUT VARCHAR2
211 -- x_msg_count OUT NUMBER
212 -- x_msg_data OUT VARCHAR2
213 -- x_channel_id OUT NUMBER
214 -- Version : Current version 1.0
215 -- Previous version 1.0
216 -- Initial version 1.0
217 -- Notes :
218 --
219 -- End of comments
220 --
221 PROCEDURE Add_PrivateChannel
222 ( p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
224 p_commit IN VARCHAR2 := FND_API.G_FALSE,
225 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
230 p_channel_record IN AMV_CHANNEL_OBJ_TYPE,
231 x_channel_id OUT NOCOPY NUMBER
232 );
233 --------------------------------------------------------------------------------
234 -- Start of comments
235 -- API name : Add_GroupChannel
236 -- Type : Private
237 -- Pre-reqs : None
238 -- Function : Create a new content protected channel
239 -- Parameters :
240 -- IN p_api_version IN NUMBER Required
241 -- p_init_msg_list IN VARCHAR2 Optional
242 -- Default = FND_API.G_FALSE
243 -- p_commit IN VARCHAR2 Optional
244 -- Default = FND_API.G_FALSE
245 -- p_validation_level IN NUMBER Optional
246 -- Default = FND_API.G_VALID_LEVEL_FULL
247 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
248 -- OUT : x_return_status OUT VARCHAR2
249 -- x_msg_count OUT NUMBER
250 -- x_msg_data OUT VARCHAR2
251 -- x_channel_id OUT NUMBER
252 -- Version : Current version 1.0
253 -- Previous version 1.0
254 -- Initial version 1.0
255 -- Notes :
256 --
257 -- End of comments
258 --
259 PROCEDURE Add_GroupChannel
260 ( p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262 p_commit IN VARCHAR2 := FND_API.G_FALSE,
263 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
268 p_group_id IN NUMBER,
269 p_channel_record IN AMV_CHANNEL_OBJ_TYPE,
270 x_channel_id OUT NOCOPY NUMBER
271 );
272 --------------------------------------------------------------------------------
273 -- Start of comments
274 -- API name : Delete_Channel
275 -- Type : Private
276 -- Pre-reqs : None
277 -- Function : Delete the content channel given p_channel_id/p_channel_name
278 -- Parameters :
279 -- IN p_api_version IN NUMBER Required
280 -- p_init_msg_list IN VARCHAR2 Optional
281 -- Default = FND_API.G_FALSE
282 -- p_commit IN VARCHAR2 Optional
283 -- Default = FND_API.G_FALSE
284 -- p_validation_level IN NUMBER Optional
285 -- Default = FND_API.G_VALID_LEVEL_FULL
286 -- p_channel_id IN NUMBER Optional
287 -- the channel id. Default = FND_API.G_MISS_NUM
288 -- p_channel_name IN VARCHAR2 Optional
289 -- the channel name. Default = FND_API.G_MISS_CHAR
290 -- Either pass the channe id (preferred) or channel name
291 -- to identify the channel.
292 -- p_category_id IN NUMBER Optional
293 -- the category id. Default = FND_API.G_MISS_NUM
294 -- OUT : x_return_status OUT VARCHAR2
295 -- x_msg_count OUT NUMBER
296 -- x_msg_data OUT VARCHAR2
297 -- Version : Current version 1.0
298 -- Previous version 1.0
299 -- Initial version 1.0
300 -- Notes :
301 --
302 -- End of comments
303 --
304 PROCEDURE Delete_Channel
305 ( p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307 p_commit IN VARCHAR2 := FND_API.G_FALSE,
308 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2,
312 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
313 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
314 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315 p_category_id IN NUMBER := FND_API.G_MISS_NUM
316 );
317 --------------------------------------------------------------------------------
318 -- Start of comments
319 -- API name : Update_Channel
320 -- Type : Private
321 -- Pre-reqs : None
322 -- Function : Change the channel given by
323 -- (channel) id or name in p_channel_record
324 -- New data are specified in other members of p_channel_record
325 -- Parameters :
326 -- IN p_api_version IN NUMBER Required
327 -- p_init_msg_list IN VARCHAR2 Optional
328 -- Default = FND_API.G_FALSE
329 -- p_commit IN VARCHAR2 Optional
330 -- Default = FND_API.G_FALSE
331 -- p_validation_level IN NUMBER Optional
332 -- Default = FND_API.G_VALID_LEVEL_FULL
333 -- p_channel_record IN AMV_CHANNEL_OBJ_TYPE Required
334 -- OUT : x_return_status OUT VARCHAR2
335 -- x_msg_count OUT NUMBER
336 -- x_msg_data OUT VARCHAR2
337 -- Version : Current version 1.0
338 -- Previous version 1.0
339 -- Initial version 1.0
340 -- Notes :
341 --
342 -- End of comments
343 --
344 PROCEDURE Update_Channel
345 ( p_api_version IN NUMBER,
346 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
347 p_commit IN VARCHAR2 := FND_API.G_FALSE,
348 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349 x_return_status OUT NOCOPY VARCHAR2,
350 x_msg_count OUT NOCOPY NUMBER,
351 x_msg_data OUT NOCOPY VARCHAR2,
352 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
353 p_channel_record IN AMV_CHANNEL_OBJ_TYPE
354 );
355 --------------------------------------------------------------------------------
356 -- Start of comments
357 -- API name : Get_Channel
358 -- Type : Private
359 -- Pre-reqs : None
360 -- Function : Get the channel attributes of channel given by
364 -- p_init_msg_list IN VARCHAR2 Optional
361 -- channel id (preferred) or channel name.
362 -- Parameters :
363 -- IN p_api_version IN NUMBER Required
365 -- Default = FND_API.G_FALSE
366 -- p_validation_level IN NUMBER Optional
367 -- Default = FND_API.G_VALID_LEVEL_FULL
368 -- p_channel_id IN NUMBER Optional
369 -- the channel id. Default = FND_API.G_MISS_NUM
370 -- p_channel_name IN VARCHAR2 Optional
371 -- the channel name. Default = FND_API.G_MISS_CHAR
372 -- Either pass the channe id (preferred) or channel name
373 -- to identify the channel.
374 -- p_category_id IN NUMBER Optional
375 -- the category id. Default = FND_API.G_MISS_NUM
376 -- OUT : x_return_status OUT VARCHAR2
377 -- x_msg_count OUT NUMBER
378 -- x_msg_data OUT VARCHAR2
379 -- x_channel_record OUT AMV_CHANNEL_OBJ_TYPE
380 -- Version : Current version 1.0
381 -- Previous version 1.0
382 -- Initial version 1.0
383 -- Notes :
384 --
385 -- End of comments
386 --
387 PROCEDURE Get_Channel
388 ( p_api_version IN NUMBER,
389 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
390 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391 x_return_status OUT NOCOPY VARCHAR2,
392 x_msg_count OUT NOCOPY NUMBER,
393 x_msg_data OUT NOCOPY VARCHAR2,
394 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
395 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
396 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
397 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
398 x_channel_record OUT NOCOPY AMV_CHANNEL_OBJ_TYPE
399 );
400 --------------------------------------------------------------------------------
401 -- Start of comments
402 -- API name : Set_ChannelContentTypes
403 -- Type : Private
404 -- Pre-reqs : None
405 -- Function : Change content categories of the content channel.
406 -- Parameters :
407 -- IN p_api_version IN NUMBER Required
408 -- p_init_msg_list IN VARCHAR2 Optional
409 -- Default = FND_API.G_FALSE
410 -- p_commit IN VARCHAR2 Optional
411 -- Default = FND_API.G_FALSE
412 -- p_validation_level NUMBER Optional
413 -- Default = FND_API.G_VALID_LEVEL_FULL
414 -- p_channel_id IN NUMBER Optional
415 -- the channel id. Default = FND_API.G_MISS_NUM
416 -- p_channel_name IN VARCHAR2 Optional
417 -- the channel name. Default = FND_API.G_MISS_CHAR
418 -- Either pass the channe id (preferred) or channel name
419 -- to identify the channel.
420 -- p_category_id IN NUMBER Optional
421 -- the category id. Default = FND_API.G_MISS_NUM
422 -- p_content_type_id_array IN AMV_NUMBER_VARRAY_TYPE
423 -- OUT : x_return_status OUT VARCHAR2
424 -- x_msg_count OUT NUMBER
425 -- x_msg_data OUT VARCHAR2
426 -- Version : Current version 1.0
427 -- Previous version 1.0
428 -- Initial version 1.0
429 -- Notes :
430 --
431 -- End of comments
432 --
433 PROCEDURE Set_ChannelContentTypes
434 ( p_api_version IN NUMBER,
435 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
436 p_commit IN VARCHAR2 := FND_API.G_FALSE,
437 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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 IN VARCHAR2 := FND_API.G_TRUE,
442 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
443 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
444 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
445 p_content_type_id_array IN AMV_NUMBER_VARRAY_TYPE
446 );
447 --------------------------------------------------------------------------------
448 -- Start of comments
449 -- API name : Get_ChannelContentTypes
450 -- Type : Private
451 -- Pre-reqs : None
452 -- Function : Get content categories of the content channel.
453 -- Parameters :
454 -- IN p_api_version IN NUMBER Required
455 -- p_init_msg_list IN VARCHAR2 Optional
456 -- Default = FND_API.G_FALSE
457 -- p_validation_level NUMBER Optional
458 -- Default = FND_API.G_VALID_LEVEL_FULL
459 -- p_channel_id IN NUMBER Optional
463 -- Either pass the channe id (preferred) or channel name
460 -- the channel id. Default = FND_API.G_MISS_NUM
461 -- p_channel_name IN VARCHAR2 Optional
462 -- the channel name. Default = FND_API.G_MISS_CHAR
464 -- to identify the channel.
465 -- p_category_id IN NUMBER Optional
466 -- the category id. Default = FND_API.G_MISS_NUM
467 -- OUT : x_return_status OUT VARCHAR2
468 -- x_msg_count OUT NUMBER
469 -- x_msg_data OUT VARCHAR2
470 -- x_content_type_id_array OUT AMV_NUMBER_VARRAY_TYPE
471 -- Version : Current version 1.0
472 -- Previous version 1.0
473 -- Initial version 1.0
474 -- Notes :
475 --
476 -- End of comments
477 --
478 PROCEDURE Get_ChannelContentTypes
479 ( p_api_version IN NUMBER,
480 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
481 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482 x_return_status OUT NOCOPY VARCHAR2,
483 x_msg_count OUT NOCOPY NUMBER,
484 x_msg_data OUT NOCOPY VARCHAR2,
485 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
486 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
487 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
488 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
489 x_content_type_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
490 );
491 --------------------------------------------------------------------------------
492 -- Start of comments
493 -- API name : Set_ChannelPerspectives
494 -- Type : Private
495 -- Pre-reqs : None
496 -- Function : Change perspectives of the content channel.
497 -- Parameters :
498 -- IN p_api_version IN NUMBER Required
499 -- p_init_msg_list IN VARCHAR2 Optional
500 -- Default = FND_API.G_FALSE
501 -- p_commit IN VARCHAR2 Optional
502 -- Default = FND_API.G_FALSE
503 -- p_validation_level NUMBER Optional
504 -- Default = FND_API.G_VALID_LEVEL_FULL
505 -- p_channel_id IN NUMBER Optional
506 -- the channel id. Default = FND_API.G_MISS_NUM
507 -- p_channel_name IN VARCHAR2 Optional
508 -- the channel name. Default = FND_API.G_MISS_CHAR
509 -- Either pass the channe id (preferred) or channel name
510 -- to identify the channel.
511 -- p_category_id IN NUMBER Optional
512 -- the category id. Default = FND_API.G_MISS_NUM
513 -- p_perspective_id_array IN AMV_NUMBER_VARRAY_TYPE
514 -- OUT : x_return_status OUT VARCHAR2
515 -- x_msg_count OUT NUMBER
516 -- x_msg_data OUT VARCHAR2
517 -- Version : Current version 1.0
518 -- Previous version 1.0
519 -- Initial version 1.0
520 -- Notes :
521 --
522 -- End of comments
523 --
524 PROCEDURE Set_ChannelPerspectives
525 ( p_api_version IN NUMBER,
526 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527 p_commit IN VARCHAR2 := FND_API.G_FALSE,
528 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529 x_return_status OUT NOCOPY VARCHAR2,
530 x_msg_count OUT NOCOPY NUMBER,
531 x_msg_data OUT NOCOPY VARCHAR2,
532 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
533 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
534 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
535 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
536 p_perspective_id_array IN AMV_NUMBER_VARRAY_TYPE
537 );
538 --------------------------------------------------------------------------------
539 -- Start of comments
540 -- API name : Get_ChannelPerspectives
541 -- Type : Private
542 -- Pre-reqs : None
543 -- Function : Get perspectives of the content channel.
544 -- Parameters :
545 -- IN p_api_version IN NUMBER Required
546 -- p_init_msg_list IN VARCHAR2 Optional
547 -- Default = FND_API.G_FALSE
548 -- p_validation_level NUMBER Optional
549 -- Default = FND_API.G_VALID_LEVEL_FULL
550 -- p_channel_id IN NUMBER Optional
551 -- the channel id. Default = FND_API.G_MISS_NUM
552 -- p_channel_name IN VARCHAR2 Optional
553 -- the channel name. Default = FND_API.G_MISS_CHAR
554 -- Either pass the channe id (preferred) or channel name
555 -- to identify the channel.
556 -- p_category_id IN NUMBER Optional
557 -- the category id. Default = FND_API.G_MISS_NUM
561 -- x_perspective_id_array OUT AMV_NUMBER_VARRAY_TYPE
558 -- OUT : x_return_status OUT VARCHAR2
559 -- x_msg_count OUT NUMBER
560 -- x_msg_data OUT VARCHAR2
562 -- Version : Current version 1.0
563 -- Previous version 1.0
564 -- Initial version 1.0
565 -- Notes :
566 --
567 -- End of comments
568 --
569 PROCEDURE Get_ChannelPerspectives
570 ( p_api_version IN NUMBER,
571 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
572 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573 x_return_status OUT NOCOPY VARCHAR2,
574 x_msg_count OUT NOCOPY NUMBER,
575 x_msg_data OUT NOCOPY VARCHAR2,
576 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
577 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
578 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
579 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
580 x_perspective_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
581 );
582 --------------------------------------------------------------------------------
583 -- Start of comments
584 -- API name : Set_ChannelItemTypes
585 -- Type : Private
586 -- Pre-reqs : None
587 -- Function : Change user groups of the content channel.
588 -- Parameters :
589 -- IN p_api_version IN NUMBER Required
590 -- p_init_msg_list IN VARCHAR2 Optional
591 -- Default = FND_API.G_FALSE
592 -- p_validation_level NUMBER Optional
593 -- Default = FND_API.G_VALID_LEVEL_FULL
594 -- p_commit IN VARCHAR2 Optional
595 -- Default = FND_API.G_FALSE
596 -- p_channel_id IN NUMBER Optional
597 -- the channel id. Default = FND_API.G_MISS_NUM
598 -- p_channel_name IN VARCHAR2 Optional
599 -- the channel name. Default = FND_API.G_MISS_CHAR
600 -- Either pass the channe id (preferred) or channel name
601 -- to identify the channel.
602 -- p_category_id IN NUMBER Optional
603 -- the category id. Default = FND_API.G_MISS_NUM
604 -- p_item_type_array IN AMV_CHAR_VARRAY_TYPE
605 -- OUT : x_return_status OUT VARCHAR2
606 -- x_msg_count OUT NUMBER
607 -- x_msg_data OUT VARCHAR2
608 -- Version : Current version 1.0
609 -- Previous version 1.0
610 -- Initial version 1.0
611 -- Notes :
612 --
613 -- End of comments
614 --
615 PROCEDURE Set_ChannelItemTypes
616 ( p_api_version IN NUMBER,
617 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618 p_commit IN VARCHAR2 := FND_API.G_FALSE,
619 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620 x_return_status OUT NOCOPY VARCHAR2,
621 x_msg_count OUT NOCOPY NUMBER,
622 x_msg_data OUT NOCOPY VARCHAR2,
623 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
624 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
625 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
626 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
627 p_item_type_array IN AMV_CHAR_VARRAY_TYPE
628 );
629 --------------------------------------------------------------------------------
630 -- Start of comments
631 -- API name : Get_ChannelItemTypes
632 -- Type : Private
633 -- Pre-reqs : None
634 -- Function : Get user groups of the content channel.
635 -- Parameters :
636 -- IN p_api_version IN NUMBER Required
637 -- p_init_msg_list IN VARCHAR2 Optional
638 -- Default = FND_API.G_FALSE
639 -- p_validation_level NUMBER Optional
640 -- Default = FND_API.G_VALID_LEVEL_FULL
641 -- p_channel_id IN NUMBER Optional
642 -- the channel id. Default = FND_API.G_MISS_NUM
643 -- p_channel_name IN VARCHAR2 Optional
644 -- the channel name. Default = FND_API.G_MISS_CHAR
645 -- Either pass the channe id (preferred) or channel name
646 -- to identify the channel.
647 -- p_category_id IN NUMBER Optional
648 -- the category id. Default = FND_API.G_MISS_NUM
649 -- OUT : x_return_status OUT VARCHAR2
650 -- x_msg_count OUT NUMBER
651 -- x_msg_data OUT VARCHAR2
652 -- x_item_type_array OUT AMV_CHAR_VARRAY_TYPE
653 -- Version : Current version 1.0
654 -- Previous version 1.0
655 -- Initial version 1.0
656 -- Notes :
657 --
658 -- End of comments
659 --
660 PROCEDURE Get_ChannelItemTypes
664 x_return_status OUT NOCOPY VARCHAR2,
661 ( p_api_version IN NUMBER,
662 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
663 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
665 x_msg_count OUT NOCOPY NUMBER,
666 x_msg_data OUT NOCOPY VARCHAR2,
667 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
668 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
669 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
670 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
671 x_item_type_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
672 );
673 --------------------------------------------------------------------------------
674 -- Start of comments
675 -- API name : Set_ChannelKeywords
676 -- Type : Private
677 -- Pre-reqs : None
678 -- Function : Change keywords of the content channel.
679 -- Parameters :
680 -- IN p_api_version IN NUMBER Required
681 -- p_init_msg_list IN VARCHAR2 Optional
682 -- Default = FND_API.G_FALSE
683 -- p_commit IN VARCHAR2 Optional
684 -- Default = FND_API.G_FALSE
685 -- p_validation_level NUMBER Optional
686 -- Default = FND_API.G_VALID_LEVEL_FULL
687 -- p_channel_id IN NUMBER Optional
688 -- the channel id. Default = FND_API.G_MISS_NUM
689 -- p_channel_name IN VARCHAR2 Optional
690 -- the channel name. Default = FND_API.G_MISS_CHAR
691 -- Either pass the channe id (preferred) or channel name
692 -- to identify the channel.
693 -- p_category_id IN NUMBER Optional
694 -- the category id. Default = FND_API.G_MISS_NUM
695 -- p_keywords_array IN AMV_CHAR_VARRAY_TYPE
696 -- OUT : x_return_status OUT VARCHAR2
697 -- x_msg_count OUT NUMBER
698 -- x_msg_data OUT VARCHAR2
699 -- Version : Current version 1.0
700 -- Previous version 1.0
701 -- Initial version 1.0
702 -- Notes :
703 --
704 -- End of comments
705 --
706 PROCEDURE Set_ChannelKeywords
707 ( p_api_version IN NUMBER,
708 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
709 p_commit IN VARCHAR2 := FND_API.G_FALSE,
710 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711 x_return_status OUT NOCOPY VARCHAR2,
712 x_msg_count OUT NOCOPY NUMBER,
713 x_msg_data OUT NOCOPY VARCHAR2,
714 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
715 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
716 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
717 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
718 p_keywords_array IN AMV_CHAR_VARRAY_TYPE
719 );
720 --------------------------------------------------------------------------------
721 -- Start of comments
722 -- API name : Get_ChannelKeywords
723 -- Type : Private
724 -- Pre-reqs : None
725 -- Function : Get keywords of the content channel.
726 -- Parameters :
727 -- IN p_api_version IN NUMBER Required
728 -- p_init_msg_list IN VARCHAR2 Optional
729 -- Default = FND_API.G_FALSE
730 -- p_validation_level NUMBER Optional
731 -- Default = FND_API.G_VALID_LEVEL_FULL
732 -- p_channel_id IN NUMBER Optional
733 -- the channel id. Default = FND_API.G_MISS_NUM
734 -- p_channel_name IN VARCHAR2 Optional
735 -- the channel name. Default = FND_API.G_MISS_CHAR
736 -- Either pass the channe id (preferred) or channel name
737 -- to identify the channel.
738 -- p_category_id IN NUMBER Optional
739 -- the category id. Default = FND_API.G_MISS_NUM
740 -- OUT : x_return_status OUT VARCHAR2
741 -- x_msg_count OUT NUMBER
742 -- x_msg_data OUT VARCHAR2
743 -- x_keywords_array OUT AMV_CHAR_VARRAY_TYPE
744 -- Version : Current version 1.0
745 -- Previous version 1.0
746 -- Initial version 1.0
747 -- Notes :
748 --
749 -- End of comments
750 --
751 PROCEDURE Get_ChannelKeywords
752 ( p_api_version IN NUMBER,
753 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
754 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
755 x_return_status OUT NOCOPY VARCHAR2,
756 x_msg_count OUT NOCOPY NUMBER,
757 x_msg_data OUT NOCOPY VARCHAR2,
758 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
759 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
760 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
764 --------------------------------------------------------------------------------
761 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
762 x_keywords_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
763 );
765 -- Start of comments
766 -- API name : Set_ChannelAuthors
767 -- Type : Private
768 -- Pre-reqs : None
769 -- Function : Change authors of the content channel.
770 -- Parameters :
771 -- IN p_api_version IN NUMBER Required
772 -- p_init_msg_list IN VARCHAR2 Optional
773 -- Default = FND_API.G_FALSE
774 -- p_commit IN VARCHAR2 Optional
775 -- Default = FND_API.G_FALSE
776 -- p_validation_level NUMBER Optional
777 -- Default = FND_API.G_VALID_LEVEL_FULL
778 -- p_channel_id IN NUMBER Optional
779 -- the channel id. Default = FND_API.G_MISS_NUM
780 -- p_channel_name IN VARCHAR2 Optional
781 -- the channel name. Default = FND_API.G_MISS_CHAR
782 -- Either pass the channe id (preferred) or channel name
783 -- to identify the channel.
784 -- p_category_id IN NUMBER Optional
785 -- the category id. Default = FND_API.G_MISS_NUM
786 -- p_authors_array IN AMV_CHAR_VARRAY_TYPE
787 -- OUT : x_return_status OUT VARCHAR2
788 -- x_msg_count OUT NUMBER
789 -- x_msg_data OUT VARCHAR2
790 -- Version : Current version 1.0
791 -- Previous version 1.0
792 -- Initial version 1.0
793 -- Notes :
794 --
795 -- End of comments
796 --
797 PROCEDURE Set_ChannelAuthors
798 ( p_api_version IN NUMBER,
799 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
800 p_commit IN VARCHAR2 := FND_API.G_FALSE,
801 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
802 x_return_status OUT NOCOPY VARCHAR2,
803 x_msg_count OUT NOCOPY NUMBER,
804 x_msg_data OUT NOCOPY VARCHAR2,
805 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
806 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
807 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
808 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
809 p_authors_array IN AMV_CHAR_VARRAY_TYPE
810 );
811 --------------------------------------------------------------------------------
812 -- Start of comments
813 -- API name : Get_ChannelAuthors
814 -- Type : Private
815 -- Pre-reqs : None
816 -- Function : Get authors of the content channel.
817 -- Parameters :
818 -- IN p_api_version IN NUMBER Required
819 -- p_init_msg_list IN VARCHAR2 Optional
820 -- Default = FND_API.G_FALSE
821 -- p_validation_level NUMBER Optional
822 -- Default = FND_API.G_VALID_LEVEL_FULL
823 -- p_channel_id IN NUMBER Optional
824 -- the channel id. Default = FND_API.G_MISS_NUM
825 -- p_channel_name IN VARCHAR2 Optional
826 -- the channel name. Default = FND_API.G_MISS_CHAR
827 -- Either pass the channe id (preferred) or channel name
828 -- to identify the channel.
829 -- p_category_id IN NUMBER Optional
830 -- the category id. Default = FND_API.G_MISS_NUM
831 -- OUT : x_return_status OUT VARCHAR2
832 -- x_msg_count OUT NUMBER
833 -- x_msg_data OUT VARCHAR2
834 -- x_authors_array OUT AMV_CHAR_VARRAY_TYPE
835 -- Version : Current version 1.0
836 -- Previous version 1.0
837 -- Initial version 1.0
838 -- Notes :
839 --
840 -- End of comments
841 --
842 PROCEDURE Get_ChannelAuthors
843 ( p_api_version IN NUMBER,
844 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
845 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
846 x_return_status OUT NOCOPY VARCHAR2,
847 x_msg_count OUT NOCOPY NUMBER,
848 x_msg_data OUT NOCOPY VARCHAR2,
849 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
850 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
851 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
852 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
853 x_authors_array OUT NOCOPY AMV_CHAR_VARRAY_TYPE
854 );
855 --------------------------------------------------------------------------------
856 -- Start of comments
857 -- API name : Get_ItemsPerChannel
858 -- Type : Private
859 -- Pre-reqs : None
860 -- Function : Get all documents matching the content channel given by
861 -- channel id (preferred) or channel name.
862 -- Parameters :
863 -- IN p_api_version IN NUMBER Required
867 -- Default = FND_API.G_VALID_LEVEL_FULL
864 -- p_init_msg_list IN VARCHAR2 Optional
865 -- Default = FND_API.G_FALSE
866 -- p_validation_level NUMBER Optional
868 -- p_channel_id IN NUMBER Optional
869 -- the channel id. Default = FND_API.G_MISS_NUM
870 -- p_channel_name IN VARCHAR2 Optional
871 -- the channel name. Default = FND_API.G_MISS_CHAR
872 -- Either pass the channe id (preferred) or channel name
873 -- to identify the channel.
874 -- p_category_id IN NUMBER Optional
875 -- the category id. Default = FND_API.G_MISS_NUM
876 -- p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE
877 -- Required
878 -- OUT : x_return_status OUT VARCHAR2
879 -- x_msg_count OUT NUMBER
880 -- x_msg_data OUT VARCHAR2
881 -- x_subset_return_rec OUT AMV_RETURN_OBJ_TYPE
882 -- x_document_id_array OUT AMV_NUMBER_VARRAY_TYPE
883 -- Version : Current version 1.0
884 -- Previous version 1.0
885 -- Initial version 1.0
886 -- Notes :
887 --
888 -- End of comments
889 --
890 PROCEDURE Get_ItemsPerChannel
891 ( p_api_version IN NUMBER,
892 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
893 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
894 x_return_status OUT NOCOPY VARCHAR2,
895 x_msg_count OUT NOCOPY NUMBER,
896 x_msg_data OUT NOCOPY VARCHAR2,
897 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
898 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
899 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
900 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
901 p_item_status IN VARCHAR2 := AMV_UTILITY_PVT.G_APPROVED,
902 p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE,
903 x_subset_return_rec OUT NOCOPY AMV_RETURN_OBJ_TYPE,
904 x_document_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
905 );
906 --------------------------------------------------------------------------------
907 -- Start of comments
908 -- API name : Set_ChannelApprovalStatus
909 -- Type : Private
910 -- Pre-reqs : None
911 -- Function : Set the approval status (approve, reject, need more info.)
912 -- given a channel and a document.
913 -- Parameters :
914 -- IN p_api_version IN NUMBER Required
915 -- p_init_msg_list IN VARCHAR2 Optional
916 -- Default = FND_API.G_FALSE
917 -- p_commit IN VARCHAR2 Optional
918 -- Default = FND_API.G_FALSE
919 -- p_validation_level NUMBER Optional
920 -- Default = FND_API.G_VALID_LEVEL_FULL
921 -- p_channel_id IN NUMBER Optional
922 -- the channel id. Default = FND_API.G_MISS_NUM
923 -- p_channel_name IN VARCHAR2 Optional
924 -- the channel name. Default = FND_API.G_MISS_CHAR
925 -- Either pass the channe id (preferred) or channel name
926 -- to identify the channel.
927 -- p_category_id IN NUMBER Optional
928 -- the category id. Default = FND_API.G_MISS_NUM
929 -- p_item_id IN NUMBER Required
930 -- p_approval_status IN NUMBER Required
931 -- OUT : x_return_status OUT VARCHAR2
932 -- x_msg_count OUT NUMBER
933 -- x_msg_data OUT VARCHAR2
934 -- Version : Current version 1.0
935 -- Previous version 1.0
936 -- Initial version 1.0
937 -- Notes :
938 --
939 -- End of comments
940 --
941 PROCEDURE Set_ChannelApprovalStatus
942 ( p_api_version IN NUMBER,
943 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
944 p_commit IN VARCHAR2 := FND_API.G_FALSE,
945 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
946 x_return_status OUT NOCOPY VARCHAR2,
947 x_msg_count OUT NOCOPY NUMBER,
948 x_msg_data OUT NOCOPY VARCHAR2,
949 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
950 p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
951 p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
952 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
953 p_item_id IN NUMBER,
954 p_approval_status IN VARCHAR2
955 );
956 --------------------------------------------------------------------------------
957 -- Start of comments
958 -- API name : Find_Channels
959 -- Type : Private
960 -- Pre-reqs : None
961 -- Function : Get all documents matching the input criteria.
962 -- Parameters :
966 -- p_validation_level NUMBER Optional
963 -- IN p_api_version IN NUMBER Required
964 -- p_init_msg_list IN VARCHAR2 Optional
965 -- Default = FND_API.G_FALSE
967 -- Default = FND_API.G_VALID_LEVEL_FULL
968 -- p_criteria_rec IN
969 -- AMV_CHANNEL_OBJ_TYPE Required
970 -- p_sort_by IN VARCHAR2 Optional
971 -- Default = FND_API.G_MISS_CHAR
972 -- p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE
973 -- Required
974 -- OUT : x_return_status OUT VARCHAR2
975 -- x_msg_count OUT NUMBER
976 -- x_msg_data OUT VARCHAR2
977 -- x_subset_return_rec OUT AMV_RETURN_OBJ_TYPE
978 -- x_content_chan_array OUT AMV_CHANNEL_VARRAY_TYPE
979 -- Version : Current version 1.0
980 -- Previous version 1.0
981 -- Initial version 1.0
982 -- Notes :
983 --
984 -- End of comments
985 --
986 PROCEDURE Find_Channels
987 ( p_api_version IN NUMBER,
988 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
989 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
990 x_return_status OUT NOCOPY VARCHAR2,
991 x_msg_count OUT NOCOPY NUMBER,
992 x_msg_data OUT NOCOPY VARCHAR2,
993 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
994 p_criteria_rec IN AMV_CHANNEL_OBJ_TYPE,
995 p_sort_by IN VARCHAR2 := FND_API.G_MISS_CHAR,
996 p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE,
997 x_subset_return_rec OUT NOCOPY AMV_RETURN_OBJ_TYPE,
998 x_content_chan_array OUT NOCOPY AMV_CHANNEL_VARRAY_TYPE
999 );
1000 --------------------------------------------------------------------------------
1001 END amv_channel_pvt;