Search Results ben_cpe_bus




Overview
Explore in AI Chat

Overview

BEN_CPE_BUS is a PL/SQL package in the APPS schema that forms part of the Oracle Advanced Benefits (Oracle Benefits) module within Oracle E-Business Suite 12.1.1 and 12.2.2. The name follows Oracle's standard naming convention: BEN identifies the Benefits product family, CPE identifies the copy entity construct, and BUS denotes the business logic layer. The package therefore implements the business rules underlying the Copy Entity feature in Oracle Advanced Benefits, which allows administrators to duplicate benefit program configurations, plan designs, eligibility profiles, and related setup entities between contexts. This reduces the effort required to roll out similar benefit offerings across multiple organizations, legislations, or legislative data groups.

The ETRM documentation classifies BEN_CPE_BUS as an OTHER API and confirms its status as VALID in the APPS schema. The package body depends on BEN_CPE_SHD, the shadow (table-handler) package that performs the physical row operations on behalf of the business layer, and on the SYS STANDARD package. This two-tier arrangement — a business package fronting a shadow package — is a recurrent pattern throughout the BEN schema, and it keeps validation logic separated from table access.

Key Procedures and Functions

  • SET_SECURITY_GROUP_ID — Establishes the security group context for the session, ensuring that copy-entity operations respect the row-level security associated with the current business group. This is typically the first routine invoked before any insert, update, or delete validation.
  • RETURN_LEGISLATION_CODE — Returns the legislation code applicable to the entity being copied. Legislation code governs which configuration rules, formulas, and validations apply, so resolving it correctly is essential before the copy is committed.
  • INSERT_VALIDATE — Performs validation logic when a new copy entity record is created, confirming that required attributes, effective dates, and cross-entity relationships are consistent with the target configuration.
  • UPDATE_VALIDATE — Validates modifications to an existing copy entity record, checking that the revised definition does not violate legislative or product-level constraints.
  • DELETE_VALIDATE — Checks whether a copy entity record may be removed, guarding against deletion of records still referenced by dependents or otherwise required by the Benefits configuration.

Tables Accessed

The documented table reference for BEN_CPE_BUS, accessed through APPS synonyms, is BEN_COPY_ENTITY_RESULTS. This table stores the outcome of copy-entity processing, recording which entities were copied, their status, and associated diagnostic information. The business package reads and writes this table as part of the validate-and-execute cycle. All physical manipulation of the underlying tables is delegated to BEN_CPE_SHD, consistent with the shadow-package architecture.

Usage Notes

BEN_CPE_BUS is not intended for direct invocation by end users; it is a server-side API driven by the Benefits setup forms and by concurrent programs that perform bulk copy operations. Three packages reference it — BEN_CPE_BUS itself (internal recursive calls), BEN_CPE_DEL, BEN_CPE_INS, and BEN_CPE_UPD — indicating that the insert, update, and delete entry points of the copy-entity feature route their validation through this single business package. Customizations and extensions in Benefits should call the higher-level BEN_CPE_INS, BEN_CPE_UPD, or BEN_CPE_DEL APIs rather than BEN_CPE_BUS directly, since those packages encapsulate the correct invocation sequence. Because the package is classified as OTHER rather than a public API, Oracle does not guarantee backward compatibility of its signatures across releases, and any direct dependency should be reviewed during upgrades from 12.1.1 to 12.2.2.