Results for “pqp_hrtca_synchronization”

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

Overview

PQP_HRTCA_SYNCHRONIZATION is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the synchronization of person-level descriptive flexfield (DDF) data between HRMS person records and supplementary "extra information" structures. The package forms part of the Oracle Human Resources (PQP) module family and is used to keep person extra information types (EITs) and their associated descriptive flexfield segments consistent across the PER_PEOPLE_EXTRA_INFO model. In the context of Oracle EBS 12.1.1 and 12.2.2, the object is classified as an "OTHER" API, meaning it is not a formally published public interface but is referenced internally by other product code and can be leveraged by advanced implementers. The package specifically addresses scenarios where person extra information must be inserted, updated, or removed in a controlled manner, ensuring the DDF context and the DFF segments remain aligned with the underlying HR person record. The need for such synchronization commonly arises when configuring company policy attributes — for example, official notice period information captured against an employee or assignment — which are stored as person extra information and surfaced through self-service or professional HR forms.

Key Procedures and Functions

• PEI_DDF_INS — Inserts a new person extra information record together with its associated descriptive flexfield segment values. It accepts identifiers for the person extra information record and the person, an information type, an information category acting as the DFF context, and a set of segment value parameters (information1 through information30) representing the DFF columns. It is the entry point for creating EIT data that must remain synchronized with HR person records.
• PEI_DDF_UPD — Updates an existing person extra information record and its DDF segment values. It mirrors the insert structure, supplying a new set of segment values against an existing person extra information identifier and person identifier. This procedure is used when attributes such as notice period or other company policy fields are amended.
• PEI_DDF_DEL — Deletes a person extra information record and its associated DDF data. It provides a controlled removal path so that orphaned or obsolete EIT rows do not remain attached to a person.

Tables Accessed

• PER_PEOPLE_EXTRA_INFO — The primary target of the insert, update, and delete operations. This table stores supplementary person-level information keyed by information type and category, and holds the DFF segment columns manipulated by the procedures.
• PER_ALL_PEOPLE_F — The date-tracked person record referenced to validate and resolve the person identifier. The package uses this table to ensure that extra information is attached to a valid, effective person row.

Usage Notes

PQP_HRTCA_SYNCHRONIZATION is typically invoked from HRMS forms, concurrent programs, and custom PL/SQL that manage person extra information, rather than being called directly by end users. In Oracle EBS 12.1.1 and 12.2.2 the package is referenced by three other packages, indicating it participates in a broader synchronization chain within the PQP module. Developers implementing custom company policy attributes — including official notice period data stored as an EIT — should call these procedures instead of performing direct DML on PER_PEOPLE_EXTRA_INFO, so that DFF context and segment integrity, date-tracking behavior, and downstream dependencies remain intact.