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
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:
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:
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
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,
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: );
337: --
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,
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: );
337: --
338: -- Algorithm:
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,
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: );
337: --
338: -- Algorithm:
339: -- BEGIN
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
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: -- ...
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: -- ...
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: -- ...
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: );
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: --
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:
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