Search Results get_gsa_indicator




Overview

QP_DEFAULT_MODIFIER_LIST is an Oracle Advanced Pricing (QP) package body owned by APPS that implements the QP_Modifiers_PUB modifier-list API contract for a special-purpose, non-persistent modifier list. Rather than storing pricing adjustments, this package returns fixed sentinel values that signal the absence of a full modifier definition. Its members return constants or NULL for most attributes, while Get_Currency resolves a real currency code from the ledger. It therefore serves as a lightweight default implementation used by calling programs that require a conforming modifier-list interface without an actual database-backed list.

The package is classified as OTHER in the documented API metadata for EBS 12.2.2 and is referenced by one other package, indicating a narrow, internal role in the pricing call stack rather than a broadly published integration point.

Key Procedures and Functions

The ETRM metadata records a single documented procedure or function, ATTRIBUTES, which supplies the attribute set for the modifier-list structure consumed by the QP_Modifiers_PUB.Modifier_List_Rec_Type record. The source header additionally exposes the getter family that populates that structure. Name and purpose only are described below; no parameter lists are inferred.

  • Get_Automatic — returns a fixed indicator ('N') stating that the modifier is not applied automatically.
  • Get_Comments — returns NULL for the comments attribute.
  • Get_Currency — resolves and returns the functional currency code. It reads the operating unit from QP_UTIL.get_org_id, and when the org is populated calls oe_sys_parameters.value('SET_OF_BOOKS_ID', l_org_id) to obtain the set of books, then selects CURRENCY_CODE from GL_SETS_OF_BOOKS. Multi-org access control (MOAC) behavior is handled by invoking this logic only when org_id is not null; NO_DATA_FOUND returns NULL, and other errors raise FND_API.G_EXC_UNEXPECTED_ERROR after optional debug/error logging.
  • Get_Discount_Lines — returns NULL, indicating no discount line detail.
  • Get_End_Date_Active — returns the active end date for the default list.

The user search term get_gsa_indicator does not appear among the documented members above; the metadata provided does not identify a GSA indicator function in this package. If a GSA (General Services Administration) indicator is required, it would be obtained from the broader QP_Modifiers_PUB modifier definition rather than from this default stub.

Tables Accessed

The documented table references are QP_LIST_HEADERS_B_S and DUAL. QP_LIST_HEADERS_B_S is the base table/sequence view for pricing list headers, consulted as part of the modifier-list attribute population. DUAL supports the scalar getters that return literal constants without touching persistent data. GL_SETS_OF_BOOKS is also queried by Get_Currency for the ledger currency code, as shown in the source excerpt.

Usage Notes

QP_DEFAULT_MODIFIER_LIST is invoked programmatically, not through a dedicated form or concurrent program, whenever an Advanced Pricing routine needs a modifier list conforming to QP_Modifiers_PUB semantics but no stored list applies — for example, during price list or adjustment processing that requires a default placeholder object. Custom code should not rely on it for real pricing data, since most getters intentionally return NULL or fixed values. Because Get_Currency depends on MOAC organization context and oe_sys_parameters, callers must ensure the correct operating unit is initialized. Errors are surfaced as FND_API.G_EXC_UNEXPECTED_ERROR, so calling code should include standard FND exception handling.