Search Results check_content_rule

Overview

APPS.AMS_CT_RULE_PVT is a private PL/SQL package body in the Oracle E-Business Suite Marketing (AMS) module. It governs the creation, maintenance, and validation of content rules used by Oracle Marketing's content targeting and fulfillment engine. Content rules determine how marketing content is selected, matched, and delivered to recipients based on source codes, order context, and fulfillment requests. Because the package name carries the PVT suffix, it is an internal implementation package that encapsulates the business logic behind a corresponding public API surface; callers generally reach this logic through the public wrapper rather than invoking the private body directly. The object resides in the APPS schema and is documented as VALID in ETRM 12.2.2.

Key Procedures and Functions

The documented package exposes eight procedures and functions. CREATE_CT_RULE inserts a new content rule definition, populating the base table and its translation-enabled views. UPDATE_CT_RULE modifies an existing rule's attributes, while DELETE_CT_RULE removes a rule and its associated records. LOCK_CT_RULE obtains a concurrency lock on a rule row, protecting it from simultaneous modification and supporting the standard EBS optimistic locking pattern. VALIDATE_CT_RULE performs validation of the complete rule definition, and VALIDATE_CT_RULE_REC validates an individual rule record passed from a calling layer. CHECK_CT_RULE_ITEMS verifies the constituent items or components that make up a content rule, ensuring referential and logical consistency. CHECK_CONTENT_RULE provides a broader eligibility or applicability check used at runtime to determine whether a rule applies to a given content scenario. Together these routines form a complete lifecycle API: create, update, delete, lock, and validate.

Tables Accessed

The package operates primarily on AMS_CONTENT_RULES_B, the base table storing content rule definitions, and AMS_CONTENT_RULES_B_S, its sequence-backed identifier source. AMS_CONTENT_RULES_VL is referenced as the translation-enabled view used to present and manipulate localized rule data. AMS_SOURCE_CODES is consulted to validate and resolve source code values associated with rules. DUAL and the PLITBLM package are used for standard expression evaluation and PL/SQL table manipulation. The package depends on AMS_CONTENT_RULES_B_PKG for lower-level row handling, and it references AMS_UTILITY_PVT for shared marketing utilities.

Usage Notes

AMS_CT_RULE_PVT is invoked indirectly through the Oracle Marketing content management forms and through fulfillment and order integration flows. Its dependencies on ASO_ORDER_INT, JTF_FULFILLMENT_PUB, JTF_FM_REQUEST_GRP, and JTF_FM_OCM_REQUEST_GRP indicate that content rules are evaluated during order capture and fulfillment messaging, where rules drive message rendering and request grouping. It also relies on FND_API, FND_MSG_PUB, FND_GLOBAL, and FND_MESSAGE for the standard EBS API error-handling, message-stack, and environment conventions. Because it is a PVT body and is not referenced by any other database object, customizations should call the corresponding public API rather than this body. Any direct custom invocation should preserve the FND_API savepoint and message-stack discipline to remain upgrade-safe.