Results for “ce_cexavtrx_xmlp_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.CE_CEXAVTRX_XMLP_PKG package body is the server-side PL/SQL implementation supporting the Oracle Cash Management "Available Transactions" XML Publisher (BI Publisher) report in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to supply the runtime data context, lookup translations, and dynamic SQL source-view selection required to render the Cash Management transaction inquiry report in a multi-currency, multi-organization environment.

The package is classified as OTHER in the ETRM repository and is owned by the APPS schema. It is generated in the standard Oracle Reports-to-XML Publisher migration pattern, where BEFOREREPORT and AFTERREPORT anchor report-level initialization and cleanup, and the remaining functions and package-level variables expose derived values to the report layout. All documented procedures are internal to the package and it is referenced by zero other packages, confirming its role as a dedicated report-support unit rather than a reusable API.

Key Procedures and Functions

The package exposes 71 documented procedures and functions. The most significant are:

• BEFOREREPORT – Executes before the report is displayed. It obtains the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, calls INIT_SECURITY, retrieves bank account, bank, and transaction-type descriptions through lookups, and assigns a value to P_SOURCE_VIEW based on P_TYPE. This is the documented parameter referenced by the search term p_source_view.
• AFTERREPORT – Performs post-report cleanup and returns BOOLEAN, consistent with XML Publisher report lifecycle hooks.
• G_TRANSACTION_TYPEGROUPFILTER – Supplies the transaction-type group filter used to restrict report rows.
• C_AMOUNTFORMULA, C_BANK_ACCOUNT_AMOUNTFORMULA, C_ACCOUNT_AMOUNTFORMULA – Formula columns that compute and format monetary amounts for the report payload.
• C_DATEFORMATFORMULA, C_ORDER_BYFORMULA – Return formatting and dynamic ordering expressions applied to the report result set.
• P_SHOW_VOID_PAYMENT_FLAGVALIDT, P_ORDER_BYVALIDTRIGGER – Validation routines invoked from report parameter triggers.
• C_BATCH_AMOUNT_P, C_BATCH_BANK_ACCOUNT_AMOUNT_P, C_THE_END_P – Helper functions for batch totals and end-of-report markers.
• C_BANK_ACCOUNT_NAME_P, C_BANK_ACCOUNT_NUM_P, C_BANK_NAME_P, C_BANK_BRANCH_NAME_P, C_BANK_CURRENCY_CODE_P, C_TRANSACTION_TYPE_P, C_RECEIPT_TRANSLATION_P – Return package-level variables populated during BEFOREREPORT for use by the layout.

Tables Accessed

The only table explicitly documented as referenced through APPS synonyms is FND_NEW_MESSAGES, used for message text type declarations and error messaging. The BEFOREREPORT source additionally queries the Cash Management views CE_LOOKUPS, CE_BANK_BRANCHES_V, and CE_BANK_ACCTS_GT_V to resolve lookup meanings and bank account attributes. The P_SOURCE_VIEW variable does not name a fixed table but instead selects one of the CE transaction views based on the user's P_TYPE selection: CE_200_TRANSACTIONS_V for payments, CE_222_TRANSACTIONS_V for receipts, CE_101_TRANSACTIONS_V for journal entry lines, CE_999_TRANSACTIONS_V for ROI lines, CE_185_TRANSACTIONS_V for XTR lines, CE_801_TRANSACTIONS_V for payrolls, and CE_AVAILABLE_TRANSACTIONS_V for AR/AP and the ALL option. This dynamic view selection allows a single XML Publisher report template to serve multiple transaction sources.

Usage Notes

The package is invoked exclusively through the Cash Management "Available Transactions" XML Publisher concurrent program. The report engine first calls BEFOREREPORT, which validates P_TYPE against the TRAN_ORG_TYPE lookup, resolves the bank account, and sets P_SOURCE_VIEW to the appropriate CE transaction view. It is not intended to be called directly from forms or custom code; because it is referenced by zero other packages and carries only internal procedures, customizations should be applied through supported report template extensions rather than direct modification of the package body.