Search Results fem_rule_set_members

Overview

The APPS.FEM_BR_RULE_SET_PVT package body is a private PL/SQL implementation unit within the Oracle Enterprise Profitability and Cost Management (EPCM) / Enterprise Tax, Regulatory and Management (ETRM) application family. Its name reflects its role as a private ("_PVT") helper package concerned with the maintenance of rule set definitions — the metadata objects that describe how balance and rule data are structured, identified, and applied within EPCM rule processing. In Oracle EBS 12.1.1 and 12.2.2, the FEM schema hosts the tables and APIs that underpin the Profitability Manager and related ETRM engines, and this package provides the low-level object-definition lifecycle operations that higher-level APIs and forms delegate to.

The package header carries the revision marker FEMVRUSB.pls 120.0, dated 2005, indicating it belongs to the original R12 EPCM code line and has remained stable across the 12.1.1 and 12.2.2 releases. As a private package, it is not intended to be called directly by external integrators; instead it supplies reusable copy and delete routines used when rule set definitions must be duplicated or removed.

Key Procedures and Functions

ETRM documents two public procedures exposed by this package body:

• COPYOBJECTDEFINITION — Creates the detail records of a new (target) Rule Set Definition by copying the detail records of an existing (source) Rule Set Definition. It is the principal mechanism for cloning a rule set definition, including its associated members, so that a new definition inherits the full structure of the original. Its signature accepts a source object definition identifier, a target object definition identifier, an optional FND user identifier, and an optional creation date, allowing the caller to preserve authorship and audit information during the copy.
• DELETEOBJECTDEFINITION — Removes the detail records associated with a Rule Set Definition identified by its object definition identifier. It provides the inverse lifecycle operation, cleaning up both the definition header relationships and its dependent member rows.

The body also declares private helper specifications that support these public routines, including copy routines for the rule set record and its member records, and corresponding delete routines for the same structures. These private procedures are not part of the documented external surface but encapsulate the granular insert and delete logic applied during copy and delete operations.

Tables Accessed

The package operates against two documented tables, accessed through APPS synonyms:

• FEM_RULE_SETS — Stores the rule set definition header/record data. Copy operations read source rows and insert corresponding target rows; delete operations remove the rows for the specified object definition.
• FEM_RULE_SET_MEMBERS — Stores the member or detail rows that belong to each rule set definition. The copy and delete routines manage these dependent rows in step with their parent definition, maintaining referential consistency.

Usage Notes

Because FEM_BR_RULE_SET_PVT is classified as a private API, it is invoked internally by the EPCM application rather than by customer code. Typical call sites include the EPCM rule set setup forms and the higher-level public APIs that create, duplicate, or purge rule set definitions, particularly when a user performs a "copy rule set" action or when administrative cleanup of obsolete definitions is required. ETRM records zero packages referencing this package directly, confirming its role as a leaf-level implementation unit.

Custom integrations requiring rule set duplication or deletion in EBS 12.1.1/12.2.2 should use the supported public EPCM APIs rather than calling this private package, since its interface is subject to change without notice.