Search Results csd_rules_engine_pvt_w

Overview

CSD_RULES_ENGINE_PVT_W is the public wrapper package for the Oracle E-Business Suite rules engine used by the Service (CSD) schema, governing how the Order Management and service fulfillment modules evaluate configured business rules. In the context of Oracle EBS 12.1.1 and 12.2.2, this package belongs to the APPS-owned CSD_RULES_ENGINE_PVT family, which performs condition matching and defaulting for Service Order/Order Orchestration (SOO) processing. The "_W" suffix indicates a wrapper whose primary responsibility is to bridge PL/SQL record/collection types used internally by the rules engine with the scalar JTF_*_TABLE collection types required for interfacing with forms, OAF pages, and other callers. The package is declared AUTHID CURRENT_USER and is classified as API classification OTHER in ETRM. It exposes 13 documented procedures/functions, and the source header shows a revision from 2013 (120.1.12020000.5).

Key Procedures and Functions

• ROSETTA_TABLE_COPY_IN_P40 / ROSETTA_TABLE_COPY_OUT_P40 — Conversion routines that map between JTF_NUMBER_TABLE and JTF_VARCHAR2_TABLE collections and the CSD_RULES_ENGINE_PVT.CSD_RULE_CONDITION_TBL_TYPE structure. The "_IN" variant assembles a rule-condition table from parallel JTF arrays; the "_OUT" variant decomposes it back into those arrays for callers.
• ROSETTA_TABLE_COPY_IN_P43 / ROSETTA_TABLE_COPY_OUT_P43 — Parallel conversion routines for CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_TBL_TYPE, handling the rule results collection (number and varchar columns such as rule identifiers, condition, and value arrays).
• PROCESS_SOO_RULE — The central entry point for evaluating an SOO rule. It is the procedure most commonly searched for ("process_soo_rule") and drives rule matching and result generation for a given rule input.
• SOO_DEFAULTING — Performs defaulting logic for Service Order/Order Orchestration attributes by applying configured rules.
• GET_DEFAULT_VALUE_FROM_RULE and GET_DEFAULT_VALUE — Retrieve the default value produced by a rule, supporting the defaulting flow.
• MATCH_CONDITION — Evaluates whether a given condition matches the rule input record.
• COPY_RULE_INPUT_REC_VALUES and POPULATE_RULE_INPUT_REC — Populate and copy the rule input record structure used as the context for rule evaluation.

Tables Accessed

Per the documented ETRM metadata, the package references the table PLITBLM (via an APPS synonym). PLITBLM is the standard EBS temporary/staging structure used by forms and PL/SQL interfaces to hold tabular data, consistent with the package's role of moving condition and result collections in and out of the engine. No other base tables are documented for this wrapper; the substantive rule and condition definitions reside in the related CSD rules engine packages and CSD schema tables that this wrapper delegates to.

Usage Notes

CSD_RULES_ENGINE_PVT_W is normally invoked indirectly rather than directly by end users. It is called from Service/Order Management forms and OAF pages, from Service Order Orchestration processing, and from concurrent programs that trigger rule evaluation and defaulting. The Rosetta copy procedures exist specifically because callers pass data as JTF collection types, so any custom code that needs to invoke PROCESS_SOO_RULE, SOO_DEFAULTING, or the default-value functions must first marshal inputs through the appropriate ROSETTA_TABLE_COPY_IN routine and read results back via the corresponding _OUT routine. Because the package is AUTHID CURRENT_USER and owned by APPS, execute privileges are normally granted through the APPS schema; customizations should call the wrapper rather than the underlying engine to remain upgrade-safe across 12.1.1 and 12.2.2.