Search Results ozf_claim_pvt




Overview
Explore in AI Chat

Overview

The APPS.OZF_CLAIM_DEF_RULE_PVT package belongs to the Oracle E-Business Suite Trade Management (formerly Oracle Field Sales / Trade Management) module, specifically the Claims subsystem. Its name identifies it as a private (PVT) API package, meaning it is not intended as a public integration interface but rather as an internal utility layer used by other packages within the OZF schema. The package encapsulates the business logic governing Claim Definition Rules — the configurable rules that determine how trade promotion claims are validated, defaulted, and routed during claim entry and processing. By centralizing this logic in a private package, Oracle enables the claim-processing packages (such as OZF_CLAIM_PVT and OZF_SD_BATCH_PVT) to reuse consistent rule-evaluation behavior. The object is documented as VALID in the ETRM 12.2.2 catalog, confirming that it is a supported and active component of the 12.1.1 / 12.2.2 code line.

Key Procedures and Functions

The documented metadata lists a single program unit within this package:

  • GET_CLAM_DEF_RULE — Retrieves the applicable claim definition rule for a given claim context. The abbreviation "CLAM" reflects the internal naming convention Oracle uses for claim-related objects (complementing the public-facing "CLM" or "CLAIM" prefixes seen elsewhere in the module and mirrored by the search term ozf_claim_pvt). This procedure/function is the primary entry point into the package's rule-resolution logic and is invoked by upstream packages to obtain the rule definition that governs a specific claim transaction. No parameter list is documented in the ETRM metadata, so exact signature details should be verified directly against the package specification in the target instance.

Tables Accessed

Per the documented dependency information, the package references the following tables through APPS synonyms:

  • OZF_CLAIM_DEF_RULES — The core configuration table holding the definition rules themselves. GET_CLAM_DEF_RULE reads this table to resolve which rule applies to the claim context supplied by the caller.
  • OZF_SYS_PARAMETERS — The system parameter table for the Trade Management module. This is typically consulted to honour module-level settings (such as defaulting flags, processing modes, or rule-selection behaviour) that influence how the rule lookup is performed.

Dependency metadata also identifies OZF_CLAIM_PVT as a referenced package and records SYS.STANDARD as a standard dependency, which is expected for any PL/SQL unit compilable in an Oracle database. No direct INSERT, UPDATE, or DELETE activity is documented, suggesting the package's role is predominantly read-oriented rule resolution rather than maintenance of the rule data.

Usage Notes

Oriented as a private API, OZF_CLAIM_DEF_RULE_PVT is not designed to be called directly from forms, concurrent programs, or customer-written extensions. The ETRM dependency trace shows that it is referenced by three packages — itself (internal), OZF_CLAIM_PVT, and OZF_SD_BATCH_PVT — which confirms it is consumed as a subordinate utility within the OZF claim pipeline. Typical invocation occurs when a claim is created, validated, or batch-processed, at which point the calling package uses GET_CLAM_DEF_RULE to determine the governing definition rule before proceeding. Customizations should generally hook into the public layer (OZF_CLAIM_PVT) rather than this private package, because private APIs are subject to change without notice between point releases and are not covered by Oracle's public API support policy. Because GET_CLAM_DEF_RULE appears to be a lookup routine, its correctness depends on accurate and current configuration of OZF_CLAIM_DEF_RULES; administrators should verify that rule data is properly maintained whenever claim behaviour deviates from expectations.