Search Results amv_search_grp_w




Overview
Explore in AI Chat

Overview

AMV_SEARCH_GRP_W is a public PL/SQL package in the APPS schema that supports Oracle EBS Territory Management search operations, part of the Application Management/AMV module. The package provides the API layer for locating and querying territory repositories and their content, exposing a set of procedures that surface repository, area, and content search results through JTF indexed table types. In Oracle EBS 12.1.1 and 12.2.2, this package functions as the programmatic entry point for applications and forms that need to retrieve territory repository definitions without directly querying the underlying AMV base tables. The stored package header carries the version marker $Header: amvwsrgs.pls 120.2 2005/06/30 08:44 appldev ship $, indicating a long-stable interface that has been shipped as part of the standard APPLDEV delivery.

Key Procedures and Functions

The package header documents three procedures, all following the Oracle Application Object Library (AOL) API conventions, including the standard p_api_version, p_init_msg_list, p_validation_level, x_return_status, x_msg_count, and x_msg_data parameters, plus a p_check_login_user flag.

  • FIND_REPOSITORIES — Locates territory repositories matching the supplied search criteria. It accepts repository identifiers and descriptive attributes (repository ID, code, name, status), and returns result sets through generic indexed table output parameters (JTF_NUMBER_TABLE and JTF_VARCHAR2_TABLE_100 types).
  • FIND_REPOSITORY_AREAS — Retrieves the areas associated with a repository. It returns multiple parallel indexed table collections representing area identifiers, descriptive values, and numeric attributes. Default values such as fnd_api.g_miss_char and 0-1962.0724 (the Oracle date-based null sentinel) are applied to the search input parameters.
  • CONTENT_SEARCH — The procedure relevant to the user's search term. It performs a content-based search across territory repository data, accepting an application identifier and an area array in addition to the standard API parameters. This is the documented entry point for free-text or criteria-driven content lookups within the AMV search group framework.

Tables Accessed

The documented ETRM metadata for this package does not enumerate any base tables referenced through APPS synonyms. In practice, the AMV search group procedures operate against the AMV territory repository and repository area entities, but no table-level dependencies are published for AMV_SEARCH_GRP_W in the 12.2.2 documentation. The absence of documented table references means integrators should treat the data model as encapsulated behind the API and avoid assuming direct read or write paths.

Usage Notes

AMV_SEARCH_GRP_W conforms to the standard Oracle public API pattern: callers invoke the procedures with an API version, initialize the message list as required, inspect x_return_status for fnd_api.g_ret_sts_success, and iterate x_msg_count/x_msg_data on error. The p_check_login_user parameter allows the caller to control whether the current FND login user is validated during execution, which is useful when the API is invoked from concurrent programs or background processes where an interactive session is not present. The ETRM metadata records that no other packages reference AMV_SEARCH_GRP_W, indicating it is a leaf-level API consumed directly by forms, OAF pages, or custom extensions rather than by other server-side PL/SQL units. The package is typically invoked from Territory Management setup and search screens, and from custom code that needs to enumerate repositories, repository areas, or perform content searches against AMV territory data in both 12.1.1 and 12.2.2 environments.