Search Results reorder_category

Overview

AMV_CATEGORY_GRP_W is a PL/SQL package in the Oracle E-Business Suite APPS schema that supports the category management and hierarchy functionality used by Oracle Marketing and related category grouping features. The "_W" suffix indicates that this is a wrapper package, exposing a procedural interface that shields callers from the underlying business logic and data structures. It provides the programmatic surface through which callers can reorder categories, locate categories according to name and hierarchy criteria, enumerate the channels assigned to a category, and traverse both the child and parent category hierarchies.

The package belongs to the AMV (Marketing) module family and is closely associated with the JTF (Java Transaction Framework) table types used throughout EBS for passing collections of identifiers and attributes between PL/SQL and Java or OAF layers. Its presence in the APPS schema and its classification as an OTHER API confirm that it is a general-purpose utility wrapper rather than a workflow-enabled or interface-table API.

Key Procedures and Functions

• REORDER_CATEGORY — This is the procedure associated with the user search term "reorder_category". It accepts arrays of category identifiers and their intended new display order and applies the resequencing, returning the standard API return status, message count, and message data. It supports the interactive reordering of categories within a group.
• FIND_CATEGORIES — Retrieves categories based on a category name, an optional parent category identifier, and an ignore-hierarchy flag. It returns the matched categories as JTF collection types through a set of OUT parameters.
• GET_CHANNELSPERCATEGORY — Returns the channels associated with a given category, optionally including subcategories, using JTF number and varchar2 collection OUT parameters.
• GET_CATPARENTSHIERARCHY — Walks and returns the parent hierarchy for a specified category.
• GET_CATCHILDRENHIERARCHY — Returns the child hierarchy beneath a specified category.
• GET_CHNCATEGORYHIERARCHY — Returns the channel-to-category hierarchy relationship.
• GET_ITEMSPERCATEGORY — Returns the items assigned to a given category.

Tables Accessed

The documented metadata for this package does not enumerate specific base tables; the ETRM record lists no referenced tables via APPS synonyms. Functionally, the package operates against the standard category and channel data model used by Oracle Marketing, including category definitions and their hierarchical relationships and the channel assignments that link categories to marketing channels. Because table access is not documented, implementers should treat the underlying schema as internal and rely solely on the packaged procedures rather than querying base tables directly.

Usage Notes

AMV_CATEGORY_GRP_W is typically invoked from Oracle Forms, OAF pages, or custom PL/SQL that requires category reordering and hierarchy navigation without direct table manipulation. The reorder_category entry point is the canonical way to persist a user-defined category sequence. Callers should observe the standard EBS API conventions: initialize the message list as directed by p_init_msg_list, inspect x_return_status for success or error, and retrieve messages via x_msg_count and x_msg_data. The package is referenced by no other packages according to the metadata, so it is intended as a leaf-level utility. When extending or debugging category behaviour, custom code should call these procedures rather than writing to the category tables directly.