Search Results pay_template_exclusion_rules_s

Overview

PAY_TER_INS is a PL/SQL package body owned by the APPS schema that supports the Oracle E-Business Suite Termination functionality within Oracle Payroll and Oracle Human Resources. Its object name follows the PAY_TER naming convention reserved for termination-related server-side logic, and the metadata confirms it sits in the termination processing stack alongside PAY_TER_BUS (business logic) and PAY_TER_SHD (shadow/row-history handling). The package's specific role is the management of template exclusion rules associated with termination processing. Termination templates determine which elements, assignments, and processing steps apply when an employee is terminated; exclusion rules define the conditions under which particular elements or templates are bypassed during that processing. PAY_TER_INS provides the insertion-side API logic that writes and maintains these exclusion rule definitions, relying on the PAY_TEMPLATE_EXCLUSION_RULES base table and its corresponding sequence.

Key Procedures and Functions

The ETRM documentation for PAY_TER_INS in release 12.2.2 lists two documented entry points:

• INS — The primary insertion routine. This procedure carries out the insert operations required to create termination template exclusion rule records. Based on the package naming convention, INS performs row creation against the exclusion rules entity, validating and defaulting attributes through the shared HR_API and HR_UTILITY utilities before committing the new definition.

Parameter lists are not enumerated in the documented metadata and are therefore not reproduced here. The API classification for this package is recorded as OTHER, indicating it is not exposed as a fully public, supported business API in the same manner as the main termination business process packages, but rather functions as an internal maintenance routine.

Tables Accessed

The documented table dependencies for PAY_TER_INS are:

• PAY_TEMPLATE_EXCLUSION_RULES — The base table holding termination template exclusion rule definitions. PAY_TER_INS writes new rows into this table as its principal function.
• PAY_TEMPLATE_EXCLUSION_RULES_S — The corresponding sequence used to generate unique primary key values for new rows in the base table. This dependency is directly relevant to the searched object name.

The dependency report also shows use of the SYS schema objects DUAL and STANDARD, which are typical of any PL/SQL unit. No other application tables are documented as direct dependencies of this package body.

Usage Notes

PAY_TER_INS is an internal package and is not referenced by any database object according to the ETRM dependency report. It is therefore not designed to be called directly from forms, concurrent programs, or customer-written code. It is more accurately understood as a helper invoked from within the termination processing chain, most plausibly from PAY_TER_BUS, which handles the broader termination business rules and orchestrates the supporting insert, update, and shadow-history packages. The documented dependency on PAY_TER_BUS, PAY_TER_SHD, and the shared HR_API and HR_UTILITY packages reinforces this layered design.

Customizations that need to create or modify termination template exclusion rules should target the supported business-layer APIs rather than PAY_TER_INS, since direct calls to undocumented internal routines carry upgrade risk. The reference to PAY_TEMPLATE_EXCLUSION_RULES_S is significant: it is a sequence, not a table, so tools or reports searching for it should treat it as the key-generation mechanism behind the exclusion rules base table rather than as a standalone data entity. In releases 12.1.1 and 12.2.2 the package retains VALID status, indicating it remains an active and compiled component of the termination stack.