Search Results c_enteredformula

Overview

APPS.AR_ARXINVAD_XMLP_PKG is the generated PL/SQL package that backs the Oracle Receivables Invoice Audit report, produced through the Oracle Reports XML Publisher (XMLP) engine. Its source header identifies the file as ARXINVADS.pls (revision 120.0, dated 2007/12/27). The package implements the report-level logic that a Reports trigger would otherwise perform: it resolves report parameters, establishes session context, retrieves base currency and accounting data, and supplies formatted values to the report layout. Its central concern, reflected in the variable C_report_type, is classifying invoices into categories such as entered, not entered, deleted, and newly created records, and presenting the correct header, currency precision, and NLS strings for the requested report variant. The package is owned by APPS and, in ETRM 12.2.2, is classified as an OTHER API, meaning it is internal to the report and not a published integration interface.

Key Procedures and Functions

The documented interface contains twenty-three procedures and functions. The report lifecycle functions BeforeReport and AfterReport bracket execution; BeforeReport orchestrates the data-population calls, while AfterReport performs any post-print cleanup.

• GET_REPORT_TYPE — resolves the report variant the user requested and populates C_report_type, the value most directly associated with the user search term c_report_type.
• GET_COVER_PAGE_VALUES and GET_COMPANY_NAME — obtain the legal entity and cover-page header information printed at the top of the audit output.
• GET_NLS_STRINGS — loads translated message text, including C_NLS_NO_DATA_EXISTS, for the runtime language.
• GET_BASE_CURR_DATA — retrieves base currency code, precision, minimum accounting unit, and description for the ledger.
• C_ENTEREDFORMULA, C_NOT_ENTEREDFORMULA, C_DELETEDFORMULA, and C_NEW_RECORDSFORMULA — group formulas that aggregate or classify document sequence values for each audit section.
• The remaining _P functions — C_LAST_VALUE_P, C_BASE_CURRENCY_CODE_P, C_BASE_PRECISION_P, C_BASE_MIN_ACCT_UNIT_P, C_BASE_DESCRIPTION_P, C_COMPANY_NAME_HEADER_P, C_REPORT_START_DATE_P, C_NLS_NO_DATA_EXISTS_P, C_CHART_OF_ACCOUNTS_ID_P, C_sequence_name_p, C_sequence_method_p, and C_report_type_p — are accessors that expose package-level state to the report layout.

Tables Accessed

The package reads five APPS-synonymed tables. AR_SYSTEM_PARAMETERS supplies Receivables system options and the base currency context. FND_CURRENCIES provides currency precision and description, supporting C_BASE_PRECISION and C_BASE_MIN_ACCT_UNIT. FND_DOCUMENT_SEQUENCES supplies sequence name, method, and the from/to numbering ranges used to classify entered, not entered, deleted, and new records. FND_NEW_MESSAGES furnishes the translatable message text behind the NLS variables. RA_CUSTOMER_TRX is the primary transaction source, providing the invoice and credit memo rows audited by the report and the basis for the chart of accounts and company name values. No insert, update, or delete activity is documented; the package is a read-only reporting component.

Usage Notes

AR_ARXINVAD_XMLP_PKG is invoked implicitly by the Receivables Invoice Audit concurrent program when Oracle Reports executes the ARXINVAD report. Oracle Reports generates the package and binds it to the report definition, so the BeforeReport and AfterReport functions fire automatically at the appropriate trigger points, and the group formulas execute as the data model is processed. The package is not designed to be called directly from forms, workflow, or custom PL/SQL. Because ETRM classifies it as OTHER and reports zero referencing packages, customers should treat it as an internal implementation object: modifications would be overwritten by patching, and integrations should instead use supported Receivables APIs or the underlying tables. The C_report_type value is meaningful only within a report run, and custom development requiring the same classification logic should replicate the query against FND_DOCUMENT_SEQUENCES rather than calling these accessors.