Search Results ap_batches_s

Overview

APPS.AP_APXIIMPT_XMLP_PKG is a package body in the Oracle E-Business Suite Payables (AP) schema. It backs the XML Publisher (BI Publisher) concurrent program that reports on invoice import activity, commonly associated with the Payables Open Interface Import process. The package serves as the report logic container for the APXIIMPT report, assembling output data for invoices processed through the Payables open interface tables and their associated batches. Its stated API classification is OTHER, indicating it is not a public or formally published programmatic interface but rather an internal report-support package.

The package is registered as VALID in the APPS schema and, per the ETRM metadata, is not referenced by any other database object. It in turn references a substantial set of AP and common EBS objects, and depends on several other PL/SQL packages, including AP_IMPORT_INVOICES_PKG, AP_XML_INVOICE_INBOUND_PKG, MO_GLOBAL, and FND_MESSAGE. It also depends on SYS constructs such as DBMS_STANDARD, DUAL, and STANDARD.

Key Procedures and Functions

The ETRM metadata documents 54 procedures and functions, including the following named members:

BEFOREREPORT — The XML Publisher before-report trigger, initializing report session state and derived values prior to main query execution.
AFTERREPORT — The after-report trigger, performing cleanup and any post-processing once the report data set is generated.
CUSTOM_INIT — Custom initialization logic for report globals and dependent setup values.
GET_COVER_PAGE_VALUES — Retrieves the values displayed on the report cover page, typically company and parameter context.
GET_COMPANY_NAME — Resolves the operating unit or company name for report headings.
GET_BASE_CURR_DATA — Obtains base currency information, used to present amounts in the ledger's functional currency.
GET_NLS_STRINGS — Loads NLS-translated strings used in report labels.
GET_FLEXDATA — Retrieves key flexfield data (such as accounting flexfield context) for display.
GET_BATCH_ID — Resolves the invoice batch identifier referenced by the report.
GET_CURRENT_DIST_LINE_NUM — Tracks the current distribution line number during report row processing.
GET_OPERATING_UNIT and GET_PURGE_FLAG — Return the operating unit context and the purge flag controlling retention of imported interface data.
Formula functions — C_LINE_LEVELFORMULA, CF_SOURCE_NAMEFORMULA, CF_AUDIT_OUFORMULA, CF_REJECT_OUFORMULA, CF_INVOICE_AMOUNT2FORMULA, CF_INVOICE_AMOUNT3FORMULA, CF_IPV_ADJ_AMOUNTFORMULA, and CF_TIPV_ADJ_AMOUNTFORMULA, which supply computed or conditional values for XML Publisher report columns, including audit and reject operating unit resolution, source name mapping, and invoice and IPV adjustment amount presentation.

Tables Accessed

AP_BATCHES / AP_BATCHES_S — The invoice batch header and its translated/secure view, providing batch context for imported invoices. This is directly relevant to the user's search term ap_batches_s.
AP_INTERFACE_CONTROLS — Supplies control parameters governing the Payables open interface import.
AP_INVOICE_DISTRIBUTIONS — Provides invoice distribution lines reported at the line level.
AP_SYSTEM_PARAMETERS — Yields Payables system options used for report defaults and currency settings.
FND_CONCURRENT_REQUESTS — Supplies concurrent request context and request parameters.
Additionally referenced: AP_LOOKUP_CODES and FND_LOOKUPS for lookup validation, FND_CURRENCIES_VL for currency descriptions, GL_SETS_OF_BOOKS for ledger data, and DUAL.

Usage Notes

AP_APXIIMPT_XMLP_PKG is invoked in the context of the Payables invoice import XML Publisher concurrent program. It is not designed for direct invocation from forms or from custom code; its procedures are called by the XML Publisher report engine through the standard before-report and after-report triggers (BEFOREREPORT and AFTERREPORT) and through XML Publisher formula columns. The package reads initialization and context values through FND_GLOBAL and delegates import-specific logic to AP_IMPORT_INVOICES_PKG and AP_XML_INVOICE_INBOUND_PKG. No other database object references this package, confirming that it is a terminal report-support package rather than a shared API. Because it depends on AP_BATCHES_S, its behavior is tied to batch-level data, which is the association most relevant when diagnosing report output for imported invoice batches.

SEQUENCE: AP.AP_BATCHES_S 12.1.1
owner:AP, object_type:SEQUENCE, object_name:AP_BATCHES_S, status:VALID,
SYNONYM: APPS.AP_BATCHES_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_BATCHES_S, status:VALID,
SEQUENCE: AP.AP_BATCHES_S 12.2.2
owner:AP, object_type:SEQUENCE, object_name:AP_BATCHES_S, status:VALID,
SYNONYM: APPS.AP_BATCHES_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_BATCHES_S, status:VALID,
PACKAGE BODY: APPS.AP_APXIIMPT_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXIIMPT_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.AP_APXIIMPT_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_APXIIMPT_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.AP_AUTO_DM_CREATION_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_AUTO_DM_CREATION_PKG, status:VALID,
PACKAGE BODY: APPS.AP_RECURRING_INVOICES_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_RECURRING_INVOICES_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.PO_INVOICES_SV2 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_INVOICES_SV2, status:VALID,
PACKAGE BODY: APPS.PO_INVOICES_SV1 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_INVOICES_SV1, status:VALID,
PACKAGE BODY: APPS.AP_RETRO_PRICING_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_RETRO_PRICING_PKG, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.AP_RECURRING_INVOICES_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_RECURRING_INVOICES_PKG, status:VALID,
PACKAGE BODY: APPS.AP_PMT_CALLOUT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PMT_CALLOUT_PKG, status:VALID,
PACKAGE BODY: APPS.PO_INVOICES_SV1 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_INVOICES_SV1, status:VALID,
PACKAGE BODY: APPS.AP_PMT_CALLOUT_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_PMT_CALLOUT_PKG, status:VALID,
PACKAGE BODY: APPS.AP_AUTO_DM_CREATION_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_AUTO_DM_CREATION_PKG, status:VALID,
PACKAGE BODY: APPS.PO_INVOICES_SV2 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_INVOICES_SV2, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.AP_IMPORT_UTILITIES_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_IMPORT_UTILITIES_PKG, status:VALID,
PACKAGE BODY: APPS.AP_RETRO_PRICING_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_RETRO_PRICING_PKG, status:VALID,
PACKAGE BODY: APPS.AP_IMPORT_UTILITIES_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_IMPORT_UTILITIES_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_BATCHES_S 12.1.1
APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_BATCHES_S 12.1.1
APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_BATCHES_S 12.1.1
APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_BATCHES_S 12.2.2
APPS.PO_INVOICES_SV1 dependencies on AP_BATCHES_S 12.1.1
APPS.PO_INVOICES_SV2 dependencies on AP_BATCHES_S 12.1.1
APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_BATCHES_S 12.2.2
APPS.AP_PMT_CALLOUT_PKG dependencies on AP_BATCHES_S 12.1.1
APPS.AP_RETRO_PRICING_PKG dependencies on AP_BATCHES_S 12.1.1
APPS.PO_INVOICES_SV2 dependencies on AP_BATCHES_S 12.2.2
APPS.AP_APXIIMPT_XMLP_PKG dependencies on AP_BATCHES_S 12.2.2
APPS.AP_APXIIMPT_XMLP_PKG dependencies on AP_BATCHES_S 12.1.1
APPS.AP_RETRO_PRICING_PKG dependencies on AP_BATCHES_S 12.2.2
APPS.AP_PMT_CALLOUT_PKG dependencies on AP_BATCHES_S 12.2.2
APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_BATCHES_S 12.2.2
APPS.PO_INVOICES_SV1 dependencies on AP_BATCHES_S 12.2.2
PACKAGE BODY: APPS.AP_RETRO_PRICING_PKG 12.1.1
PACKAGE BODY: APPS.AP_RETRO_PRICING_PKG 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1