Search Results cf_invoice_amount2formula

Overview

APPS.AP_APXIIMPT_XMLP_PKG is a PL/SQL package in the Oracle E-Business Suite Payables (AP) module whose name identifies it as the supporting code unit for an XML Publisher (XMLP) report. The APXIIMPT component corresponds to the Payables Invoice Import process, exposed as a concurrent program that loads invoice data from the AP_INTERFACE tables into the live Payables tables. In Oracle EBS 12.1.1 and 12.2.2 the seed data reports delivered through XML Publisher are published with an accompanying package that supplies report parameters, lexical or bind values, formatting functions, and the before/after report triggers used by the XML Publisher engine and the concurrent manager. AP_APXIIMPT_XMLP_PKG occupies that role: it is the report logic shell for the Invoice Import XML report.

The package is owned by APPS and holds VALID status. ETRM documentation classifies it as API classification OTHER, meaning it is not part of the public, supported Payables open interface set; it is internal report infrastructure. The package body itself lists only SYS.STANDARD as a referenced dependency, and it is referenced only by itself, confirming that it is invoked indirectly through the report registration rather than by other application packages.

Key Procedures and Functions

The documented unit exposes 54 procedures and functions, of which the following are representative:

• BEFOREREPORT and AFTERREPORT — the XML Publisher execution hooks. BEFOREREPORT initializes report state and resolves the concurrent request context before data is fetched; AFTERREPORT performs cleanup and any post-processing once report output generation completes.
• CUSTOM_INIT — performs package-level initialization, typically populating global variables and NLS or profile-derived values used by the report formulas.
• GET_COVER_PAGE_VALUES — assembles the header/cover page information for the printed or PDF report.
• GET_NLS_STRINGS — retrieves translated strings so the report respects the session language.
• GET_BASE_CURR_DATA — returns base currency details used for amount conversion and display.
• GET_COMPANY_NAME, GET_OPERATING_UNIT, GET_FLEXDATA — resolve the legal entity, operating unit, and key flexfield descriptive data used in report headers.
• GET_BATCH_ID, GET_CURRENT_DIST_LINE_NUM, GET_PURGE_FLAG — return control values that drive report selection and line numbering.
• C_LINE_LEVELFORMULA, CF_SOURCE_NAMEFORMULA, CF_AUDIT_OUFORMULA, CF_REJECT_OUFORMULA, CF_INVOICE_AMOUNT2FORMULA, CF_INVOICE_AMOUNT3FORMULA, CF_IPV_ADJ_AMOUNTFORMULA, CF_TIPV_ADJ_AMOUNTFORMULA — XML Publisher formula columns that compute derived and conditional values (line-level attributes, source name resolution, audit and rejection operating units, and the multiple invoice and IPV/TIPV adjustment amount representations) at report runtime.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• AP_BATCHES and AP_BATCHES_S — the invoice batch and its translation table, used to report batch context for the import run.
• AP_INTERFACE_CONTROLS — the control row that governs the Invoice Import concurrent program, including the purge and batch parameters.
• AP_INVOICE_DISTRIBUTIONS — invoice distribution lines that the import creates or validates.
• AP_SYSTEM_PARAMETERS — Payables system options supplying defaults such as base currency and operating unit behavior.
• FND_CONCURRENT_REQUESTS — the concurrent request record, used to obtain the request ID, parameters, and session context for the report run.

Usage Notes

AP_APXIIMPT_XMLP_PKG is not called directly by customer code. It is invoked by the XML Publisher engine when the Payables Invoice Import XML report concurrent program is submitted, and by the concurrent manager through the report registration. Because it is classified OTHER and is referenced by no other package, it should be treated as internal, non-supported infrastructure: customizations that depend on it risk breakage on patching or upgrade between 12.1.1 and 12.2.2. Developers inspecting or extending Invoice Import reporting should reference the public Payables open interface APIs rather than this package.