eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_CATEGORY_GRP dependencies on AMV_CATEGORY_PVT

Line 73: AMV_CATEGORY_PVT.Add_Category

69: )
70: IS
71: l_api_name varchar2(30) := 'Add_Category';
72: BEGIN
73: AMV_CATEGORY_PVT.Add_Category
74: (p_api_version => p_api_version,
75: p_init_msg_list => p_init_msg_list,
76: p_commit => p_commit,
77: p_validation_level => p_validation_level,

Line 157: AMV_CATEGORY_PVT.Delete_Category

153: IS
154: l_api_name varchar2(30) := 'Delete_Category';
155: BEGIN
156:
157: AMV_CATEGORY_PVT.Delete_Category
158: (p_api_version => p_api_version,
159: p_init_msg_list => p_init_msg_list,
160: p_commit => p_commit,
161: p_validation_level => p_validation_level,

Line 201: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER

197: -- Default = FND_API.G_FALSE
198: -- p_validation_level IN NUMBER Optional
199: -- Default = FND_API.G_VALID_LEVEL_FULL
200: -- p_sort_order IN VARCHAR2 Optional
201: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER
202: -- Ascending(ASC) or Descending(DESC) Order.
203: -- p_parent_category_id IN NUMBER Optional
204: -- Default = FND_API.G_MISS_NUM
205: -- parent id for sub categories

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

222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
225: p_application_id IN NUMBER,
226: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
227: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM
228: )
229: IS
230: l_api_name varchar2(30) := 'Sort_Category';

Line 232: AMV_CATEGORY_PVT.Sort_Category

228: )
229: IS
230: l_api_name varchar2(30) := 'Sort_Category';
231: BEGIN
232: AMV_CATEGORY_PVT.Sort_Category
233: (p_api_version => p_api_version,
234: p_init_msg_list => p_init_msg_list,
235: p_commit => p_commit,
236: p_validation_level => p_validation_level,

Line 299: p_category_id_array IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE,

295: x_msg_count OUT NOCOPY NUMBER,
296: x_msg_data OUT NOCOPY VARCHAR2,
297: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
298: p_application_id IN NUMBER,
299: p_category_id_array IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE,
300: p_category_new_order IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE
301: )
302: IS
303: l_api_name varchar2(30) := 'Reorder_Category';

Line 300: p_category_new_order IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE

296: x_msg_data OUT NOCOPY VARCHAR2,
297: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
298: p_application_id IN NUMBER,
299: p_category_id_array IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE,
300: p_category_new_order IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE
301: )
302: IS
303: l_api_name varchar2(30) := 'Reorder_Category';
304: BEGIN

Line 305: AMV_CATEGORY_PVT.Reorder_Category

301: )
302: IS
303: l_api_name varchar2(30) := 'Reorder_Category';
304: BEGIN
305: AMV_CATEGORY_PVT.Reorder_Category
306: (p_api_version => p_api_version,
307: p_init_msg_list => p_init_msg_list,
308: p_commit => p_commit,
309: p_validation_level => p_validation_level,

Line 396: AMV_CATEGORY_PVT.Update_Category

392: )
393: IS
394: l_api_name varchar2(30) := 'Update_Category';
395: BEGIN
396: AMV_CATEGORY_PVT.Update_Category
397: (p_api_version => p_api_version,
398: p_init_msg_list => p_init_msg_list,
399: p_commit => p_commit,
400: p_validation_level => p_validation_level,

Line 472: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,

468: p_application_id IN NUMBER,
469: p_category_name IN VARCHAR2 := '%',
470: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
471: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
472: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
473: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
474: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CATEGORY_VARRAY_TYPE
475: )
476: IS

Line 473: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,

469: p_category_name IN VARCHAR2 := '%',
470: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
471: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
472: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
473: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
474: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CATEGORY_VARRAY_TYPE
475: )
476: IS
477: l_api_name varchar2(30) := 'Find_Categories';

Line 474: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CATEGORY_VARRAY_TYPE

470: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
471: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
472: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
473: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
474: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CATEGORY_VARRAY_TYPE
475: )
476: IS
477: l_api_name varchar2(30) := 'Find_Categories';
478: BEGIN

Line 479: AMV_CATEGORY_PVT.Find_Categories

475: )
476: IS
477: l_api_name varchar2(30) := 'Find_Categories';
478: BEGIN
479: AMV_CATEGORY_PVT.Find_Categories
480: (p_api_version => p_api_version,
481: p_init_msg_list => p_init_msg_list,
482: p_validation_level => p_validation_level,
483: x_return_status => x_return_status,

Line 546: x_content_chan_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

542: x_msg_data OUT NOCOPY VARCHAR2,
543: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
544: p_category_id IN NUMBER,
545: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
546: x_content_chan_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
547: )
548: IS
549: l_api_name varchar2(30) := 'Get_ChannelsPerCategory';
550: BEGIN

Line 551: AMV_CATEGORY_PVT.Get_ChannelsPerCategory

547: )
548: IS
549: l_api_name varchar2(30) := 'Get_ChannelsPerCategory';
550: BEGIN
551: AMV_CATEGORY_PVT.Get_ChannelsPerCategory
552: (p_api_version => p_api_version,
553: p_init_msg_list => p_init_msg_list,
554: p_validation_level => p_validation_level,
555: x_return_status => x_return_status,

Line 623: AMV_CATEGORY_PVT.Fetch_CategoryId

619: )
620: IS
621: l_api_name varchar2(30) := 'Fetch_CategoryId';
622: BEGIN
623: AMV_CATEGORY_PVT.Fetch_CategoryId
624: (p_api_version => p_api_version,
625: p_init_msg_list => p_init_msg_list,
626: p_validation_level => p_validation_level,
627: x_return_status => x_return_status,

Line 688: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

684: x_msg_count OUT NOCOPY NUMBER,
685: x_msg_data OUT NOCOPY VARCHAR2,
686: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
687: p_category_id IN NUMBER,
688: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
689: )
690: IS
691: l_api_name varchar2(30) := 'Get_CatParentsHierarchy';
692: BEGIN

Line 693: AMV_CATEGORY_PVT.Get_CatParentsHierarchy

689: )
690: IS
691: l_api_name varchar2(30) := 'Get_CatParentsHierarchy';
692: BEGIN
693: AMV_CATEGORY_PVT.Get_CatParentsHierarchy
694: (p_api_version => p_api_version,
695: p_init_msg_list => p_init_msg_list,
696: p_validation_level => p_validation_level,
697: x_return_status => x_return_status,

Line 756: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

752: x_msg_count OUT NOCOPY NUMBER,
753: x_msg_data OUT NOCOPY VARCHAR2,
754: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
755: p_category_id IN NUMBER,
756: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
757: )
758: IS
759: l_api_name varchar2(30) := 'Get_CatChildrenHierarchy';
760: BEGIN

Line 761: AMV_CATEGORY_PVT.Get_CatChildrenHierarchy

757: )
758: IS
759: l_api_name varchar2(30) := 'Get_CatChildrenHierarchy';
760: BEGIN
761: AMV_CATEGORY_PVT.Get_CatChildrenHierarchy
762: (p_api_version => p_api_version,
763: p_init_msg_list => p_init_msg_list,
764: p_validation_level => p_validation_level,
765: x_return_status => x_return_status,

Line 826: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

822: x_msg_data OUT NOCOPY VARCHAR2,
823: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
824: p_channel_id IN NUMBER,
825: x_channel_name OUT NOCOPY VARCHAR2,
826: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
827: )
828: IS
829: l_api_name varchar2(30) := 'Get_ChnCategoryHierarchy';
830: BEGIN

Line 831: AMV_CATEGORY_PVT.Get_ChnCategoryHierarchy

827: )
828: IS
829: l_api_name varchar2(30) := 'Get_ChnCategoryHierarchy';
830: BEGIN
831: AMV_CATEGORY_PVT.Get_ChnCategoryHierarchy
832: (p_api_version => p_api_version,
833: p_init_msg_list => p_init_msg_list,
834: p_validation_level => p_validation_level,
835: x_return_status => x_return_status,

Line 895: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,

891: x_msg_data OUT NOCOPY VARCHAR2,
892: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
893: p_category_id IN NUMBER,
894: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
895: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
896: p_category_sort IN AMV_CATEGORY_PVT.AMV_SORT_OBJ_TYPE,
897: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
898: x_items_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
899: )

Line 896: p_category_sort IN AMV_CATEGORY_PVT.AMV_SORT_OBJ_TYPE,

892: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
893: p_category_id IN NUMBER,
894: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
895: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
896: p_category_sort IN AMV_CATEGORY_PVT.AMV_SORT_OBJ_TYPE,
897: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
898: x_items_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
899: )
900: IS

Line 897: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,

893: p_category_id IN NUMBER,
894: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
895: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
896: p_category_sort IN AMV_CATEGORY_PVT.AMV_SORT_OBJ_TYPE,
897: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
898: x_items_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
899: )
900: IS
901: l_api_name varchar2(30) := 'Get_ItemsPerCategory';

Line 898: x_items_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

894: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
895: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
896: p_category_sort IN AMV_CATEGORY_PVT.AMV_SORT_OBJ_TYPE,
897: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
898: x_items_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
899: )
900: IS
901: l_api_name varchar2(30) := 'Get_ItemsPerCategory';
902: BEGIN

Line 903: AMV_CATEGORY_PVT.Get_ItemsPerCategory

899: )
900: IS
901: l_api_name varchar2(30) := 'Get_ItemsPerCategory';
902: BEGIN
903: AMV_CATEGORY_PVT.Get_ItemsPerCategory
904: (p_api_version => p_api_version,
905: p_init_msg_list => p_init_msg_list,
906: p_validation_level => p_validation_level,
907: x_return_status => x_return_status,

Line 979: AMV_CATEGORY_PVT.Add_CategoryParent

975: )
976: IS
977: l_api_name varchar2(30) := 'Add_CategoryParent';
978: BEGIN
979: AMV_CATEGORY_PVT.Add_CategoryParent
980: (p_api_version => p_api_version,
981: p_init_msg_list => p_init_msg_list,
982: p_commit => p_commit,
983: p_validation_level => p_validation_level,

Line 1049: AMV_CATEGORY_PVT.Remove_CategoryParent

1045: )
1046: IS
1047: l_api_name varchar2(30) := 'Remove_CategoryParent';
1048: BEGIN
1049: AMV_CATEGORY_PVT.Remove_CategoryParent
1050: (p_api_version => p_api_version,
1051: p_init_msg_list => p_init_msg_list,
1052: p_commit => p_commit,
1053: p_validation_level => p_validation_level,