Search Results c_listnum_p

Overview

APPS.AR_ARBRRMLT_XMLP_PKG is a generated PL/SQL package that supports the Oracle Receivables concurrent program ARBRRMLT (the Receivables "Billing and Receipts" style report commonly associated with the ARBRRMLT XML Publisher layout). Its primary business function is to hold the bind parameters, report-level state variables, and BI Publisher report trigger functions required by an XML Publisher (XMLP) report in Oracle E-Business Suite 12.1.1 and 12.2.2. Such packages are used by the concurrent program framework and the XML Publisher engine during report submission and execution.

The package contains no business application logic beyond what is needed to gather parameter values, compute derived display values, and pass rows to the XML Publisher layout. It references AR_SYSTEM_PARAMETERS to retrieve system-level accounting and reporting defaults.

Key Procedures and Functions

• BEFOREREPORT — Fires before the report body is generated; typically initializes report values and performs pre-query setup.
• AFTERREPORT — Fires after the report body has been produced; used for post-processing and cleanup.
• CF_CURRENT_DATEFORMULA — Returns the current date as a formatted character string for display in the report.
• CF_BR_DATEFORMULA — Accepts a date and returns it formatted as a character string, used to render date values in the report layout.
• AFTERPFORM — Runs after the parameter form is submitted; validates or transforms parameter values before report execution.
• GET_COUNTRY_DESCRIPTION — Returns the descriptive name of a country based on the supplied country code.
• CUSTOMER_ADDRESS_STRINGFORMULA — Concatenates customer name, address lines, city, state, postal code, and country into a single formatted address string.
• C_OUR_STREET_P — Accessor returning the report's "our street" value.
• C_OUR_ZIPCITY_P — Accessor returning the report's "our zip and city" value.
• C_LISTNUM_P — Accessor returning the value of the C_LISTNUM package variable, the parameter the user searched for. It is a NUMBER-typed report column value exposed to the XML layout.
• C_OUR_SOB_NAME_P — Accessor returning the set of books (SOB) name used in the report header.
• C_LOCATION_P — Accessor returning the report's location value.

Tables Accessed

The documented table reference is AR_SYSTEM_PARAMETERS, accessed via an APPS synonym. This table supplies set of books and system-level Receivables defaults, such as the default country, that feed package variables including P_DEFAULT_COUNTRY, P_SET_OF_BOOKS_ID, and the values returned by C_OUR_SOB_NAME_P and related accessors. No other tables are documented in the metadata.

Usage Notes

AP_ARBRRMLT_XMLP_PKG is invoked indirectly by the concurrent program manager when the associated XML Publisher report is submitted; the parameter form and report triggers call the functions listed above. It is not intended for direct invocation from custom code, although the C_*_P accessor functions may be referenced by the report's data template. Because it is a generated XMLP package, its contents are tied to the specific report definition and layout version installed on the instance.