Search Results create_sla_extract




Overview
Explore in AI Chat

Overview

DPP_SLA_CLAIM_EXTRACT_PUB is a public PL/SQL package body owned by APPS that supports the Oracle E-Business Suite Trade Management and Channel Revenue Management product family. Its central business function is to extract claim-related accounting data and build Subledger Accounting (SLA) extract records for claims processed within the OZF and DPP claim schemas. The package bridges transactional claim data captured in the Channel Revenue Management claim tables with the Accounting Hub entities that the SLA engine ultimately consumes, ensuring that claim settlement and accrual activities generate valid, auditable journal entries. The header of the source file (dppsce.pls, version 120.6.12010000.2, dated 2008/11/11) confirms this package was shipped as part of the standard 12.1.1 and 12.2.2 code line. It participates in the broader DPP (Channel Revenue Management) transaction architecture and is classified as a PUB API, meaning it is intended for external invocation by other EBS modules and integration points rather than being a purely internal private package.

Key Procedures and Functions

One documented public procedure is exposed by this package: CREATE_SLA_EXTRACT. Its stated purpose, per the packaged comment block, is to create the SLA extract for a claim. It accepts API-versioning and error-handling conventions standard to Oracle's PL/SQL API framework — including an API version number, initialization message list flag, commit flag, validation level, and the standard OUT parameters for return status, message count, and message data. It also receives a claim identifier, a claim-line PL/SQL table of the type claim_line_tbl_type, and a user ID. Internally it instantiates claim record structures defined in OZF_CLAIM_PVT, resolves the transaction header and claim type, and orchestrates the population of the extract. As a public API, callers should rely on the documented parameter semantics and must not assume internal cursor names or private variables.

Tables Accessed

The package reads and writes through the following documented APPS synonyms:

  • OZF_CLAIMS — the master claim header table, supplying claim-level attributes (claim ID and claim type) required to drive the extract.
  • DPP_CUSTOMER_CLAIMS_ALL — customer-specific claim data used to align the extract with the correct trading partner.
  • DPP_TRANSACTION_CLAIMS_ALL — links claims to DPP transactions and holds the CLAIM_TYPE resolution value.
  • DPP_TRANSACTION_HEADERS_ALL — source of the transaction_header_id used to group extracted claim lines.
  • DPP_TRANSACTION_LINES_ALL — line-level transactional detail populating the extract.
  • DPP_XLA_HEADERS and DPP_XLA_LINES — the XLA staging structures that carry the extract rows forward into Subledger Accounting.
  • PLITBLM — the standard EBS PL/SQL index-by table used for message and error storage.

Usage Notes

CREATE_SLA_EXTRACT is typically invoked by the Channel Revenue Management claim processing flow, either from an Oracle Forms-based claim settlement action or from a concurrent program that batches claim accounting. Because it adheres to the FND_API standard signature, custom code may call it directly by initializing the message list, setting the commit flag appropriately, and supplying a populated claim_line_tbl_type collection. Callers must trap errors via x_return_status and FND_MSG_PUB, and should treat any non-success return as a failure to produce valid SLA data. The package is referenced by at least one other DPP package, and the same procedural name should not be confused with similarly named extract routines in sibling modules.