Search Results ap_utilities_pkg
Overview
APPS.AP_UTILITIES_PKG is a shared utility package body in the Oracle Payables (AP) module of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. Its role is to centralize low-level, cross-cutting helper logic that other Payables packages, forms, and concurrent programs invoke rather than reimplement. Typical responsibilities include currency and tax rounding, ledger and accounting period derivation, exchange rate retrieval, key flexfield segment construction, code combination validation, profile option handling, and standardized message and window-title retrieval.
The package body depends on a broad set of database objects, including AP core tables (invoices, invoice lines, invoice distributions, holds, encumbrances, interface rejections), Oracle General Ledger and Financials setup tables, and several shared technology packages such as FND_API, FND_FLEX_APIS, FND_FLEX_KEYVAL, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, FND_FILE, and AP_DEBUG_PKG. It also references subledger accounting and multi-org utilities, reflecting its function as an integration point across the Payables and Financials stack. Documented metadata classifies the package under API classification OTHER, and it is referenced by 108 other packages, indicating very wide reuse across the application.
Key Procedures and Functions
The package exposes 50 documented procedures and functions. The principal groups are:
- Currency and tax rounding: AP_ROUND_CURRENCY, AP_ROUND_TAX, AP_ROUND_NON_REC_TAX, and AP_ROUND_PRECISION apply consistent rounding rules to amounts, tax, and non-recoverable tax based on defined precision, ensuring invoice and distribution amounts reconcile.
- Accounting date and period derivation: GET_CURRENT_GL_DATE, GET_GL_PERIOD_NAME, GET_OPEN_GL_DATE, and GET_ONLY_OPEN_GL_DATE return valid GL dates and period names, respecting open and closed period status for a given ledger.
- Exchange rate and amount calculation: GET_EXCHANGE_RATE retrieves conversion rates for a currency pair and date; NET_INVOICE_AMOUNT derives the net invoice amount from its components.
- Key flexfield handling: OVERLAY_SEGMENTS and OVERLAY_SEGMENTS_BY_GLDATE build or overlay accounting flexfield segment strings, the latter keyed to an effective GL date; IS_CCID_VALID validates a code combination identifier; CHECK_PARTIAL performs partial key validation.
- Asset book and display logic: LEDGER_ASSET_BOOK relates a ledger to its asset book; AP_GET_DISPLAYED_FIELD resolves field display values.
- Profile, message, and UI helpers: SET_PROFILE, AP_GET_MESSAGE, GET_WINDOW_TITLE, and GET_WINDOW_SESSION_TITLE manage profile option values and standardized message or window caption retrieval for forms.
Parameter lists are not documented here and should not be assumed; callers should consult the package specification for exact signatures.
Tables Accessed
Through APPS synonyms the package reads and, in some cases, writes the following documented tables:
- Invoice data: AP_INVOICES, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_LINES, AP_INVOICE_LINES_ALL — the primary source for amounts, lines, and distributions requiring rounding, netting, and validation.
- Financials and ledger setup: GL_CODE_COMBINATIONS, GL_LEDGER_SEGMENT_VALUES, GL_PERIOD_STATUSES — used for CCID validation, segment overlay, and open-period determination.
- Currency and asset setup: FND_CURRENCIES and FA_BOOK_CONTROLS — supply currency precision and asset book linkage.
- Encumbrance and holds: AP_AE_HEADERS, AP_ENCUMBRANCE_LINES, AP_ENCUMBRANCE_LINES_ALL, AP_HOLDS_ALL — support encumbrance and hold processing logic.
- Interface processing: AP_INTERFACE_REJECTIONS — records rejected interface rows during invoice import.
Usage Notes
AP_UTILITIES_PKG is invoked indirectly by Payables forms, concurrent programs, and the invoice import and validation flow, and directly by custom extensions that require the same rounding, period, rate, or flexfield behavior as standard Payables processing. The presence of FND_FILE and FND_LOG dependencies indicates use in concurrent program output and debug logging. Because it is referenced by 108 packages, changes to its body carry wide impact and should be regression tested. The package does not appear in the ETRM metadata as being referenced by other objects in the dependency listing shown, but its heavy inbound reference count confirms its status as a foundational utility.
-
SYNONYM: APPS.GL_LEDGER_SEGMENT_VALUES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GL_LEDGER_SEGMENT_VALUES, status:VALID,
-
PACKAGE BODY: APPS.AP_UTILITIES_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_UTILITIES_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_UTILITIES_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_UTILITIES_PKG, status:VALID,
-
SYNONYM: APPS.AP_ENCUMBRANCE_LINES_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_ENCUMBRANCE_LINES_ALL, status:VALID,
-
SYNONYM: APPS.AP_ENCUMBRANCE_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_ENCUMBRANCE_LINES, status:VALID,
-
SYNONYM: APPS.AP_INVOICE_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICE_LINES, status:VALID,
-
SYNONYM: APPS.AP_INVOICE_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICE_LINES, status:VALID,
-
SYNONYM: APPS.AP_ENCUMBRANCE_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_ENCUMBRANCE_LINES, status:VALID,
-
SYNONYM: APPS.AP_ENCUMBRANCE_LINES_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_ENCUMBRANCE_LINES_ALL, status:VALID,
-
PACKAGE: APPS.FND_PROFILE_OPTIONS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_PROFILE_OPTIONS_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_APXMTDTR_XMLP_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXMTDTR_XMLP_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_TRIAL_BALANCE_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_TRIAL_BALANCE_PKG, status:VALID,
-
PACKAGE: APPS.GL_EURO_USER_RATE_API
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GL_EURO_USER_RATE_API, status:VALID,
-
SYNONYM: APPS.AP_INVOICE_DISTS_ARCH
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICE_DISTS_ARCH, status:VALID,
-
PACKAGE: APPS.AP_IMPORT_UTILITIES_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AP_IMPORT_UTILITIES_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_PREPAY_UTILS_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PREPAY_UTILS_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_ETAX_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_ETAX_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_APXMTDTR_XMLP_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXMTDTR_XMLP_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_APXAPRVL_XMLP_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXAPRVL_XMLP_PKG, status:VALID,
-
PACKAGE: APPS.FV_CCR_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FV_CCR_GRP, status:VALID,
-
PACKAGE BODY: APPS.AP_APXCRRCR_XMLP_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXCRRCR_XMLP_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_PAYMENT_SCHEDULES_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PAYMENT_SCHEDULES_PKG, status:VALID,
-
SYNONYM: APPS.AP_AE_HEADERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_AE_HEADERS, status:VALID,
-
PACKAGE BODY: APPS.AP_APXINHIS_XMLP_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXINHIS_XMLP_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_TRIAL_BALANCE_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_TRIAL_BALANCE_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_APXINPSR_XMLP_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXINPSR_XMLP_PKG, status:VALID,
-
PACKAGE BODY: APPS.JGRX_WT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JGRX_WT, status:VALID,
-
PACKAGE BODY: APPS.AP_PPA_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PPA_PKG, status:VALID,
-
SYNONYM: APPS.AP_INTERFACE_REJECTIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_INTERFACE_REJECTIONS, status:VALID,
-
PACKAGE BODY: APPS.AP_R11_PREPAY_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_R11_PREPAY_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_APXKIRKI_XMLP_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXKIRKI_XMLP_PKG, status:VALID,
-
PACKAGE: APPS.FND_PROFILE_OPTIONS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_PROFILE_OPTIONS_PKG, status:VALID,
-
PACKAGE: APPS.GL_EURO_USER_RATE_API
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GL_EURO_USER_RATE_API, status:VALID,
-
PACKAGE: APPS.PA_ACC_GEN_WF_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_ACC_GEN_WF_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_CREATE_PAY_SCHEDS_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_CREATE_PAY_SCHEDS_PKG, status:VALID,
-
SYNONYM: APPS.AP_INTERFACE_REJECTIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_INTERFACE_REJECTIONS, status:VALID,
-
PACKAGE BODY: APPS.AP_PREPAY_UTILS_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PREPAY_UTILS_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_OPEN_ITEMS_REVAL_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_OPEN_ITEMS_REVAL_PKG, status:VALID,
-
PACKAGE: APPS.AP_IMPORT_UTILITIES_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AP_IMPORT_UTILITIES_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_PAY_INVOICE_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PAY_INVOICE_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_PAY_INVOICE_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PAY_INVOICE_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_APXKIRKI_XMLP_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXKIRKI_XMLP_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_RETRO_PRICING_UTIL_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_RETRO_PRICING_UTIL_PKG, status:VALID,
-
PACKAGE BODY: APPS.JL_CO_AP_WITHHOLDING_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_AP_WITHHOLDING_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_ACCTG_PREPAY_DIST_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_ACCTG_PREPAY_DIST_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_PAYMENT_SCHEDULES_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PAYMENT_SCHEDULES_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_APXINHIS_XMLP_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXINHIS_XMLP_PKG, status:VALID,
-
PACKAGE: APPS.FV_CCR_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FV_CCR_GRP, status:VALID,
-
PACKAGE: APPS.AP_DEBUG_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AP_DEBUG_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_RETAINAGE_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_RETAINAGE_PKG, status:VALID,