Search Results pay_au_processes_s

Overview

PAY_APR_INS is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. Its name follows the Payroll (PAY) application naming convention, where the "APR" component denotes Application Assignment / owner-application processing logic used by the Australian localization. The package sits in the payroll setup and assignment layer and is responsible for inserting and maintaining application ownership definitions that tie an application (such as a payroll application or an application ownership record) to the correct owner and process context.

In EBS Release 12.1.1 and 12.2.2 this object is classified as a standard API ("OTHER" classification per ETRM), meaning it is an internal utility rather than a public, externally supported API. It depends on a substantial set of HR and PAY components, including HR_API, HR_APPLICATION_OWNERSHIPS, HR_OWNER_DEFINITIONS, HR_STARTUP_DATA_API_SUPPORT, HR_UTILITY, PAY_APR_BUS, and PAY_APR_SHD, which confirms that its role is to validate and persist application ownership rows while delegating business rules and shared logic to companion packages.

Key Procedures and Functions

Three documented program units are exposed by the package body:

• INS — The principal insert routine. It creates new application ownership records, performing the mandatory-validation and row-insertion steps required to register an application against its owning entity. It is the entry point invoked when a new ownership definition must be created.
• SET_BASE_KEY_VALUE — A helper that establishes the base key value used to identify the record being processed. It supports the insert logic by resolving the surrogate or business key before the row is written.
• Internal business/shared routines — The package body also invokes PAY_APR_BUS (business rules) and PAY_APR_SHD (shared, non-validating utilities), which supply the validation and common logic that INS relies upon.

Tables Accessed

The documented dependency list identifies four tables reached through APPS synonyms:

• HR_APPLICATION_OWNERSHIPS — The principal target of the insert logic; stores the mapping between applications and their owners.
• HR_OWNER_DEFINITIONS — Supplies the owner definition information against which ownership rows are validated and created.
• PAY_AU_PROCESSES — The Australian processes table, consulted to associate process records with the application ownership being inserted.
• PAY_AU_PROCESSES_S — The translated (TL) counterpart of PAY_AU_PROCESSES, used to read process descriptions in the session language.

Additional dependencies on HR_API, HR_MULTI_MESSAGE, FND_MESSAGE, FND_NUMBER, HR_UTILITY, HR_STARTUP_DATA_API_SUPPORT, and STANDARD/DUAL indicate that error messaging, numeric conversion, and HR API framework calls are performed in the course of the insert.

Usage Notes

PAY_APR_INS is not intended for direct customer invocation. It is an internal package reached by higher-level payroll setup and data-loading flows. Typical invocation paths include Australian payroll configuration forms, startup-data / seed-data loaders that use HR_STARTUP_DATA_API_SUPPORT, and the two dependent packages documented in ETRM. Because the API classification is "OTHER" rather than a supported public API, direct calls from custom code are discouraged; customizations should use the corresponding public HR or PAY APIs. Note also that the package is not referenced by any other database object according to the metadata, confirming its position as a leaf-level implementation unit. When debugging application-ownership insertion issues on 12.1.1 or 12.2.2, trace entry through INS and inspect the HR_APPLICATION_OWNERSHIPS and HR_OWNER_DEFINITIONS rows produced, together with PAY_AU_PROCESSES for the associated Australian process.