DBA Data[Home] [Help]

APPS.AMV_CATEGORY_GRP dependencies on AMV_CATEGORY_PVT

Line 145: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER

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

Line 170: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,

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:

Line 217: p_category_id_array IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE,

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:

Line 218: p_category_new_order IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE

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

Line 333: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,

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: --

Line 334: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,

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:

Line 335: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CATEGORY_VARRAY_TYPE

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

Line 378: x_content_chan_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

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

Line 468: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

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: -- ...

Line 511: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

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: -- ...

Line 556: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

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: -- ...

Line 599: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,

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: );

Line 600: p_category_sort IN AMV_CATEGORY_PVT.AMV_SORT_OBJ_TYPE,

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: --

Line 601: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,

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:

Line 602: x_items_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

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