Search Results verify_notification

Overview

OZF_QUOTA_THRESHOLD_PVT is a private (PVT) PL/SQL package owned by APPS in Oracle E-Business Suite, belonging to the Oracle Trade Management (OZF) module covering quotas, budgets, thresholds, and alerts. The package is designed to validate quota thresholds corresponding to budgets and to write results into the activity log table for notification purposes. Its stated purpose is to evaluate all enabled quota threshold rules, detect violations, send the appropriate notifications, and set alert flags for dashboard reporting. The package was originally created by Padmavathi Karthikeyan, with the header file dating to 2003 (ozfvqtrs.pls, version 115.1, noship). It is classified as a private API, meaning it is intended for internal use by the application rather than as a public integration interface.

Key Procedures and Functions

The package exposes four documented procedures:

• VALIDATE_QUOTA_THRESHOLD — The main entry point invoked when the associated concurrent program runs. It iterates over all enabled quota threshold rules, checks each for violations, and issues notifications accordingly. It also sets alert flags consumed by dashboard components. It returns the standard concurrent program OUT parameters for error buffer and return code.
• OPERATION_RESULT — The procedure referenced in the user's search for "operation_result." It is documented as a private API accepting a standard API version number, an initialization message list flag, and left-hand-side and right-hand-side numeric inputs. Its role is to evaluate and record the outcome of a quota threshold comparison operation.
• VERIFY_NOTIFICATION — Handles verification of notification logic, determining whether a notification should be raised in response to a threshold evaluation.
• UPDATE_ALERTS — Updates alert records and flags, supporting the dashboard-facing alert indicators produced during threshold validation.

Tables Accessed

The package reads and writes a broad set of tables through APPS synonyms, reflecting its dual role of threshold evaluation and notification:

• OZF_THRESHOLDS_ALL_B and OZF_THRESHOLD_RULES_ALL — the threshold and rule definitions evaluated for violations.
• OZF_QUOTA_ALERTS and OZF_QUOTA_ALERTS_S — alert records created or updated when thresholds are breached.
• AMS_ACT_LOGS, AMS_ACT_LOGS_S, and AMS_ACT_LOGS_TRANSACTION_ID_S — activity log tables used to write notification content.
• OZF_ACCOUNT_ALLOCATIONS and OZF_PRODUCT_ALLOCATIONS — allocation data used to associate quotas with accounts and products.
• OZF_CUST_DAILY_FACTS and OZF_DASHB_DAILY_KPI — fact and KPI tables supporting dashboard alert flags.
• OZF_FUNDS_ALL_B — funds and budget data against which quota thresholds are validated.
• DUAL, DBMS_SQL, and PLITBLM — utility objects used for dynamic SQL and PL/SQL table handling.

Usage Notes

As a private package, OZF_QUOTA_THRESHOLD_PVT is not intended for direct external calls. It is normally invoked through the concurrent program that drives quota threshold validation, executed on a scheduled basis to detect breaches and trigger notifications. Custom code should avoid calling its private procedures directly; instead, use supported public APIs where available. The package is referenced by one other package, confirming its internal dependency role. Behavior is consistent across Oracle EBS 12.1.1 and 12.2.2, with no online patching dependency changes affecting its PL/SQL interface.