Search Results delete_rule_crit_param




Overview
Explore in AI Chat

Overview

APPS.FUN_RULE_CRIT_PARAMS_PUB is a public PL/SQL API package that belongs to the Oracle E-Business Suite Financials (FUN) module, specifically the Transaction Management / rule-based accounting engine (ETRM). Its purpose is to provide a controlled, programmatic interface for creating, maintaining, retrieving and deleting the criteria parameters that are associated with accounting rules. Because rules in ETRM are frequently applied conditionally, each rule is defined by one or more criteria parameters, and this package encapsulates the procedural logic required to manage those parameter records safely. It is classified as a PUB (public) API, indicating that it is intended for invocation by external callers such as forms, concurrent programs and custom extensions.

The body begins with a header comment dating to 2006 (version 120.1) and declares a set of private helper procedures that are wrapped by the public API. The internal design uses an NOCOPY parameter convention for the record structure and return status, which is consistent with the standard EBS API coding pattern for performance and transactional control.

Key Procedures and Functions

The documented interface exposes five public operations:

  • CREATE_RULE_CRIT_PARAM — Creates a single rule criteria parameter record. Internally it delegates to the private helper do_create_rule_crit_param, which validates the record via FUN_RULE_VALIDATE_PKG.validate_rule_criteria_params before performing the insert.
  • CREATE_DUP_RULE_CRIT_PARAMS — Duplicates the criteria parameters from a source rule object to a target rule object, supported internally by do_create_dup_rule_crit_param. This is used when rules are copied or cloned.
  • UPDATE_RULE_CRIT_PARAM — Modifies an existing criteria parameter, delegating to the private do_update_rule_crit_param and managing the object version number for optimistic locking.
  • GET_RULE_CRIT_PARAM_REC — Retrieves a criteria parameter record for a given rule, returning the entity into a record structure.
  • DELETE_RULE_CRIT_PARAM — Removes a criteria parameter record. This is the operation most directly associated with the search term delete_rule_crit_param.

Tables Accessed

The package reads and writes three documented tables through APPS synonyms:

  • FUN_RULE_CRIT_PARAMS_B — The base table holding criteria parameter definitions, including the criteria parameter identifier and rule object linkage.
  • FUN_RULE_CRIT_PARAMS_TL — The translation table holding language-dependent descriptive attributes for each criteria parameter.
  • FUN_RULE_OBJECTS_B — The base table of rule objects, referenced to validate and resolve the rule object identifier associated with each criteria parameter.

Because the package maintains both the _B and _TL layers, a create or update typically writes to both, ensuring the multilingual descriptor is kept consistent with the base definition. The _B and _TL pair follows the standard EBS MLS (Multi-Lingual Support) design.

Usage Notes

FUN_RULE_CRIT_PARAMS_PUB is normally invoked by the ETRM rule setup forms and by concurrent programs that build or copy accounting rules across ledgers and organizations. It is also referenced by at least three other packages, indicating it forms part of the shared rule infrastructure rather than being an isolated utility. Custom code should call these public procedures rather than issuing direct DML against FUN_RULE_CRIT_PARAMS_B or FUN_RULE_CRIT_PARAMS_TL, since the package centralizes validation, return status handling and multi-table maintenance. Callers are expected to inspect x_return_status for errors and to handle fnd_api.g_exc_error appropriately, as the package follows the standard FND API error-handling protocol.