Search Results ben_acty_rt_ded_sched_f_s

Overview

BEN_ADS_INS is a PL/SQL package body owned by the APPS schema that supports the Oracle EBS Advanced Benefits (BEN) module. Its name follows the BEN_ADS naming convention, in which "ADS" denotes an Automated Data Source or activity/eligibility processing construct within the Benefits data model. In practice, the package encapsulates the insert-side data manipulation logic for the benefit "ADS" record family, providing a controlled API surface through which dependent Benefits modules create new rows without issuing direct SQL against the underlying tables.

The object is registered as VALID and is classified as OTHER in the ETRM 12.2.2 API registry, meaning it is an internal helper package rather than a public, versioned Benefits API. It is referenced by two other database objects and does not itself reference any higher-level package, confirming its position near the bottom of the Benefits dependency stack.

Key Procedures and Functions

• INSERT_DML — The primary DML entry point for the package. It performs the actual insert of an ADS record and manages the associated column assignments against the target Benefits tables. Because the package body relies on BEN_ADS_RKI (row key information) and BEN_ADS_SHD (shadow) packages, INSERT_DML is responsible for coordinating key generation and shadow-table maintenance during the insert.
• INS — The wrapper routine normally invoked by callers. It validates the inbound context, resolves environment values through FND_GLOBAL and HR_API, and then delegates to INSERT_DML. This separation allows the calling application to pass a logical payload while the package handles key derivation and audit columns.

No parameter signatures are documented in ETRM; the procedures are identified by name and purpose only.

Tables Accessed

• BEN_ACTY_RT_DED_SCHED_F — The main activity rate deduction schedule table. The package inserts and maintains rows here. This is the object most directly associated with the user's search term ben_acty_rt_ded_sched_f_s.
• BEN_ACTY_RT_DED_SCHED_F_S — The corresponding shadow table. Benefits maintains a parallel "_S" table for date-tracked/reference auditing, and the package writes to it in step with the base table so downstream processing and secure-versioning logic remain consistent.

Supporting access includes DT_API and HR_UTILITY for date-tracked operations and HR_API for key and business-group resolution.

Usage Notes

BEN_ADS_INS is not intended to be called directly from end-user forms. It is invoked internally whenever a new "activity rate deduction schedule" row is created, typically as a subordinate call from BEN_ADS_BUS or another Benefits business-layer package. Because it is classified as OTHER rather than a public API, customizations should not call it directly; the supported path is through the documented Benefits API that owns the transaction. When troubleshooting, administrators may query the package to trace the insert of a defective schedule row, using the dependency list (BEN_ADS_RKI, BEN_ADS_SHD, BEN_ADS_BUS) to confirm that all accompanying shadow and key-generation steps were executed.