Search Results org_hier_level_property_access

Overview

INV_ORGHIERARCHY_PVT is a private (PVT) PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Inventory (INV) module. Its purpose is to provide the Application Programming Interfaces that resolve, traverse, and validate the Inventory organization hierarchy — the multilevel structure of organizations defined through organization hierarchies and their associated security profiles. Rather than exposing data directly to forms and reports, the package centralizes the logic that determines which organizations a user may access, at what hierarchy level, and under which responsibility. Because it is a private package, its procedures are not part of a public, committed API contract and are primarily invoked by other EBS packages and forms.

The header history indicates the package originated in 2000 (created by vjavli) and evolved substantially: the Org_Hier_Level_Resp_Access function was added and later revised to accept a business group parameter and to drop the responsibility application identifier; the Org_Hier_Origin_Resp_Access function was introduced in 2001 specifically as a performance enhancement of the earlier access function; and Org_Exists_In_Hierarchy was added to support valid query logic within forms. Later revisions added NOCOPY to OUT parameters and a G_LOG_PRINT debug level that prints regardless of FND Debug mode.

Key Procedures and Functions

The documented interface comprises the following named units (purpose described only; parameter lists are not specified here):

• CONTAINED_IN_HIERARCHY — determines whether a given organization belongs within the hierarchy under evaluation; this is the routine most directly associated with the "contained_in_hierarchy" search.
• VALIDATE_PROPERTY — validates a hierarchy-related property value.
• GET_ORGANIZATION_LIST — returns the list of organizations resolved for the hierarchy context.
• ORG_HIERARCHY_ACCESS — evaluates organization-level access against the hierarchy.
• ORG_HIERARCHY_LEVEL_ACCESS — evaluates access at a specified hierarchy level.
• ORG_HIERARCHY_LIST — populates the set of hierarchies applicable to the current context.
• ORG_HIER_LEVEL_PROPERTY_ACCESS — evaluates a level property for access decisions.
• ORG_HIER_LEVEL_RESP_ACCESS — resolves hierarchy-level access for a responsibility and business group.
• ORG_HIER_ORIGIN_RESP_ACCESS — performance-optimized variant for origin/responsibility access.
• ORG_EXISTS_IN_HIERARCHY — existence check used for form-level valid queries.
• INSERT_HIERARCHY_INDEX_LIST — inserts hierarchy index entries, typically during index maintenance.
• LOG_INITIALIZE and LOG — initialize and write debug/diagnostic output, including the always-printed G_LOG_PRINT level.

Tables Accessed

The package reads organization and hierarchy metadata through APPS synonyms. HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION supply organization definitions and classification details. PER_ORGANIZATION_STRUCTURES, PER_ORG_STRUCTURE_ELEMENTS, and PER_ORG_STRUCTURE_VERSIONS define the hierarchy tree and its versioning. PER_SECURITY_PROFILES and ORG_ACCESS provide the security context that constrains which organizations a user or responsibility may see. MTL_PARAMETERS supplies Inventory organization parameters, and DUAL and PLITBLM are used for utility and standard PL/SQL table operations.

Usage Notes

As a PVT package, INV_ORGHIERARCHY_PVT is referenced by 21 other packages and is normally called indirectly — through forms (for valid-query and access checks such as ORG_EXISTS_IN_HIERARCHY), through concurrent programs, and by other Inventory packages performing hierarchy traversal. Custom code should treat these routines as internal and unstable across patches; direct calls are possible but unsupported. Debug output is controlled through LOG_INITIALIZE and LOG, with G_LOG_PRINT emitting summary information regardless of the FND Debug setting.