Search Results cp_order_by_p

Overview

AR_ARXNRREV_XMLP_PKG is a report-support package in the Oracle E-Business Suite Receivables (AR) module. It exists to provide the server-side PL/SQL logic required by the ARXNRREV XML Publisher report, a customer-facing document generally associated with Receivables reporting and revenue or transaction listings. In Oracle EBS, XML Publisher (BI Publisher) reports are driven by an RTF or XML template paired with a data definition, and the accompanying PL/SQL package supplies the report triggers, formula columns, and global variables that the template references at runtime. This package is owned by APPS and is classified as OTHER, meaning it is an internal, report-generated support object rather than a public application programming interface. It is not designed for direct invocation by external code.

Key Procedures and Functions

The package exposes ten documented program units. The report-definition functions perform report initialization and teardown, while the remaining functions are formula or parameter accessors referenced from the template.

• REPORT_NAMEFORMULA — Resolves the report title. It queries the concurrent program definition to derive the user-facing report name and strips the trailing " (XML)" suffix, storing the result in the global RP_REPORT_NAME. When no row is found, it falls back to the literal text "Title of the Report".
• BEFOREREPORT — The BeforeReport trigger. It captures the concurrent request ID into P_CONC_REQUEST_ID, retrieves the profile option RA_CUSTOMERS_SORT_BY_PHONETICS, and looks up the order-by meaning from AR_LOOKUPS.
• SUB_TITLEFORMULA — The formula associated with the search term "sub_titleformula". It returns a single space and assigns that space to RP_SUB_TITLE, effectively suppressing the report subtitle in the output layout.
• AFTERREPORT — The AfterReport trigger, which performs report teardown and returns TRUE.
• RP_COMPANY_NAME_P — Accessor returning the value of the RP_COMPANY_NAME global.
• RP_REPORT_NAME_P — Accessor returning the value of the RP_REPORT_NAME global.
• RP_DATA_FOUND_P — Accessor reporting whether data was returned by the query.
• RP_SUB_TITLE_P — Accessor returning the value of the RP_SUB_TITLE global established by SUB_TITLEFORMULA.
• CP_ORDER_BY_P — Accessor returning the CP_ORDER_BY global populated during BeforeReport.
• RP_SORT_BY_PHONETICS_P — Accessor returning the RA_CUSTOMERS_SORT_BY_PHONETICS profile value.

Tables Accessed

The package reads from FND_CONCURRENT_REQUESTS through an APPS synonym, joining it to FND_CONCURRENT_PROGRAMS_VL to resolve the concurrent program name from the request ID. It also queries AR_LOOKUPS for the lookup type ARXNRREV_ORDER_BY to translate the P_ORDER_BY parameter into a display meaning. No insert, update, or delete operations are documented, confirming the package is read-only.

Usage Notes

AR_ARXNRREV_XMLP_PKG is invoked exclusively by the Oracle Reports and XML Publisher runtime engine when the ARXNRREV concurrent program is executed. The BeforeReport and AfterReport functions are registered as report triggers, and the formula functions are called as the publishing engine renders each template field. The package is referenced by zero other packages, indicating no cross-module dependency. Customizations should avoid modifying this generated object directly, since patches and upgrades may regenerate it; extensions should instead be implemented through template-level logic or a separate custom package.