1 PACKAGE amv_category_grp AS
2 /* $Header: amvgcats.pls 120.1 2005/06/22 16:06:59 appldev ship $ */
3 --
4 -- NAME
5 -- AMV_CATEGORY_GRP
6 -- PURPOSE
7 --
8 -- HISTORY
9 -- 12/07/1999 SLKRISHN CREATED
10 --
11 --
12 G_ASC_ORDER CONSTANT VARCHAR2(5) := 'ASC';
13 G_DESC_ORDER CONSTANT VARCHAR2(5) := 'DESC';
14 --
15 --
16 -- This package contains the following procedures
17 --
18 --------------------------------------------------------------------------------
19 --------------------------------------------------------------------------------
20 -- Start of comments
21 -- API name : Add_Category
22 -- Type : Private
23 -- Pre-reqs : None
24 -- Function : Create (sub)category.
25 -- Parameters :
26 -- IN p_api_version IN NUMBER Required
27 -- p_init_msg_list IN VARCHAR2 Optional
28 -- Default = FND_API.G_FALSE
29 -- p_commit IN VARCHAR2 Optional
30 -- Default = FND_API.G_FALSE
31 -- p_validation_level IN NUMBER Optional
32 -- Default = FND_API.G_VALID_LEVEL_FULL
33 -- p_application_id IN NUMBER Required
34 -- application creating the category
35 -- p_category_name IN VARCHAR2 Required
36 -- the channel category name. Have to be unique.
37 -- p_description IN VARCHAR2 Optional
38 -- the channel (sub)category description.
39 -- p_parent_category_id IN VARCHAR2 Required
40 -- p_order IN NUMBER Optional
41 -- Default = FND_API.G_MISS_NUM
42 -- the order of this catgory among all the categories
43 -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
44 -- x_msg_count OUT NOCOPY NUMBER
45 -- x_msg_data OUT NOCOPY VARCHAR2
46 -- x_category_id OUT NOCOPY NUMBER
47 -- Version : Current version 1.0
48 -- Previous version 1.0
49 -- Initial version 1.0
50 -- Notes :
51 --
52 -- End of comments
53 --
54 PROCEDURE Add_Category
55 ( p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57 p_commit IN VARCHAR2 := FND_API.G_FALSE,
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
63 p_application_id IN NUMBER,
64 p_category_name IN VARCHAR2,
65 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
66 p_parent_category_id IN NUMBER,
67 p_order IN NUMBER := FND_API.G_MISS_NUM,
68 x_category_id OUT NOCOPY NUMBER
69 );
70 --
71 -- Algorithm:
72 -- BEGIN
73 -- ...
74 -- END
75 --
76 --------------------------------------------------------------------------------
77 -- Start of comments
78 -- API name : Delete_Category
79 -- Type : Private
80 -- Pre-reqs : None
81 -- Function : Delete (sub)category given the p_category_id or
82 -- p_category_name along with p_parent_category_id.
83 -- Parameters :
84 -- IN p_api_version IN NUMBER Required
85 -- p_init_msg_list IN VARCHAR2 Optional
86 -- Default = FND_API.G_FALSE
87 -- p_commit IN VARCHAR2 Optional
88 -- Default = FND_API.G_FALSE
89 -- p_validation_level IN NUMBER Optional
90 -- Default = FND_API.G_VALID_LEVEL_FULL
91 -- p_category_id IN NUMBER Optional
92 -- Default = FND_API.G_MISS_NUM
93 -- channel (sub)category id.
94 -- p_category_name IN VARCHAR2 Optional
95 -- Default = FND_API.G_MISS_CHAR
96 -- channel (sub)category name.
97 -- p_parent_category_id IN NUMBER Optional
98 -- Default = FND_API.G_MISS_NUM
99 -- parent id for (sub) category
100 -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
101 -- x_msg_count OUT NOCOPY NUMBER
102 -- x_msg_data OUT NOCOPY VARCHAR2
103 -- Version : Current version 1.0
104 -- Previous version 1.0
105 -- Initial version 1.0
106 -- Notes :
107 --
108 -- End of comments
109 --
110 PROCEDURE Delete_Category
111 ( p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113 p_commit IN VARCHAR2 := FND_API.G_FALSE,
114 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
119 p_application_id IN NUMBER,
120 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
121 p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM
123 );
124 --
125 -- Algorithm:
126 -- BEGIN
127 -- ...
128 -- END
129 --
130 --------------------------------------------------------------------------------
131 -- Start of comments
132 -- API name : Sort_Category
133 -- Type : Private
134 -- Pre-reqs : None
135 -- Function : sort (sub)category list in ascending or descending order
136 -- Parameters :
137 -- IN p_api_version IN NUMBER Required
138 -- p_init_msg_list IN VARCHAR2 Optional
139 -- Default = FND_API.G_FALSE
140 -- p_commit IN VARCHAR2 Optional
141 -- Default = FND_API.G_FALSE
142 -- p_validation_level IN NUMBER Optional
143 -- Default = FND_API.G_VALID_LEVEL_FULL
144 -- p_sort_order IN VARCHAR2 Optional
145 -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER
146 -- Ascending(ASC) or Descending(DESC) Order.
147 -- p_parent_category_id IN NUMBER Optional
148 -- Default = FND_API.G_MISS_NUM
149 -- parent id for sub categories
150 -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
151 -- x_msg_count OUT NOCOPY NUMBER
152 -- x_msg_data OUT NOCOPY VARCHAR2
153 -- Version : Current version 1.0
154 -- Previous version 1.0
155 -- Initial version 1.0
156 -- Notes :
157 --
158 -- End of comments
159 --
160 PROCEDURE Sort_Category
161 ( p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163 p_commit IN VARCHAR2 := FND_API.G_FALSE,
164 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
169 p_application_id IN NUMBER,
170 p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
171 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM
172 );
173 --
174 -- Algorithm:
175 -- BEGIN
176 -- ...
177 -- END
178 --
179 --------------------------------------------------------------------------------
180 -- Start of comments
181 -- API name : Reorder_Category
182 -- Type : Private
183 -- Pre-reqs : None
184 -- Function : Reorder (sub)category list
185 -- Parameters :
186 -- IN p_api_version IN NUMBER Required
187 -- p_init_msg_list IN VARCHAR2 Optional
188 -- Default = FND_API.G_FALSE
189 -- p_commit IN VARCHAR2 Optional
190 -- Default = FND_API.G_FALSE
191 -- p_validation_level NUMBER Optional
192 -- Default = FND_API.G_VALID_LEVEL_FULL
193 -- p_category_id_array IN AMV_NUMBER_VARRAY_TYPE
194 -- Required
195 -- p_category_new_order IN AMV_NUMBER_VARRAY_TYPE
196 -- Required
197 -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
198 -- x_msg_count OUT NOCOPY NUMBER
199 -- x_msg_data OUT NOCOPY VARCHAR2
200 -- Version : Current version 1.0
201 -- Previous version 1.0
202 -- Initial version 1.0
203 -- Notes :
204 --
205 -- End of comments
206 --
207 PROCEDURE Reorder_Category
208 ( p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210 p_commit IN VARCHAR2 := FND_API.G_FALSE,
211 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
216 p_application_id IN NUMBER,
217 p_category_id_array IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE,
218 p_category_new_order IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE
219 );
220 --
221 -- Algorithm:
222 -- BEGIN
223 -- ...
224 -- END
225 --
226 --------------------------------------------------------------------------------
227 -- Start of comments
228 -- API name : Update_Category
229 -- Type : Private
230 -- Pre-reqs : None
231 -- Function : Update (sub)category given (sub)category id or name
232 -- Parameters :
233 -- IN p_api_version IN NUMBER Required
234 -- p_init_msg_list IN VARCHAR2 Optional
235 -- Default = FND_API.G_FALSE
236 -- p_commit IN VARCHAR2 Optional
237 -- Default = FND_API.G_FALSE
238 -- p_validation_level IN NUMBER Optional
239 -- Default = FND_API.G_VALID_LEVEL_FULL
240 -- p_object_version_number IN NUMBER Required
241 -- object version number
242 -- p_category_id IN NUMBER Required
243 -- channel category id.
244 -- p_category_name IN VARCHAR2 Optional
245 -- channel category name.
246 -- (sub)category id or name is required
247 -- p_parent_category_id IN NUMBER Optional
248 -- Default = FND_API.G_MISS_NUM
249 -- channel category id.
250 -- p_category_order IN NUMBER Optional
251 -- new channel category order
252 -- p_category_new_name IN VARCHAR2 Optional
253 -- new channel category name. New name has to be unique
254 -- p_description IN VARCHAR2 Optional
255 -- Default = FND_API.G_MISS_CHAR
256 -- channel category description.
257 -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
258 -- x_msg_count OUT NOCOPY NUMBER
259 -- x_msg_data OUT NOCOPY VARCHAR2
260 -- Version : Current version 1.0
261 -- Previous version 1.0
262 -- Initial version 1.0
263 -- Notes :
264 --
265 -- End of comments
266 --
267 PROCEDURE Update_Category
268 ( p_api_version IN NUMBER,
269 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270 p_commit IN VARCHAR2 := FND_API.G_FALSE,
271 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
276 p_object_version_number IN NUMBER,
277 p_application_id IN NUMBER,
278 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
279 p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
280 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
281 p_category_order IN NUMBER := FND_API.G_MISS_NUM,
282 p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
283 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
284 );
285 --
286 -- Algorithm:
287 -- BEGIN
288 -- ...
289 -- END
290 --
291 --------------------------------------------------------------------------------
292 -- Start of comments
293 -- API name : Find_Categories
294 -- Type : Private
295 -- Pre-reqs : None
296 -- Function : Search and return (sub)categories
297 -- Parameters :
298 -- IN p_api_version IN NUMBER Required
299 -- p_init_msg_list IN VARCHAR2 Optional
300 -- Default = FND_API.G_FALSE
301 -- p_validation_level NUMBER Optional
302 -- Default = FND_API.G_VALID_LEVEL_FULL
303 -- p_application_id IN NUMBER Required
304 -- application creating the channel
305 -- p_category_name IN VARCHAR2 Optional
306 -- Search criteria by name. Default = '%' (everything)
307 -- p_parent_category_id IN NUMBER Optional
308 -- Default = FND_API.G_MISS_NUM
309 -- parent id for sub categories
310 -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
311 -- x_msg_count OUT NOCOPY NUMBER
312 -- x_msg_data OUT NOCOPY VARCHAR2
313 -- x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_VARRAY_TYPE
314 -- Version : Current version 1.0
315 -- Previous version 1.0
316 -- Initial version 1.0
317 -- Notes :
318 --
319 -- End of comments
320 --
321 PROCEDURE Find_Categories
322 ( p_api_version IN NUMBER,
323 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
324 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325 x_return_status OUT NOCOPY VARCHAR2,
326 x_msg_count OUT NOCOPY NUMBER,
327 x_msg_data OUT NOCOPY VARCHAR2,
328 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
329 p_application_id IN NUMBER,
330 p_category_name IN VARCHAR2 := '%',
331 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
332 p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
333 p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
337 --
334 x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
335 x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CATEGORY_VARRAY_TYPE
336 );
338 -- Algorithm:
339 -- BEGIN
340 -- ...
341 -- END
342 --------------------------------------------------------------------------------
343 -- Start of comments
344 -- API name : Get_ChannelsPerCategory
345 -- Type : Private
346 -- Pre-reqs : None
347 -- Function : Return all channels under a (sub)category
348 -- Parameters :
349 -- IN p_api_version IN NUMBER Required
350 -- p_init_msg_list IN VARCHAR2 Optional
351 -- Default = FND_API.G_FALSE
352 -- p_validation_level IN NUMBER Optional
353 -- Default = FND_API.G_VALID_LEVEL_FULL
354 -- p_category_id IN NUMBER Required
355 -- p_include_subcats IN VARCHAR2 Optional
356 -- Default = FND_API.G_FALSE
357 -- OUT : x_return_status OUT VARCHAR2
358 -- x_msg_count OUT NUMBER
359 -- x_msg_data OUT VARCHAR2
360 -- x_content_chan_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
361 -- Version : Current version 1.0
362 -- Previous version 1.0
363 -- Initial version 1.0
364 -- Notes :
365 --
366 -- End of comments
367 --
368 PROCEDURE Get_ChannelsPerCategory
369 ( p_api_version IN NUMBER,
370 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
371 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372 x_return_status OUT NOCOPY VARCHAR2,
373 x_msg_count OUT NOCOPY NUMBER,
374 x_msg_data OUT NOCOPY VARCHAR2,
375 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
376 p_category_id IN NUMBER,
377 p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
378 x_content_chan_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
379 );
380 --
381 -- Algorithm:
382 -- BEGIN
383 -- ...
384 -- END
385 --------------------------------------------------------------------------------
386 --
387 -- Start of comments
388 -- API name : Fetch_CategoryId
389 -- Type : Private
390 -- Pre-reqs : None
391 -- Function : Return category id for a category or subcategory name.
392 -- Parameters :
393 -- IN p_api_version IN NUMBER Required
394 -- p_init_msg_list IN VARCHAR2 Optional
395 -- Default = FND_API.G_FALSE
396 -- p_validation_level IN NUMBER Optional
397 -- Default = FND_API.G_VALID_LEVEL_FULL
398 -- p_category_name IN VARCHAR2 Required
399 -- (sub)category id
400 -- p_parent_category_id IN NUMBER Optional
401 -- Default = FND_API.G_MISS_NUM
402 -- parent category id
403 -- OUT : x_return_status OUT VARCHAR2
404 -- x_msg_count OUT NUMBER
405 -- x_msg_data OUT VARCHAR2
406 -- x_category_id OUT NUMBER
407 -- Version : Current version 1.0
408 -- Previous version 1.0
409 -- Initial version 1.0
410 -- Notes :
411 -- End of comments
412 --
413 --
414 PROCEDURE Fetch_CategoryId
415 ( p_api_version IN NUMBER,
416 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418 x_return_status OUT NOCOPY VARCHAR2,
419 x_msg_count OUT NOCOPY NUMBER,
420 x_msg_data OUT NOCOPY VARCHAR2,
421 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
422 p_application_id IN NUMBER,
423 p_category_name IN VARCHAR2,
424 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
425 x_category_id OUT NOCOPY NUMBER
426 );
427 -- Algorithm:
428 -- BEGIN
429 -- ...
430 -- END
431 --------------------------------------------------------------------------------
432 --------------------------------------------------------------------------------
433 --
434 -- Start of comments
435 -- API name : Get_CatParentsHierarchy
436 -- Type : Private
437 -- Pre-reqs : None
438 -- Function : Return parents hierarchy of category name and ids
439 -- for a category id.
440 -- Parameters :
441 -- IN p_api_version IN NUMBER Required
442 -- p_init_msg_list IN VARCHAR2 Optional
443 -- Default = FND_API.G_FALSE
444 -- p_validation_level IN NUMBER Optional
445 -- Default = FND_API.G_VALID_LEVEL_FULL
446 -- p_category_id IN NUMBER Required
447 -- (sub)category id
448 -- OUT : x_return_status OUT VARCHAR2
449 -- x_msg_count OUT NUMBER
450 -- x_msg_data OUT VARCHAR2
454 -- Initial version 1.0
451 -- x_category_hierarchy OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
452 -- Version : Current version 1.0
453 -- Previous version 1.0
455 -- Notes :
456 -- End of comments
457 --
458 --
459 PROCEDURE Get_CatParentsHierarchy
460 ( p_api_version IN NUMBER,
461 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
462 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
463 x_return_status OUT NOCOPY VARCHAR2,
464 x_msg_count OUT NOCOPY NUMBER,
465 x_msg_data OUT NOCOPY VARCHAR2,
466 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
467 p_category_id IN NUMBER,
468 x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
469 );
470 -- Algorithm:
471 -- BEGIN
472 -- ...
473 -- END
474 --------------------------------------------------------------------------------
475 --------------------------------------------------------------------------------
476 --
477 -- Start of comments
478 -- API name : Get_CatChildrenHierarchy
479 -- Type : Private
480 -- Pre-reqs : None
481 -- Function : Return children hierarchy of category name and ids
482 -- for a category id.
483 -- Parameters :
484 -- IN p_api_version IN NUMBER Required
485 -- p_init_msg_list IN VARCHAR2 Optional
486 -- Default = FND_API.G_FALSE
487 -- p_validation_level IN NUMBER Optional
488 -- Default = FND_API.G_VALID_LEVEL_FULL
489 -- p_category_id IN NUMBER Required
490 -- (sub)category id
491 -- OUT : x_return_status OUT VARCHAR2
492 -- x_msg_count OUT NUMBER
493 -- x_msg_data OUT VARCHAR2
494 -- x_category_hierarchy OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
495 -- Version : Current version 1.0
496 -- Previous version 1.0
497 -- Initial version 1.0
498 -- Notes :
499 -- End of comments
500 --
501 --
502 PROCEDURE Get_CatChildrenHierarchy
503 ( p_api_version IN NUMBER,
504 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
505 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506 x_return_status OUT NOCOPY VARCHAR2,
507 x_msg_count OUT NOCOPY NUMBER,
508 x_msg_data OUT NOCOPY VARCHAR2,
509 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
510 p_category_id IN NUMBER,
511 x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
512 );
513 -- Algorithm:
514 -- BEGIN
515 -- ...
516 -- END
517 --------------------------------------------------------------------------------
518 --------------------------------------------------------------------------------
519 --
520 -- Start of comments
521 -- API name : Get_ChnCategoryHierarchy
522 -- Type : Private
523 -- Pre-reqs : None
524 -- Function : Return parents hierarchy of category name and ids
525 -- for a channel id.
526 -- Parameters :
527 -- IN p_api_version IN NUMBER Required
528 -- p_init_msg_list IN VARCHAR2 Optional
529 -- Default = FND_API.G_FALSE
530 -- p_validation_level IN NUMBER Optional
531 -- Default = FND_API.G_VALID_LEVEL_FULL
532 -- p_channel_id IN NUMBER Required
533 -- channel id
534 -- OUT : x_return_status OUT VARCHAR2
535 -- x_msg_count OUT NUMBER
536 -- x_msg_data OUT VARCHAR2
537 -- x_channel_name OUT VARCHAR2
538 -- x_category_hierarchy OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
539 -- Version : Current version 1.0
540 -- Previous version 1.0
541 -- Initial version 1.0
542 -- Notes :
543 -- End of comments
544 --
545 --
546 PROCEDURE Get_ChnCategoryHierarchy
547 ( p_api_version IN NUMBER,
548 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
549 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
550 x_return_status OUT NOCOPY VARCHAR2,
551 x_msg_count OUT NOCOPY NUMBER,
552 x_msg_data OUT NOCOPY VARCHAR2,
553 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
554 p_channel_id IN NUMBER,
555 x_channel_name OUT NOCOPY VARCHAR2,
556 x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
557 );
558 -- Algorithm:
559 -- BEGIN
560 -- ...
561 -- END
562 --------------------------------------------------------------------------------
563 -- Start of comments
564 -- API name : Get_ItemsPerCategory
565 -- Type : Private
566 -- Pre-reqs : None
567 -- Function : Return all items directly under
568 -- a content channel (sub)category
569 -- Parameters :
570 -- IN p_api_version IN NUMBER Required
574 -- Default = FND_API.G_VALID_LEVEL_FULL
571 -- p_init_msg_list IN VARCHAR2 Optional
572 -- Default = FND_API.G_FALSE
573 -- p_validation_level IN NUMBER Optional
575 -- p_category_id IN NUMBER Required
576 -- p_include_subcats IN VARCHAR2 Optional
577 -- Default = FND_API.G_FALSE
578 -- OUT : x_return_status OUT VARCHAR2
579 -- x_msg_count OUT NUMBER
580 -- x_msg_data OUT VARCHAR2
581 -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
582 -- Version : Current version 1.0
583 -- Previous version 1.0
584 -- Initial version 1.0
585 -- Notes :
586 --
587 -- End of comments
588 --
589 PROCEDURE Get_ItemsPerCategory
590 ( p_api_version IN NUMBER,
591 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
592 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
593 x_return_status OUT NOCOPY VARCHAR2,
594 x_msg_count OUT NOCOPY NUMBER,
595 x_msg_data OUT NOCOPY VARCHAR2,
596 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
597 p_category_id IN NUMBER,
598 p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
599 p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
600 p_category_sort IN AMV_CATEGORY_PVT.AMV_SORT_OBJ_TYPE,
601 x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
602 x_items_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
603 );
604 --
605 -- Algorithm:
606 -- BEGIN
607 -- ...
608 -- END
609 --------------------------------------------------------------------------------
610 --
611 -- Start of comments
612 -- API name : Add_CategoryParent
613 -- Type : Private
614 -- Pre-reqs : None
615 -- Function : attaches a category to a parent category
616 -- Parameters :
617 -- IN p_api_version IN NUMBER Required
618 -- p_init_msg_list IN VARCHAR2 Optional
619 -- Default = FND_API.G_FALSE
620 -- p_validation_level IN NUMBER Optional
621 -- Default = FND_API.G_VALID_LEVEL_FULL
622 -- p_category_id IN NUMBER Required
623 -- category id
624 -- p_parent_category_id IN NUMBER Required
625 -- parent category id
626 -- p_replace_existing IN VARCHAR2 Optional
627 -- Default = FND_API.G_FALSE
628 -- OUT : x_return_status OUT VARCHAR2
629 -- x_msg_count OUT NUMBER
630 -- x_msg_data OUT VARCHAR2
631 -- Version : Current version 1.0
632 -- Previous version 1.0
633 -- Initial version 1.0
634 -- Notes :
635 -- End of comments
636 --
637 --
638 PROCEDURE Add_CategoryParent
639 ( p_api_version IN NUMBER,
640 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
641 p_commit IN VARCHAR2 := FND_API.G_FALSE,
642 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
643 x_return_status OUT NOCOPY VARCHAR2,
644 x_msg_count OUT NOCOPY NUMBER,
645 x_msg_data OUT NOCOPY VARCHAR2,
646 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
647 p_object_version_number IN NUMBER,
648 p_category_id IN NUMBER,
649 p_parent_category_id IN NUMBER,
650 p_replace_existing IN VARCHAR2 := FND_API.G_FALSE
651 );
652 -- Algorithm:
653 -- BEGIN
654 -- ...
655 -- END
656 --------------------------------------------------------------------------------
657 --------------------------------------------------------------------------------
658 --
659 -- Start of comments
660 -- API name : Remove_CategoryParent
661 -- Type : Private
662 -- Pre-reqs : None
663 -- Function : removes a category from a parent category
664 -- Parameters :
665 -- IN p_api_version IN NUMBER Required
666 -- p_init_msg_list IN VARCHAR2 Optional
667 -- Default = FND_API.G_FALSE
668 -- p_validation_level IN NUMBER Optional
669 -- Default = FND_API.G_VALID_LEVEL_FULL
670 -- p_category_id IN NUMBER Required
671 -- category id
672 -- OUT : x_return_status OUT VARCHAR2
673 -- x_msg_count OUT NUMBER
674 -- x_msg_data OUT VARCHAR2
675 -- Version : Current version 1.0
676 -- Previous version 1.0
677 -- Initial version 1.0
678 -- Notes :
679 -- End of comments
680 --
681 --
682 PROCEDURE Remove_CategoryParent
683 ( p_api_version IN NUMBER,
684 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
685 p_commit IN VARCHAR2 := FND_API.G_FALSE,
686 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
687 x_return_status OUT NOCOPY VARCHAR2,
688 x_msg_count OUT NOCOPY NUMBER,
689 x_msg_data OUT NOCOPY VARCHAR2,
690 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
691 p_object_version_number IN NUMBER,
692 p_category_id IN NUMBER
693 );
694 -- Algorithm:
695 -- BEGIN
696 -- ...
697 -- END
698 --------------------------------------------------------------------------------
699 --------------------------------------------------------------------------------
700 --
701 END amv_category_grp;