Search Results pqh_prvcalc




Overview
Explore in AI Chat

Overview

APPS.PQH_PRVCALC is a PL/SQL package body in the Oracle E-Business Suite HRMS schema. Its name derives from the Public Sector "PRV" (privilege) calculation domain, and it functions as part of the Public Sector/Recruitment template engine managed by the PQH (Oracle Advanced Benefits/Human Resources Public Sector) product family. In EBS 12.1.1 and 12.2.2 the package is documented as VALID with an API classification of OTHER, indicating it is an internal supporting package rather than a published open interface.

The package centralizes privilege, eligibility, and attribute-mode evaluation logic that drives how template-driven task and domain configurations are interpreted at runtime. It determines whether a given attribute is required, whether a task or domain mode comparison flag is satisfied, and how privilege values are derived and counted against a user or organizational context. This logic underpins the personalized rendering of HR/Public Sector self-service pages and the validation of transactions raised against configured templates.

Key Procedures and Functions

Twelve documented program units are catalogued in the ETRM metadata. Consistent with an internal utility package, they fall into three functional clusters:

Collectively these units implement the privilege-evaluation and attribute-requirement rules that the template framework calls during page and transaction processing.

Tables Accessed

The package reads and writes a small, well-defined set of configuration tables, accessed through APPS synonyms:

  • PQH_TEMPLATE_ATTRIBUTES — the definition of attributes belonging to a template; the source for requirement and mode calculations.
  • PQH_ATTRIBUTES — the master attribute definitions referenced by template attributes.
  • PQH_TXN_CATEGORY_ATTRIBUTES — links transaction categories to attributes, supporting transaction-level privilege checks.
  • PQH_REF_TEMPLATES — the reference template definitions that tie templates to their using contexts.
  • PLITBLM — the standard Oracle PL/SQL table-of-varchar2 type used for in-memory collections.

Additionally, APPS.PQH_PRVCALC depends on APPS.HR_UTILITY, PQH_PRVCALC itself (recursive or overloaded internal calls), and the SYS.STANDARD package. The metadata records that the package body is not referenced by any database object, while the parent package is referenced by five other packages — confirming that callers depend on the specification, not the body.

Usage Notes

PQH_PRVCALC is an internal engine package and is normally invoked indirectly. Typical invocations originate from HR/Public Sector OAF or Forms-based pages that render template-driven attributes, from the transaction-validation path that verifies privileges against PQH_TXN_CATEGORY_ATTRIBUTES, and from other PQH packages that call the package specification. Because the body is not referenced externally, its implementation may change without breaking dependent objects as long as the specification remains stable.

Customizers should avoid calling undocumented internals directly and instead extend behavior through supported template configuration. When debugging privilege or attribute-mode discrepancies in 12.1.1 or 12.2.2, the documented procedures listed above are the appropriate diagnostic entry points.