Search Results update_quota

Overview

IEC_QUOTAUPDATE_PVT is a private PL/SQL package in the Oracle E-Business Suite APPS schema that supports the Oracle Trade Management (formerly iMarketing) quota management functionality. Its specific responsibility is the maintenance of quota usage counters tracked against list headers and list subsets. In Trade Management, quotas represent allocated quantities or budgets that are consumed as transactions, campaigns, or list members are processed. The package provides the runtime logic that increments or recalculates the "used" portion of a quota and returns the resulting working quota balance to the calling layer. It is classified in the ETRM metadata as a PVT (private) API, meaning it is not intended as a public integration interface; it exists to be called by other server-side Trade Management components rather than by external applications or customer extensions. The package is defined with AUTHID CURRENT_USER and carries a header timestamp of 2004, indicating it is a long-standing internal component that has been carried forward into EBS 12.1.1 and 12.2.2 with minimal signature change.

Key Procedures and Functions

Four documented procedures are exposed in the package specification, all of which revolve around updating quota consumption:

• UPDATE_QUOTA_LIST — Updates the quota usage associated with a list header. It accepts the quantity of quota consumed and the list header identifier, and returns the working quota balance through an OUT parameter.
• UPDATE_QUOTA_SUBSET — Performs the equivalent operation at the list subset level, accepting the consumed quantity and a list subset identifier and returning the working quota balance.
• UPDATE_QUOTA (overload with OUT parameter) — A generalized entry point that takes an identifier, a type discriminator, and the consumed quantity, then returns the resulting working quota. The type parameter allows the caller to indicate whether the identifier refers to a header or a subset.
• UPDATE_QUOTA (overload without OUT parameter) — An overload of the same procedure that performs the update but does not return a working quota value, suitable for fire-and-forget invocations where the caller does not need the resulting balance.

The overloaded UPDATE_QUOTA signatures let callers work generically with either quota level while the two named procedures provide explicit, type-safe entry points for list headers and subsets respectively.

Tables Accessed

The package operates against three documented Trade Management tables referenced through APPS synonyms:

• IEC_G_LIST_RT_INFO — Stores runtime information for quota lists, including the current consumed and working quota values at the list header level.
• IEC_G_LIST_SUBSETS — Holds the definition of list subsets belonging to a list, providing the subset identifiers passed to UPDATE_QUOTA_SUBSET.
• IEC_G_SUBSET_RT_INFO — Stores runtime quota consumption data for individual subsets, parallel to the header-level runtime table.

The package reads and writes these runtime tables to keep header-level and subset-level quota consumption synchronized with the transactions being recorded.

Usage Notes

As a PVT-classified package, IEC_QUOTAUPDATE_PVT is not part of Oracle's public API surface and is not referenced by any other documented package in the ETRM metadata. It is typically invoked indirectly from Trade Management list and quota processing flows — for example, when list members are qualified, when campaign activities consume quota, or when concurrent processes rebuild quota balances. Customizations should avoid calling this package directly: its signatures and internal behavior are not guaranteed across patches or upgrades, and no public contract is published. Where customers require quota adjustments, the supported approach is to use the documented public APIs or the standard Trade Management user interface, leaving IEC_QUOTAUPDATE_PVT as an internal implementation detail of the quota engine in both 12.1.1 and 12.2.2.