Search Results task_references

Overview

APPS.PQH_PRVCALC is a PL/SQL package within the Oracle E-Business Suite Public Sector/HR (PQH) module, associated with the HRMS template and task configuration framework. Its header declares AUTHID CURRENT_USER, indicating that the package executes with the privileges of the invoking user rather than the definer, and references the source revision pqprvcal.pkh 115.13. The package is classified under the generic API classification "OTHER" in the ETRM repository for release 12.2.2, and it is equally applicable to 12.1.1 given the shared PQH code line.

The primary business function of PQH_PRVCALC is to calculate and evaluate the visibility, mode, and required-flag properties of attributes within HRMS templates and tasks. In other words, it drives the "privilege calculation" logic that determines which fields (attributes) appear on a task or template, whether they are mandatory, and in what mode (for example, enabled versus read-only) they are presented. This logic underpins configurable HR self-service and administrative pages where a single template can present different fields to different users or processes based on task and domain configuration.

Key Procedures and Functions

The package documents twelve procedures and functions. The type declarations t_task_templ, t_attid_priv_typ, t_attname_priv_typ, and t_blocks define the in-memory structures used to pass attribute IDs, form column names, mode flags, and required flags between routines; the package also declares a global g_result of type t_attname_priv.

• DOMAIN_RESULT_CALC — Populates a result collection of attribute ID privilege records for a given template/domain (parameter p_domain, output p_result). It is the domain-level entry point for computing attribute privilege outcomes.
• TASK_REFERENCES — Accepts a task/template identifier (p_task) and an in-out collection p_result_int, resolving attribute references associated with that task. This is the procedure located by the "task_references" search term.
• TASK_RESULT_UPDATE — Accepts a task/template identifier and a task type, updating task-level result information into the working collection.
• ATTRIBUTE_FLAG_RESULT — Computes and returns the flag result for an individual attribute.
• TASK_TASK_MODE_COMP_FLAG — Compares and evaluates mode flags at the task-to-task level.
• DOMAIN_TASK_MODE_COMP_FLAG — Compares and evaluates mode flags between a domain and its associated tasks.
• PRIVILEDGE_CALC — Performs the core privilege calculation, aggregating attribute, task, and domain configuration into effective privilege results.
• TEMPLATE_ATTRIB_REQD_CALC — Determines required-flag status for attributes defined on a template.
• GET_ROW_PRV — Retrieves row-level privilege information for use by calling routines.
• CHECK_PRIV_CALC — Validates or verifies the outcome of a privilege calculation.
• PRIVILEDGE_CALC_COUNT — Returns a count related to privilege calculation results, typically used for validation or looping.
• GET_ATTRIBUTE_MODE — Returns the effective mode (for example, enabled/read-only) for a given attribute.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• PQH_ATTRIBUTES — Master definition of attributes, supplying attribute_id values used throughout the privilege records.
• PQH_TEMPLATE_ATTRIBUTES — Associates attributes with templates; provides template_id and the linkage that anchors domain and task calculations.
• PQH_TXN_CATEGORY_ATTRIBUTES — Maps transaction categories to attributes, influencing which attributes are eligible for a given task context.
• PQH_REF_TEMPLATES — Reference template definitions used to resolve template inheritance and defaults.
• PLITBLM — The generic HRMS PL/SQL table/index utility used for caching and list handling within the calculation loops.

Usage Notes

PQH_PRVCALC is an internal calculation engine rather than a user-facing API. It is referenced by five other packages, which typically invoke PRIVILEDGE_CALC, DOMAIN_RESULT_CALC, or TASK_REFERENCES to build the attribute collections that drive HRMS forms and self-service pages. In Oracle EBS 12.1.1 and 12.2.2, it is most commonly called indirectly from the template/task configuration forms (such as the HRMS Templates and Task setup forms) and from concurrent or batch processes that precompute attribute privileges. Because of its AUTHID CURRENT_USER declaration and its reliance on the g_result global and package-level collection types, custom code should not call it concurrently within the same session without reinitializing the global, and should treat the collection types as the sole supported contract. Direct invocation in customizations is discouraged; integrators should prefer the documented higher-level APIs in the PQH family and treat PQH_PRVCALC's procedures as implementation detail subject to change across patches.