Search Results create_pl_dei_info

Overview

The APPS.PER_PL_DEI_INFO package is a PL/SQL API within the Oracle E-Business Suite Human Resources (PER) product family that manages "Person/Personnel Legislation" Document Extra Information records. Its name reflects its purpose: PER (Human Resources), PL (Personnel/legislative context), and DEI (Document Extra Info). In Oracle HRMS, certain legislative or regulatory documents — such as identification papers, work permits, visas, or other country-specific credentials — require descriptive attributes that fall outside the standard document tracking model. The HR_DOCUMENT_EXTRA_INFO table stores this supplementary detail, and the PER_PL_DEI_INFO package provides the programmatic interface for creating and maintaining those rows.

The package is classified as OTHER rather than as a public, fully supported API, indicating that it is primarily an internal building block used by Oracle's own application code rather than a formally published integration point. Its header version (pepldeip.pkh 120.0.12000000.1, dated 2007) shows it has been part of the application stack since the early 12.x releases and remains present through 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes two documented procedures:

• CREATE_PL_DEI_INFO — Inserts a new document extra information record for a person. It associates a specific document type and document number with a person, and captures the issuance date along with the effective date range (from/to) during which the document is considered valid. This is the procedure most commonly identified when users search for create_pl_dei_info.
• UPDATE_PL_DEI_INFO — Modifies an existing document extra information record, identified by its primary key. It allows the document type, document number, associated person, validity date range, and issued date to be changed after initial creation.

No parameter lists are reproduced here; the documented signatures define the procedures as operating on person, document type, document number, issued date, and date-from/date-to attributes, consistent with the two procedures above.

Tables Accessed

• HR_DOCUMENT_EXTRA_INFO — The primary target of the package. Both procedures write to this table: CREATE inserts new rows, and UPDATE modifies existing rows identified by DOCUMENT_EXTRA_INFO_ID. This table holds the document number, issued date, and validity period keyed to a person.
• HR_DOCUMENT_TYPES — Referenced to validate and resolve the document type supplied to the procedures. This table defines the legislative document categories available for the enterprise's business group, ensuring the extra information row is linked to a valid, defined document type.

Usage Notes

Because the package is classified as OTHER and is referenced by two other application packages, it is typically invoked indirectly. In standard EBS HRMS flows, document extra information is captured through the Person management forms and related legislative/regulatory screens; those forms and their underlying business logic call PER_PL_DEI_INFO internally to persist the data. Customizations and integrations that need to populate document extra information programmatically may call CREATE_PL_DEI_INFO and UPDATE_PL_DEI_INFO directly, but should do so with care, since the package is not a formally published API. Callers should establish a valid session context (APPS initialization, business group, and person context), supply a valid DOCUMENT_TYPE_ID from HR_DOCUMENT_TYPES, and manage transactions explicitly. As with any non-public HR API, Oracle recommends validating behavior against the target release and considering supported alternatives before relying on it in production custom code.