Results for “hrbisorgparams”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HRBISORGPARAMS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is an internal component of the Oracle HRMS Business Intelligence System (BIS) and is not a public, end-user API. The package materializes and maintains organizational hierarchy and organization-parameter information used by HRMS intelligence reporting and by downstream packages that require a resolved organizational structure context.

The package is declared with AUTHID CURRENT_USER, meaning that all unqualified object references resolve through the privileges of the calling schema. In Oracle EBS, this is the standard construct that allows the package to execute under APPS-owned synonyms while respecting invoker rights. The header carries the original RCS identifier $Header: hrbistab.pkh 115.2 2002/12/06 14:16:47 cbridge ship $, indicating its origin in the HRMS BIS table maintenance area.

The documented API classification is OTHER, reflecting its role as a supporting utility rather than a business-document API. The ETRM metadata further notes that the package is referenced by two other packages, confirming that it is a shared internal dependency within the HRMS BIS layer rather than an entry point invoked directly by users.

Key Procedures and Functions

Eight documented routines expose the package's functionality:

• GetOrgStructureID — Returns the organization structure identifier associated with a supplied organization structure version identifier. It resolves the parent structure from a version.
• GetOrgStructureVersionID — Performs the inverse resolution, returning the version identifier that corresponds to a given organization structure identifier.
• GetOrgParamID (overload one) — Returns an organization-parameter identifier without requiring an organization context. This overload may be used to obtain a default or current parameter record.
• GetOrgParamID (overload two) — Returns the organization-parameter identifier for a specific organization structure, organization, and organization process combination. This is the primary lookup used to bind a hierarchy load operation to the correct parameter record.
• LoadOrgHierarchy — Loads a single organizational hierarchy for a specified organization structure, organization, and process. It is the primary write routine in the package.
• LoadAllHierarchies (no arguments) — Processes all hierarchies known to the HRMS BIS structures.
• LoadAllHierarchies (overloaded) — Accepts the standard concurrent-program parameters errbuf and retcode, indicating it is intended to be invoked as a concurrent-program executable from a PL/SQL concurrent program definition.
• OrgInHierarchy — Returns a result indicating whether a child organization belongs to a specified organization group within a given organization-parameter context. This routine carries a PRAGMA RESTRICT_REFERENCES (..., WNDS, WNPS) directive, making it safe for use inside SQL statements and PL/SQL that must not write package state.

Tables Accessed

The package reads and writes the HRMS BIS organization-parameter and structure tables, referenced through APPS synonyms:

• HRI_ORG_PARAMS and HRI_ORG_PARAMS_S — the core organization-parameter store, holding hierarchy definitions keyed by organization structure, organization, and process; the _S variant is the shadow/intersection table used in the BIS denormalized model.
• HRI_ORG_PARAM_LIST — the flattened list of organization-parameter members produced by the hierarchy load routines.
• HR_ALL_ORGANIZATION_UNITS — the base organization definition table, supplying valid organization identifiers.
• PER_ORGANIZATION_STRUCTURES, PER_ORG_STRUCTURE_ELEMENTS, and PER_ORG_STRUCTURE_VERSIONS — the Oracle HRMS organization structure and version model that defines which structures and versions are available for hierarchy loading.
• DUAL — used for trivial single-row selection and sequence/context queries.

Usage Notes

HRBISORGPARAMS is not intended for direct invocation from Oracle Forms or by end users. Its typical invocation paths are concurrent programs — particularly the LoadAllHierarchies overload carrying errbuf and retcode, which the concurrent manager calls from a PL/SQL concurrent program — and internal calls from the two dependent packages documented in ETRM. Custom code should only call the read-only functions (the two GetOrgParamID overloads, GetOrgStructureID, GetOrgStructureVersionID, and OrgInHierarchy) unless a hierarchy refresh is explicitly required. Because the package is AUTHID CURRENT_USER, the calling schema must have the appropriate synonyms and grants in place, and the load routines should be executed within a controlled maintenance window since they rewrite the HRI_ORG_PARAM_LIST contents that upstream HRMS BIS reports depend upon.