1 PACKAGE amv_category_pvt AUTHID CURRENT_USER AS
2 /* $Header: amvvcats.pls 115.15 2003/01/29 16:43:51 kelangov ship $ */
3 --
4 -- NAME
5 -- AMV_CATEGORY_PVT
6 -- PURPOSE
7 --
8 -- HISTORY
9 -- 07/19/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 TYPE AMV_CHAR_VARRAY_TYPE IS TABLE OF VARCHAR2(4000);
20 --INDEX BY BINARY_INTEGER;
21
22 TYPE AMV_NUMBER_VARRAY_TYPE IS TABLE OF NUMBER;
23 --INDEX BY BINARY_INTEGER;
24
25 TYPE amv_return_obj_type IS RECORD(
26 returned_record_count NUMBER,
27 next_record_position NUMBER,
28 total_record_count NUMBER
29 );
30
31 TYPE amv_request_obj_type IS RECORD(
32 records_requested NUMBER,
33 start_record_position NUMBER,
34 return_total_count_flag VARCHAR2(1)
35 );
36
37 TYPE AMV_CATEGORY_OBJ_TYPE IS RECORD(
38 category_id NUMBER,
39 object_version_number NUMBER,
40 parent_category_id NUMBER,
41 category_order NUMBER,
42 channel_count NUMBER,
43 category_name VARCHAR2(80),
44 description VARCHAR2(2000),
45 count NUMBER
46 );
47
48 TYPE AMV_CATEGORY_VARRAY_TYPE IS TABLE OF AMV_CATEGORY_OBJ_TYPE;
49 --INDEX BY BINARY_INTEGER;
50
51 TYPE amv_cat_hierarchy_obj_type IS RECORD(
52 hierarchy_level number,
53 id number,
54 name varchar2(240)
55 );
56
57 TYPE AMV_SORT_OBJ_TYPE IS RECORD(
58 sort_col varchar2(80),
59 sort_dir varchar2(80)
60 );
61
62 TYPE amv_cat_hierarchy_varray_type IS TABLE of amv_cat_hierarchy_obj_type;
63 --INDEX BY BINARY_INTEGER;
64
65 --------------------------------------------------------------------------------
66 --------------------------------------------------------------------------------
67 -- Start of comments
68 -- API name : Add_Category
69 -- Type : Private
70 -- Pre-reqs : None
71 -- Function : Create channel (sub)category.
72 -- Parameters :
73 -- IN p_api_version IN NUMBER Required
74 -- p_init_msg_list IN VARCHAR2 Optional
75 -- Default = FND_API.G_FALSE
76 -- p_commit IN VARCHAR2 Optional
77 -- Default = FND_API.G_FALSE
78 -- p_validation_level IN NUMBER Optional
79 -- Default = FND_API.G_VALID_LEVEL_FULL
80 -- p_application_id IN NUMBER Optional
81 -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)
82 -- application creating the channel
83 -- p_category_name IN VARCHAR2 Required
84 -- the channel category name. Have to be unique.
85 -- p_description IN VARCHAR2 Optional
86 -- the channel (sub)category description.
87 -- p_parent_category_id IN VARCHAR2 Optional
88 -- Default = FND_API.G_MISS_NUM
89 -- p_parent_category_name IN VARCHAR2 Optional
90 -- Default = FND_API.G_MISS_CHAR
91 -- parent id or name required for creating sub categories.
92 -- p_order IN NUMBER Optional
93 -- Default = FND_API.G_MISS_NUM
94 -- the order of this catgory among all the categories
95 -- OUT : x_return_status OUT VARCHAR2
96 -- x_msg_count OUT NUMBER
97 -- x_msg_data OUT VARCHAR2
98 -- x_category_id OUT NUMBER
99 -- Version : Current version 1.0
100 -- Previous version 1.0
101 -- Initial version 1.0
102 -- Notes :
103 --
104 -- End of comments
105 --
106 PROCEDURE Add_Category
107 ( p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE,
110 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
115 p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
116 p_category_name IN VARCHAR2,
117 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
119 p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_order IN NUMBER := FND_API.G_MISS_NUM,
121 x_category_id OUT NOCOPY NUMBER
122 );
123 --
124 -- Algorithm:
125 -- BEGIN
126 -- ...
127 -- END
128 --
129 --------------------------------------------------------------------------------
130 -- Start of comments
131 -- API name : Delete_Category
132 -- Type : Private
133 -- Pre-reqs : None
134 -- Function : Delete channel (sub)category given the
135 -- p_category_id(preferred) or p_category_name.
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_category_id IN NUMBER Optional
145 -- Default = FND_API.G_MISS_NUM
146 -- channel (sub)category id.
147 -- p_category_name IN VARCHAR2 Optional
148 -- Default = FND_API.G_MISS_CHAR
149 -- channel (sub)category name.
150 -- p_parent_category_id IN NUMBER Optional
151 -- Default = FND_API.G_MISS_NUM
152 -- p_parent_category_name IN VARCHAR2 Optional
153 -- Default = FND_API.G_MISS_CHAR
154 -- Either pass the channe (sub)category id (preferred)
155 -- or channel (sub)category name
156 -- to identify the channel (sub)category.
157 -- OUT : x_return_status OUT VARCHAR2
158 -- x_msg_count OUT NUMBER
159 -- x_msg_data OUT VARCHAR2
160 -- Version : Current version 1.0
161 -- Previous version 1.0
162 -- Initial version 1.0
163 -- Notes :
164 --
165 -- End of comments
166 --
167 PROCEDURE Delete_Category
168 ( p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170 p_commit IN VARCHAR2 := FND_API.G_FALSE,
171 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
176 p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
177 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
178 p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
179 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
180 p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
181 );
182 --
183 -- Algorithm:
184 -- BEGIN
185 -- ...
186 -- END
187 --
188 --------------------------------------------------------------------------------
189 -- Start of comments
190 -- API name : Sort_Category
191 -- Type : Private
192 -- Pre-reqs : None
193 -- Function : sort (sub)category list in ascending or descending order
194 -- Parameters :
195 -- IN p_api_version IN NUMBER Required
196 -- p_init_msg_list IN VARCHAR2 Optional
197 -- Default = FND_API.G_FALSE
198 -- p_commit IN VARCHAR2 Optional
199 -- Default = FND_API.G_FALSE
200 -- p_validation_level IN NUMBER Optional
201 -- Default = FND_API.G_VALID_LEVEL_FULL
202 -- p_sort_order IN VARCHAR2 Optional
203 -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER
204 -- Ascending(ASC) or Descending(DESC) Order.
205 -- p_parent_category_id IN NUMBER Optional
206 -- Default = FND_API.G_MISS_NUM
207 -- parent id for sub categories
208 -- p_parent_category_name IN VARCHAR2 Optional
209 -- Default = FND_API.G_MISS_CHAR
210 -- category name for sub categories
211 -- category name or parent category id should be
212 -- supplied for sorting sub categories
213 -- OUT : x_return_status OUT VARCHAR2
214 -- x_msg_count OUT NUMBER
215 -- x_msg_data OUT VARCHAR2
216 -- Version : Current version 1.0
217 -- Previous version 1.0
218 -- Initial version 1.0
219 -- Notes :
220 --
221 -- End of comments
222 --
223 PROCEDURE Sort_Category
224 ( p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226 p_commit IN VARCHAR2 := FND_API.G_FALSE,
227 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
232 p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
233 p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
234 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
235 p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
236 );
237 --
238 -- Algorithm:
239 -- BEGIN
240 -- ...
241 -- END
242 --
243 --------------------------------------------------------------------------------
244 -- Start of comments
245 -- API name : Reorder_Category
246 -- Type : Private
247 -- Pre-reqs : None
248 -- Function : Reorder channel (sub)category list
249 -- Parameters :
250 -- IN p_api_version IN NUMBER Required
251 -- p_init_msg_list IN VARCHAR2 Optional
252 -- Default = FND_API.G_FALSE
253 -- p_commit IN VARCHAR2 Optional
254 -- Default = FND_API.G_FALSE
255 -- p_validation_level NUMBER Optional
256 -- Default = FND_API.G_VALID_LEVEL_FULL
257 -- p_category_id_array IN AMV_NUMBER_VARRAY_TYPE
258 -- Required
259 -- p_category_new_order IN AMV_NUMBER_VARRAY_TYPE
260 -- Required
261 -- OUT : x_return_status OUT VARCHAR2
262 -- x_msg_count OUT NUMBER
263 -- x_msg_data OUT VARCHAR2
264 -- Version : Current version 1.0
265 -- Previous version 1.0
266 -- Initial version 1.0
267 -- Notes :
268 --
269 -- End of comments
270 --
271 PROCEDURE Reorder_Category
272 ( p_api_version IN NUMBER,
273 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274 p_commit IN VARCHAR2 := FND_API.G_FALSE,
275 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
280 p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
281 p_category_id_array IN AMV_NUMBER_VARRAY_TYPE,
282 p_category_new_order IN AMV_NUMBER_VARRAY_TYPE
283 );
284 --
285 -- Algorithm:
286 -- BEGIN
287 -- ...
288 -- END
289 --
290 --------------------------------------------------------------------------------
291 -- Start of comments
292 -- API name : Update_Category
293 -- Type : Private
294 -- Pre-reqs : None
295 -- Function : Update channel (sub)category given (sub)category id or name
296 -- Parameters :
297 -- IN p_api_version IN NUMBER Required
298 -- p_init_msg_list IN VARCHAR2 Optional
299 -- Default = FND_API.G_FALSE
300 -- p_commit IN VARCHAR2 Optional
301 -- Default = FND_API.G_FALSE
302 -- p_validation_level IN NUMBER Optional
303 -- Default = FND_API.G_VALID_LEVEL_FULL
304 -- p_object_version_number IN NUMBER Required
305 -- object version number
306 -- p_category_id IN NUMBER Required
307 -- channel category id.
308 -- p_category_name IN VARCHAR2 Optional
309 -- channel category name.
310 -- (sub)category id or name is required
311 -- p_parent_category_id IN NUMBER Optional
312 -- Default = FND_API.G_MISS_NUM
313 -- channel category id.
314 -- p_parent_category_name IN VARCHAR2 Optional
315 -- Default = FND_API.G_MISS_CHAR
316 -- channel category name.
317 -- takes either parent id or name. id taken if both passed
318 -- p_category_order IN NUMBER Optional
319 -- new channel category order
320 -- p_category_new_name IN VARCHAR2 Optional
321 -- new channel category name. New name has to be unique
322 -- p_description IN VARCHAR2 Optional
323 -- Default = FND_API.G_MISS_CHAR
324 -- channel category description.
325 -- OUT : x_return_status OUT VARCHAR2
326 -- x_msg_count OUT NUMBER
327 -- x_msg_data OUT VARCHAR2
328 -- Version : Current version 1.0
329 -- Previous version 1.0
330 -- Initial version 1.0
331 -- Notes :
332 --
333 -- End of comments
334 --
335 PROCEDURE Update_Category
336 ( p_api_version IN NUMBER,
337 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338 p_commit IN VARCHAR2 := FND_API.G_FALSE,
339 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340 x_return_status OUT NOCOPY VARCHAR2,
341 x_msg_count OUT NOCOPY NUMBER,
342 x_msg_data OUT NOCOPY VARCHAR2,
343 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
344 p_object_version_number IN NUMBER,
348 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
345 p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
346 p_category_id IN NUMBER := FND_API.G_MISS_NUM,
347 p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
349 p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
350 p_category_order IN NUMBER := FND_API.G_MISS_NUM,
351 p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
352 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
353 );
354 --
355 -- Algorithm:
356 -- BEGIN
357 -- ...
358 -- END
359 --
360 --------------------------------------------------------------------------------
361 -- Start of comments
362 -- API name : Find_Categories
363 -- Type : Private
364 -- Pre-reqs : None
365 -- Function : Search and return channel (sub)categories
366 -- Parameters :
367 -- IN p_api_version IN NUMBER Required
368 -- p_init_msg_list IN VARCHAR2 Optional
369 -- Default = FND_API.G_FALSE
370 -- p_validation_level NUMBER Optional
371 -- Default = FND_API.G_VALID_LEVEL_FULL
372 -- p_application_id IN NUMBER Optional
373 -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)
374 -- application creating the channel
375 -- p_category_name IN VARCHAR2 Optional
376 -- Search criteria by name. Default = '%' (everything)
377 -- p_parent_category_id IN NUMBER Optional
378 -- Default = FND_API.G_MISS_NUM
379 -- parent id for sub categories
380 -- p_parent_category_name IN VARCHAR2 Optional
381 -- Default = FND_API.G_MISS_CHAR
382 -- parent name for sub categories
383 -- takes either parent id or name. id taken if both passed
384 -- OUT : x_return_status OUT VARCHAR2
385 -- x_msg_count OUT NUMBER
386 -- x_msg_data OUT VARCHAR2
387 -- x_chan_category_rec_array OUT AMV_CATEGORY_VARRAY_TYPE
388 -- Version : Current version 1.0
389 -- Previous version 1.0
390 -- Initial version 1.0
391 -- Notes :
392 --
393 -- End of comments
394 --
395 PROCEDURE Find_Categories
396 ( p_api_version IN NUMBER,
397 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399 x_return_status OUT NOCOPY VARCHAR2,
400 x_msg_count OUT NOCOPY NUMBER,
401 x_msg_data OUT NOCOPY VARCHAR2,
402 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
403 p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
404 p_category_name IN VARCHAR2 := '%',
405 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
406 p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407 p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
408 p_request_obj IN AMV_REQUEST_OBJ_TYPE,
409 x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
410 x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_VARRAY_TYPE
411 );
412 --
413 -- Algorithm:
414 -- BEGIN
415 -- ...
416 -- END
417 --------------------------------------------------------------------------------
418 -- Start of comments
419 -- API name : Get_ChannelsPerCategory
420 -- Type : Private
421 -- Pre-reqs : None
422 -- Function : Return all channels directly under
423 -- a content channel (sub)category
424 -- Parameters :
425 -- IN p_api_version IN NUMBER Required
426 -- p_init_msg_list IN VARCHAR2 Optional
427 -- Default = FND_API.G_FALSE
428 -- p_validation_level IN NUMBER Optional
429 -- Default = FND_API.G_VALID_LEVEL_FULL
430 -- p_category_id IN NUMBER Required
431 -- p_include_subcats IN VARCHAR2 Optional
432 -- Default = FND_API.G_FALSE
433 -- OUT : x_return_status OUT VARCHAR2
434 -- x_msg_count OUT NUMBER
435 -- x_msg_data OUT VARCHAR2
436 -- x_content_chan_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
437 -- Version : Current version 1.0
438 -- Previous version 1.0
439 -- Initial version 1.0
440 -- Notes :
441 --
442 -- End of comments
443 --
444 PROCEDURE Get_ChannelsPerCategory
445 ( p_api_version IN NUMBER,
446 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
447 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448 x_return_status OUT NOCOPY VARCHAR2,
449 x_msg_count OUT NOCOPY NUMBER,
450 x_msg_data OUT NOCOPY VARCHAR2,
451 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
452 p_category_id IN NUMBER,
453 p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
454 x_content_chan_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
455 );
456 --
457 -- Algorithm:
458 -- BEGIN
462 -- Start of comments
459 -- ...
460 -- END
461 --------------------------------------------------------------------------------
463 -- API name : Get_ItemsPerCategory
464 -- Type : Private
465 -- Pre-reqs : None
466 -- Function : Return all items directly under
467 -- a content channel (sub)category
468 -- Parameters :
469 -- IN p_api_version IN NUMBER Required
470 -- p_init_msg_list IN VARCHAR2 Optional
471 -- Default = FND_API.G_FALSE
472 -- p_validation_level IN NUMBER Optional
473 -- Default = FND_API.G_VALID_LEVEL_FULL
474 -- p_category_id IN NUMBER Required
475 -- p_include_subcats IN VARCHAR2 Optional
476 -- Default = FND_API.G_FALSE
477 -- OUT : x_return_status OUT VARCHAR2
478 -- x_msg_count OUT NUMBER
479 -- x_msg_data OUT VARCHAR2
480 -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
481 -- Version : Current version 1.0
482 -- Previous version 1.0
483 -- Initial version 1.0
484 -- Notes :
485 --
486 -- End of comments
487 --
488 PROCEDURE Get_ItemsPerCategory
489 ( p_api_version IN NUMBER,
490 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
491 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
492 x_return_status OUT NOCOPY VARCHAR2,
493 x_msg_count OUT NOCOPY NUMBER,
494 x_msg_data OUT NOCOPY VARCHAR2,
495 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
496 p_category_id IN NUMBER,
497 p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
498 x_items_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
499 );
500 --
501 -- Algorithm:
502 -- BEGIN
503 -- ...
504 -- END
505 --------------------------------------------------------------------------------
506 -- Start of comments
507 -- API name : Get_ItemsPerCategory
508 -- Type : Private
509 -- Pre-reqs : None
510 -- Function : Return all items directly under
511 -- a content channel (sub)category
512 -- Parameters :
513 -- IN p_api_version IN NUMBER Required
514 -- p_init_msg_list IN VARCHAR2 Optional
515 -- Default = FND_API.G_FALSE
516 -- p_validation_level IN NUMBER Optional
517 -- Default = FND_API.G_VALID_LEVEL_FULL
518 -- p_category_id IN NUMBER Required
519 -- p_include_subcats IN VARCHAR2 Optional
520 -- Default = FND_API.G_FALSE
521 -- OUT : x_return_status OUT VARCHAR2
522 -- x_msg_count OUT NUMBER
523 -- x_msg_data OUT VARCHAR2
524 -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
525 -- Version : Current version 1.0
526 -- Previous version 1.0
527 -- Initial version 1.0
528 -- Notes :
529 --
530 -- End of comments
531 --
532 PROCEDURE Get_ItemsPerCategory
533 ( p_api_version IN NUMBER,
534 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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 IN VARCHAR2 := FND_API.G_TRUE,
540 p_category_id IN NUMBER,
541 p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
542 p_request_obj IN AMV_REQUEST_OBJ_TYPE,
543 p_category_sort IN AMV_SORT_OBJ_TYPE,
544 x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
545 x_items_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
546 );
547 --
548 -- Algorithm:
549 -- BEGIN
550 -- ...
551 -- END
552 --------------------------------------------------------------------------------
553 --
554 -- Start of comments
555 -- API name : Fetch_CategoryId
556 -- Type : Private
557 -- Pre-reqs : None
558 -- Function : Return category id for a category or subcategory name.
559 -- Parameters :
560 -- IN p_api_version IN NUMBER Required
561 -- p_init_msg_list IN VARCHAR2 Optional
562 -- Default = FND_API.G_FALSE
563 -- p_validation_level IN NUMBER Optional
564 -- Default = FND_API.G_VALID_LEVEL_FULL
565 -- p_category_name IN VARCHAR2 Required
566 -- (sub)category id
567 -- p_parent_category_id IN NUMBER Optional
568 -- Default = FND_API.G_MISS_NUM
569 -- parent category id
570 -- p_parent_category_name IN VARCHAR2 Optional
571 -- Default = FND_API.G_MISS_CHAR
572 -- parent category name
573 -- parent id or name required for subcategory name
574 -- OUT : x_return_status OUT VARCHAR2
578 -- Version : Current version 1.0
575 -- x_msg_count OUT NUMBER
576 -- x_msg_data OUT VARCHAR2
577 -- x_category_id OUT NUMBER
579 -- Previous version 1.0
580 -- Initial version 1.0
581 -- Notes :
582 -- End of comments
583 --
584 --
585 PROCEDURE Fetch_CategoryId
586 ( p_api_version IN NUMBER,
587 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
588 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
589 x_return_status OUT NOCOPY VARCHAR2,
590 x_msg_count OUT NOCOPY NUMBER,
591 x_msg_data OUT NOCOPY VARCHAR2,
592 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
593 p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
594 p_category_name IN VARCHAR2,
595 p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
596 p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
597 x_category_id OUT NOCOPY NUMBER
598 );
599 -- Algorithm:
600 -- BEGIN
601 -- ...
602 -- END
603 --------------------------------------------------------------------------------
604 --------------------------------------------------------------------------------
605 --
606 -- Start of comments
607 -- API name : Get_CatParentsHierarchy
608 -- Type : Private
609 -- Pre-reqs : None
610 -- Function : Return parents hierarchy of category name and ids
611 -- for a category id.
612 -- Parameters :
613 -- IN p_api_version IN NUMBER Required
614 -- p_init_msg_list IN VARCHAR2 Optional
615 -- Default = FND_API.G_FALSE
616 -- p_validation_level IN NUMBER Optional
617 -- Default = FND_API.G_VALID_LEVEL_FULL
618 -- p_category_id IN NUMBER Required
619 -- (sub)category id
620 -- OUT : x_return_status OUT VARCHAR2
621 -- x_msg_count OUT NUMBER
622 -- x_msg_data OUT VARCHAR2
623 -- x_category_hierarchy OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
624 -- Version : Current version 1.0
625 -- Previous version 1.0
626 -- Initial version 1.0
627 -- Notes :
628 -- End of comments
629 --
630 --
631 PROCEDURE Get_CatParentsHierarchy
632 ( p_api_version IN NUMBER,
633 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
634 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
635 x_return_status OUT NOCOPY VARCHAR2,
636 x_msg_count OUT NOCOPY NUMBER,
637 x_msg_data OUT NOCOPY VARCHAR2,
638 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
639 p_category_id IN NUMBER,
640 x_category_hierarchy OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
641 );
642 -- Algorithm:
643 -- BEGIN
644 -- ...
645 -- END
646 --------------------------------------------------------------------------------
647 --------------------------------------------------------------------------------
648 --
649 -- Start of comments
650 -- API name : Get_CatChildrenHierarchy
651 -- Type : Private
652 -- Pre-reqs : None
653 -- Function : Return children hierarchy of category name and ids
654 -- for a category id.
655 -- Parameters :
656 -- IN p_api_version IN NUMBER Required
657 -- p_init_msg_list IN VARCHAR2 Optional
658 -- Default = FND_API.G_FALSE
659 -- p_validation_level IN NUMBER Optional
660 -- Default = FND_API.G_VALID_LEVEL_FULL
661 -- p_category_id IN NUMBER Required
662 -- (sub)category id
663 -- OUT : x_return_status OUT VARCHAR2
664 -- x_msg_count OUT NUMBER
665 -- x_msg_data OUT VARCHAR2
666 -- x_category_hierarchy OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
667 -- Version : Current version 1.0
668 -- Previous version 1.0
669 -- Initial version 1.0
670 -- Notes :
671 -- End of comments
672 --
673 --
674 PROCEDURE Get_CatChildrenHierarchy
675 ( p_api_version IN NUMBER,
676 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
677 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
678 x_return_status OUT NOCOPY VARCHAR2,
679 x_msg_count OUT NOCOPY NUMBER,
680 x_msg_data OUT NOCOPY VARCHAR2,
681 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
682 p_category_id IN NUMBER,
683 x_category_hierarchy OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
684 );
685 -- Algorithm:
686 -- BEGIN
687 -- ...
688 -- END
689 --------------------------------------------------------------------------------
690 --------------------------------------------------------------------------------
691 --
692 -- Start of comments
693 -- API name : Get_ChnCategoryHierarchy
694 -- Type : Private
695 -- Pre-reqs : None
699 -- IN p_api_version IN NUMBER Required
696 -- Function : Return parents hierarchy of category name and ids
697 -- for a channel id.
698 -- Parameters :
700 -- p_init_msg_list IN VARCHAR2 Optional
701 -- Default = FND_API.G_FALSE
702 -- p_validation_level IN NUMBER Optional
703 -- Default = FND_API.G_VALID_LEVEL_FULL
704 -- p_channel_id IN NUMBER Required
705 -- channel id
706 -- OUT : x_return_status OUT VARCHAR2
707 -- x_msg_count OUT NUMBER
708 -- x_msg_data OUT VARCHAR2
709 -- x_channel_name OUT VARCHAR2
710 -- x_category_hierarchy OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
711 -- Version : Current version 1.0
712 -- Previous version 1.0
713 -- Initial version 1.0
714 -- Notes :
715 -- End of comments
716 --
717 --
718 PROCEDURE Get_ChnCategoryHierarchy
719 ( p_api_version IN NUMBER,
720 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
721 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
722 x_return_status OUT NOCOPY VARCHAR2,
723 x_msg_count OUT NOCOPY NUMBER,
724 x_msg_data OUT NOCOPY VARCHAR2,
725 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
726 p_channel_id IN NUMBER,
727 x_channel_name OUT NOCOPY VARCHAR2,
728 x_category_hierarchy OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
729 );
730 -- Algorithm:
731 -- BEGIN
732 -- ...
733 -- END
734 --------------------------------------------------------------------------------
735 --------------------------------------------------------------------------------
736 --
737 -- Start of comments
738 -- API name : Add_CategoryParent
739 -- Type : Private
740 -- Pre-reqs : None
741 -- Function : attaches a category to a parent category
742 -- Parameters :
743 -- IN p_api_version IN NUMBER Required
744 -- p_init_msg_list IN VARCHAR2 Optional
745 -- Default = FND_API.G_FALSE
746 -- p_validation_level IN NUMBER Optional
747 -- Default = FND_API.G_VALID_LEVEL_FULL
748 -- p_category_id IN NUMBER Required
749 -- category id
750 -- p_parent_category_id IN NUMBER Required
751 -- parent category id
752 -- p_replace_existing IN VARCHAR2 Optional
753 -- Default = FND_API.G_FALSE
754 -- OUT : x_return_status OUT VARCHAR2
755 -- x_msg_count OUT NUMBER
756 -- x_msg_data OUT VARCHAR2
757 -- Version : Current version 1.0
758 -- Previous version 1.0
759 -- Initial version 1.0
760 -- Notes :
761 -- End of comments
762 --
763 --
764 PROCEDURE Add_CategoryParent
765 ( p_api_version IN NUMBER,
766 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
767 p_commit IN VARCHAR2 := FND_API.G_FALSE,
768 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
769 x_return_status OUT NOCOPY VARCHAR2,
770 x_msg_count OUT NOCOPY NUMBER,
771 x_msg_data OUT NOCOPY VARCHAR2,
772 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
773 p_object_version_number IN NUMBER,
774 p_category_id IN NUMBER,
775 p_parent_category_id IN NUMBER,
776 p_replace_existing IN VARCHAR2 := FND_API.G_FALSE
777 );
778 -- Algorithm:
779 -- BEGIN
780 -- ...
781 -- END
782 --------------------------------------------------------------------------------
783 --------------------------------------------------------------------------------
784 --
785 -- Start of comments
786 -- API name : Remove_CategoryParent
787 -- Type : Private
788 -- Pre-reqs : None
789 -- Function : removes a category from a parent category
790 -- Parameters :
791 -- IN p_api_version IN NUMBER Required
792 -- p_init_msg_list IN VARCHAR2 Optional
793 -- Default = FND_API.G_FALSE
794 -- p_validation_level IN NUMBER Optional
795 -- Default = FND_API.G_VALID_LEVEL_FULL
796 -- p_category_id IN NUMBER Required
797 -- category id
798 -- OUT : x_return_status OUT VARCHAR2
799 -- x_msg_count OUT NUMBER
800 -- x_msg_data OUT VARCHAR2
801 -- Version : Current version 1.0
802 -- Previous version 1.0
803 -- Initial version 1.0
804 -- Notes :
805 -- End of comments
806 --
807 --
808 PROCEDURE Remove_CategoryParent
809 ( p_api_version IN NUMBER,
810 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811 p_commit IN VARCHAR2 := FND_API.G_FALSE,
812 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813 x_return_status OUT NOCOPY VARCHAR2,
814 x_msg_count OUT NOCOPY NUMBER,
815 x_msg_data OUT NOCOPY VARCHAR2,
816 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
817 p_object_version_number IN NUMBER,
818 p_category_id IN NUMBER
819 );
820 -- Algorithm:
821 -- BEGIN
822 -- ...
823 -- END
824 --------------------------------------------------------------------------------
825 --
826 END amv_category_pvt;