Results for “assignment_change”

8 results




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

Overview

PA_HR_UPDATE_PA_ENTITIES is a PL/SQL package body owned by the APPS schema that synchronizes Oracle Human Resources (HR) master data changes into the Oracle Projects (PA) entity model. In Oracle EBS 12.1.1 and 12.2.2, Projects stores denormalized copies of key HR attributes for resources, organizations, jobs, and assignments in tables such as PA_RESOURCES and PA_RESOURCES_DENORM. When HR data changes — for example, an employee's full name, an assignment, an organization, or a job attribute — those changes must be propagated to the Projects tables so that downstream project reporting, billing, and resource searches remain accurate. This package encapsulates that propagation logic, exposing one general entry point (UPDATE_PROJECT_ENTITIES) plus a family of change-specific handlers. According to the shipped header, the file is versioned as PAHRUPDB.pls 120.6.12010000.2 (2008/11/13), consistent with the 12.1.1 code line that is carried forward into 12.2.2.

Key Procedures and Functions

The package exposes thirteen documented program units. They fall into three groups.

The body also contains a private log_message routine that writes diagnostic output through PA_DEBUG when the PA_DEBUG_MODE profile option is set to 'Y'.

Tables Accessed

Per the documented metadata, the package reads and writes the following tables (referenced through APPS synonyms):

  • HR_ALL_ORGANIZATION_UNITS — source of the current HR organization definition (name, structure) used when propagating organization changes.
  • PA_RESOURCES — the primary Projects resource/entity table holding the denormalized resource record.
  • PA_RESOURCES_DENORM — the denormalized resource attributes table; updated by change handlers such as FULL_NAME_CHANGE and ASSIGNMENT_CHANGE.
  • PER_ALL_ASSIGNMENTS_F — the HR assignment datemapped source used by ASSIGNMENT_CHANGE and related logic.
  • PER_ASSIGNMENT_STATUS_TYPES — assignment status values used when validating or translating assignment changes.
  • PER_JOBS — job definition source used by JOB_BILL_CHANGE, JOB_REL_CHANGE, and JOB_LEVEL_CHANGE.
  • DUAL — used for single-row lookups and control logic.

Usage Notes

PA_HR_UPDATE_PA_ENTITIES is not a user-facing concurrent program by itself; it is an internal service layer invoked by HR and Projects integration flows. Typical invocation patterns are:

  • HR business events or concurrent processes (for example, those that detect changes on PER_ALL_ASSIGNMENTS_F or HR_ALL_ORGANIZATION_UNITS) call the appropriate change handler to push the change into PA.
  • Oracle Projects forms and concurrent programs may call UPDATE_PROJECT_ENTITIES with the relevant calling mode and table name when a user edits a project entity that requires HR-side reconciliation.
  • The FTE synchronization workflow procedures (CREATE_FTE_SYNC_WF, START_FTE_SYNC_WF) are called when FTE values must be recalculated and synchronized to Projects.
  • The package is referenced by 18 other packages, indicating it is a shared integration utility within the PA/HR boundary. Customizations should invoke only the documented handlers and should not assume return values or parameter ordering beyond what the shipped specification provides. Diagnostic tracing is available by setting the PA_DEBUG_MODE profile option to 'Y'.