Search Results update_pl_dei_info

Overview

APPS.PER_PL_DEI_INFO is a PL/SQL package body belonging to the Oracle Human Resources (PER) product module, providing localized support for Polish statutory "DEI" information (Dodatkowe Informacje), which relates to supplementary identification documents such as passports, identity cards, and military books recorded against a person in Oracle EBS. The package encapsulates the rules governing how these Polish-specific document records are created and maintained, ensuring that mandatory identifying attributes — issue date and document number — are captured and internally consistent before data is written to the HR document tables.

The package is classified as OTHER in the ETRM metadata, indicating it is a supporting technical utility rather than a public, versioned API. The header comment ($Header: pepldeip.pkb 120.1 2006/09/13) shows it has been shipped since the 11i/12.0 lineage and remains present in 12.1.1 and 12.2.2. The internal procedure VALIDATE_DATES — the object matching the user's "validate_dates" search term — is the validation core of the package, though it is not exposed in the ETRM procedure inventory because it is a private, package-local routine.

Key Procedures and Functions

• CREATE_PL_DEI_INFO — Inserts a new Polish DEI document record for a person. It first verifies that the Oracle Human Resources product is installed for the "PL" (Poland) legislation via hr_utility.chk_product_install, a guard added under GSI Bug 5472781; if the check fails, the procedure exits silently. It then reads the system document type from HR_DOCUMENT_TYPES and, when the type is one of the Polish statutory types (PL_PASSPORT, PL_IDENTITY_CARD, PL_MILITARY_BOOK), calls the private VALIDATE_DATES routine before creating the record.
• UPDATE_PL_DEI_INFO — Maintains existing Polish DEI document records, applying the same validation regime so that corrections to issue dates, validity periods, or document numbers remain compliant with the Polish localization rules.
• VALIDATE_DATES (private) — Enforces the business rules that will surface when users search on "validate_dates": issue date is mandatory (message HR_375884_DEI_DATE_REQD), document number is mandatory (HR_375885_DEI_NO_REQD), and the issued date must equal the valid-from date (HR_375876_INVALID_DEI_DATE). Violations are raised through hr_utility.set_message / hr_utility.raise_error, producing a standard EBS forms error.

Tables Accessed

• HR_DOCUMENT_TYPES — Read to resolve SYSTEM_DOCUMENT_TYPE for the supplied document type identifier, determining whether the Polish statutory validation path applies.
• HR_DOCUMENT_EXTRA_INFO — The principal store for DEI records. The package queries it for overlapping validity periods (date_from or date_to falling inside an existing range, or vice versa) to prevent duplicate or conflicting document entries, and inserts or updates rows through it.

Usage Notes

Because this package is classified OTHER and is not a published API, it is intended for internal consumption by the Polish localization. It is typically invoked from the Oracle Forms-based Person/Extra Information maintenance windows when a Polish legal employer records a passport, identity card, or military book against an employee, and it may equally be called from custom PL/SQL or concurrent processing that loads DEI data. The ETRM metadata records two dependent packages referencing it, confirming its role as a shared building block within the PER localization layer. Customizations should call it only through its documented procedures and must respect the same prerequisite that HR is installed for the PL legislation, otherwise CREATE_PL_DEI_INFO returns without performing any work. Validation failures are communicated through the HR message dictionary, so calling code should expect hr_utility.raise_error semantics rather than a Boolean return.