Search Results pa_hr_summarizations




Overview
Explore in AI Chat

Overview

PA_HR_SUMMARIZATIONS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. It belongs to the Oracle Projects (PA) product family and, per the ETRM classification metadata, is registered as an OTHER-type API rather than a formal public interface. Its business purpose is to validate and summarize the human-resources side of project resource assignments — the linkage between Oracle HR persons and jobs and the project resources that reference them.

The package operates primarily as a referential-integrity and summarization helper. It checks whether an HR person or job record is still referenced by project-side resource mappings and transaction accumulations, thereby protecting the integrity of the PA_RESOURCE_MAPS and PA_TXN_ACCUM data when HR records change or are considered for end-dating. The documented dependency list shows only SYS.STANDARD as a hard reference, confirming that the package relies on standard PL/SQL constructs and that its substantive logic is expressed through SQL against the PA tables listed below.

Key Procedures and Functions

The ETRM metadata documents two procedures for this package:

  • CHECK_PERSON_REFERENCE — Validates whether a given HR person is referenced by project resource or transaction-accumulation data. It is used to determine whether a person record can safely be considered unreferenced before HR-level maintenance or end-dating is performed.
  • CHECK_JOB_REFERENCE — Performs the equivalent validation for HR jobs, establishing whether a job definition is still used by project resource mappings or accumulated transactions.

No parameter lists are published in the documented metadata, and none are inferred here. Both routines are procedural checks: they evaluate reference state and return a result that the calling program uses to decide whether an HR change is permissible.

Tables Accessed

The documented table references reachable through APPS synonyms are:

  • PA_RESOURCE_MAPS — The mapping table that ties project resources to their underlying HR and other source definitions. It is the primary evidence of whether a person or job is actively used as a project resource, and therefore the primary input to both CHECK_PERSON_REFERENCE and CHECK_JOB_REFERENCE.
  • PA_TXN_ACCUM — The project transaction accumulations table, which holds summarized cost and quantities by resource. Because accumulations retain a resource identity historically, this table is consulted so that a person or job with accumulated project transactions is not treated as unreferenced.

The package therefore reads reference data rather than maintaining its own persistent structures; no insert or update targets are documented.

Usage Notes

PA_HR_SUMMARIZATIONS is an internal dependency of the Oracle Projects HR-integration code path rather than an end-user API. The documented reverse references confirm this: the package is referenced by PA_HR_SUMMARIZATIONS itself and by the packages PA_JOB and PA_PERSON. In practice, PA_PERSON and PA_JOB invoke the CHECK_*_REFERENCE routines when their own maintenance logic needs to know whether an HR person or job remains in use by project resources or accumulated transactions.

Typical invocation scenarios include population or refresh of HR-derived project resource definitions, validation before an HR person or job is end-dated or otherwise retired, and error handling when a referenced HR record is about to be modified. Custom code should not call this package directly for new development; the supported extension points for person and job integration are the PA_PERSON and PA_JOB packages that call it. Because the package is classified as OTHER and carries no published parameter specification in ETRM, any direct call would depend on undocumented behavior and is not recommended for upgrade-safe customization.