Search Results dpp_bpel_createclaims




Overview
Explore in AI Chat

Overview

DPP_CLAIMS_PVT is a private PL/SQL package in the APPS schema that provides the core claims-processing logic for Oracle's Advanced Pricing and Trade Management (formerly Oracle Trade Management / OZF) functionality. In Oracle EBS 12.1.1 and 12.2.2, the package is invoked primarily by Business Process Execution Language (BPEL) integration flows that create and update trade claims. It acts as the internal implementation layer behind the public claims APIs, encapsulating validation, defaulting, and data persistence logic for both customer claims and transaction claims.

The package name follows Oracle's "PVT" (private) API classification convention, meaning it is not intended for direct customer invocation. Instead, it is consumed by wrapper programs within the same application, specifically DPP_BPEL_CREATECLAIMS and DPP_BPEL_UPDATECLAIM, which expose claims processing to external BPEL orchestration. The package also references FND_API, confirming that it adheres to the Oracle Application Object Library API standards for error handling and return-status propagation.

Key Procedures and Functions

The ETRM documentation identifies two procedures exposed by DPP_CLAIMS_PVT:

  • CREATE_CLAIMS — Creates claim records from inbound data. It is invoked by the DPP_BPEL_CREATECLAIMS package to persist new customer and transaction claims originating from BPEL workflows, applying defaults and validation before inserting into the underlying claims tables.
  • UPDATE_CLAIMS — Updates existing claim records. It is called by DPP_BPEL_UPDATECLAIM to modify claim attributes such as status, amounts, or line details in response to inbound updates.

Both procedures operate on captured claims data, using FND_API conventions for returning success or error status to the calling BPEL layer. Detailed parameter lists are not exposed by the prior-version metadata.

Tables Accessed

DPP_CLAIMS_PVT reads and writes the principal claims tables in the Trade Management data model, referenced through APPS synonyms:

The package also references DBMS_XMLQUERY, XMLTYPE, and PLITBLM, indicating that inbound or outbound claim payloads are handled in XML form and that PL/SQL tables are used for array processing.

Usage Notes

DPP_CLAIMS_PVT is an internal package and should not be called directly by customer extensions. It is invoked through two documented entry points: DPP_BPEL_CREATECLAIMS (create flows) and DPP_BPEL_UPDATECLAIM (update flows), both of which are BPEL-facing wrappers. In a typical EBS 12.1.1 or 12.2.2 deployment, BPEL processes call these wrappers during trade claim integration, and the wrappers delegate to DPP_CLAIMS_PVT.CREATE_CLAIMS or DPP_CLAIMS_PVT.UPDATE_CLAIMS.

Because the package uses private API conventions, any custom development requiring claim creation or update should target the supported public APIs or BPEL services rather than DPP_CLAIMS_PVT itself. The package's dependency on FND_API confirms that errors are raised and returned through standard EBS API message handling, so callers must inspect the returned status and message stack.