Search Results update_ben_asg

Overview

BEN_ASSIGNMENT_API is a public PL/SQL package in the APPS schema that provides the supported programmatic interface for creating, maintaining, and removing Oracle Advanced Benefits (OAB) assignment records in Oracle E-Business Suite 12.1.1 and 12.2.2. An "assignment" in this context represents the link between a person, a payroll assignment, and an enrollment result within the Benefits module. The package encapsulates the business rules, validation logic, and datetrack-aware write operations required to keep benefits assignment data consistent with Oracle HRMS and Oracle Payroll. Because it is classified as an API in the ETRM registry, it is the sanctioned entry point for external or custom code that needs to manipulate benefits assignment data without directly writing to the underlying tables. Direct DML against the base tables is unsupported and risks bypassing the date-tracking, eligibility, and enrollment-result integrity rules enforced here.

Key Procedures and Functions

Three documented entry points are exposed by the package. Parameter lists are intentionally omitted, as the ETRM metadata does not publish them; callers should obtain exact signatures from the package specification in the database.

• CREATE_BEN_ASG — Inserts a new benefits assignment record. It validates the supplied person, assignment, and enrollment context and persists the corresponding row in the benefits assignment structures, applying effective-dating rules.
• UPDATE_BEN_ASG — Modifies an existing benefits assignment. It performs a datetracked update so that historical assignment information is preserved in line with Oracle HRMS date-tracking conventions.
• DELETE_BEN_ASG — Removes or logically terminates a benefits assignment, respecting the effective-date model rather than performing an unconditional physical delete.

The package depends on APPS.HR_API and SYS.STANDARD, confirming that it delegates core HR assignment handling and date-track processing to the HR API layer.

Tables Accessed

The package reads and writes a broad set of APPS synonyms reflecting its role at the intersection of Benefits, HR, and Payroll:

• PER_ALL_ASSIGNMENTS_F — the primary HR assignment record, the anchor for any benefits assignment.
• BEN_PRTT_ENRT_RSLT_F and BEN_LE_CLSN_N_RSTR — participant enrollment results and life-event classification/restriction data used for eligibility and validation.
• PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_COST_ALLOCATIONS_F, PAY_ASSIGNMENT_LINK_USAGES_F, PAY_ASSIGNMENT_LATEST_BALANCES, PAY_ALL_PAYROLLS_F — payroll element entry, costing, and balance information needed to align benefits deductions and credits with payroll.
• HR_LOCATIONS_ALL, HR_ORGANIZATION_INFORMATION, HR_SOFT_CODING_KEYFLEX, HR_ASSIGNMENT_SET_AMENDMENTS — HR location, organization, and key flexfield context.
• GL_CODE_COMBINATIONS — general ledger accounting flexfield validation for costing.
• PAY_PERSONAL_PAYMENT_METHODS_F — payment method context for the person.

Usage Notes

BEN_ASSIGNMENT_API is invoked by Oracle's own benefits processing components rather than being called exclusively by end users. The dependency listing shows it is referenced by BEN_ASSIGNMENT_INTERNAL, BEN_DT_TRGR_HANDLE, BEN_ELEMENT_ENTRY, BEN_PROCESS_COBRA_PERSON_SS, and HRDPP_CREATE_BEN_ASG, indicating use during date-track trigger handling, element entry generation, COBRA processing, and the HR data pump path for benefits assignments. Custom code should call these procedures instead of issuing direct inserts or updates, since the API enforces eligibility, date-tracking, and payroll integration rules. Typical invocation points include benefits enrollment and life-event concurrent processes and any custom integration that synchronizes assignment data from external systems. Because operations are datetracked, callers must supply valid effective dates and expect that deletes are handled as terminations rather than physical removals.