Search Results per_ppc_ins




Overview
Explore in AI Chat

Overview

PER_PPC_INS is an Oracle EBS Applications (APPS) schema PL/SQL package body that supports the Payroll Pay Proposal Components feature within Oracle Human Resources / Oracle Payroll. The object is classified under the ETRM as an "OTHER" API type, indicating it is an internal, implementation-support package rather than a public, documented application programming interface. Its status is VALID, and it resides in the APPS schema in both EBS 12.1.1 and 12.2.2.

Functionally, PER_PPC_INS provides insert-processing logic for pay proposal components — the individual earnings, deductions, and other elements that make up a pay proposal. The naming convention (PER_PPC_INS) follows the Oracle HRMS family pattern, where "PER" identifies the HR product, "PPC" abbreviates Pay Proposal Components, and "INS" denotes the insert handler. Such packages encapsulate the row-level logic needed to create new component records consistently, invoking shared business rules and supporting infrastructure rather than duplicating that logic in each calling form or program.

Key Procedures and Functions

The documented metadata records a single exposed program unit named INS. Consistent with Oracle HRMS "INS"-suffixed packages, this procedure performs the insert operation for pay proposal component records. It applies the package's internal validation and processing logic to the data being inserted, then delegates the physical write and any associated business processing to the supporting packages in the dependency chain. Detailed parameter lists are not published in the metadata and are not reproduced here; consumers should not assume a signature.

The package body depends on several companion and infrastructure packages: HR_API and HR_UTILITY for standard HR API and utility services; PER_PPC_BUS, which carries the business logic for pay proposal components; PER_PPC_RKI, the row-level insert trigger-handler package; and PER_PPC_SHD, the shadow/audit-handling package. The presence of PER_PPC_INS as a dependency of itself reflects the standard generated pattern in which the body is listed among its own internal references. This combination of business, row-handler, and shadow logic confirms that PER_PPC_INS is a thin insert layer sitting above the core PPC business rules.

Tables Accessed

The package operates against two documented tables, both reached through APPS synonyms:

The INS procedure inserts rows into PER_PAY_PROPOSAL_COMPONENTS while the shadow-handling dependency (PER_PPC_SHD) maintains the corresponding PER_PAY_PROPOSAL_COMPONENTS_S records. This pairing is typical of Oracle HRMS components that must keep an authoritative row and its shadow counterpart synchronized.

Usage Notes

PER_PPC_INS is not referenced by any other database object, which indicates it is a leaf-level implementation package invoked directly by the user interface or by internal processing rather than by other PL/SQL packages. It is typically called when a user or process adds a new component to a pay proposal — for example, through an Oracle Payroll form or an internal program that builds proposal components. Because the package is classified OTHER and carries no published API documentation, it should be treated as internal infrastructure.

Customizations should not call PER_PPC_INS directly; integrations and extensions should instead use the supported HR_API interfaces or the PER_PPC_BUS business layer so that validation, event handling, and shadow-table maintenance remain intact. Direct invocation risks bypassing the controlled insert path and producing inconsistent audit data. In 12.1.1 and 12.2.2 the package behaves identically; any assessment of custom code should confirm that it routes insert activity through the supported business package rather than through this handler.