Search Results cf_acct_descformula

Overview

JA_JAINBBR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as a report-support package (API classification: OTHER). The name suffix _XMLP_PKG identifies it as the generated wrapper package for an Oracle XML Publisher (BI Publisher) concurrent report. The embedded program identifier JAINBBR corresponds to the Oracle Financials for India "Bank Book Report," a statutory and reconciliation report that presents banking activity derived from payables and receivables transactions. The package was introduced under header revision 120.1 (2007) and is present in both EBS 12.1.1 and 12.2.2.

The package operates as the PL/SQL execution layer behind the report: it declares the report's bind and lexical parameters, groups the SQL used to populate the XML data template, and exposes formula functions that the XML Publisher engine invokes as calculated columns. It declares AUTHID CURRENT_USER, so statements execute with the privileges of the invoking user against APPS synonyms rather than with definer's rights.

Key Procedures and Functions

• CF_CLOSING_BALANCEFORMULA — the formula referenced by the search term "cf_closing_balanceformula." It computes the closing book balance for a bank account for the reporting period, taking the closing balance, the opening balance, receipts, and payments as inputs. It is the terminal calculation in the report's balance roll-forward.
• CF_OPEN_BALANCEFORMULA — derives the opening balance from the opening debit (CF_OPEN_BAL_DRFORMULA) and opening credit (CF_OPEN_BAL_CRFORMULA) components, which are themselves separate formula functions.
• CF_BALANCEFORMULA — computes a period balance from the receipts and payments amounts supplied by the query.
• CF_ACCOUNT_CODEFORMULA and CF_ACCT_DESCFORMULA — resolve a numeric account code into its displayed account code string and concatenated description, using the flexfield segment data.
• CF_1FORMULA and CF_P_BOOKFORMULA — derive the remaining calculated columns, including the set-of-books label used on the report output.
• BEFOREREPORT and AFTERREPORT — standard XML Publisher report triggers. BEFOREREPORT initializes the lexical and bind parameters and validates the report request; AFTERREPORT performs cleanup after data retrieval.
• JA_IN_CAL_BAL — a shared India-localization helper that returns a balance for a supplied base date, balance type, and open/close indicator, used to obtain opening and closing amounts from the subledger tables.

Tables Accessed

The package reads, through APPS synonyms, the subledger and ledger tables that constitute the bank book: AP_CHECKS_ALL, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL, and AP_INVOICE_PAYMENTS_ALL for payment and invoice activity; AR_CASH_RECEIPTS_ALL and AR_CASH_RECEIPT_HISTORY_ALL for receipts; CE_BANK_ACCOUNTS and HZ_CUST_ACCOUNTS for bank and counterparty identification; GL_JE_HEADERS and GL_JE_LINES for journal-level amounts; and FND_ID_FLEX_SEGMENTS and FND_SEGMENT_ATTRIBUTE_VALUES for account code and description derivation. FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS are referenced to resolve the concurrent request context, including the request ID passed in as P_CONC_REQUEST_ID.

Usage Notes

The package is not a general-purpose API and is referenced by zero other packages. It is invoked only when the associated Bank Book Report concurrent program is submitted from the India Localization responsibility; BEFOREREPORT runs at program start, the formula functions are evaluated by the XML Publisher engine for each row of the data template, and AFTERREPORT runs on completion. The declared package-level variables—start and end dates in both DATE and lexical string form, bank account name and number, chart of accounts and org identifiers, book type, column value, bank account ID, trace switch, and concurrent request ID—correspond to the report's parameter window and define the data set returned. Custom code should not call these functions directly, since the formulas are generated report logic and are not published as supported APIs.