Search Results lp_creation_date_to

Overview

The PL/SQL package body APPS.AR_ARBRRMLT_XMLP_PKG supports the Oracle Receivables multilingual remittance letter report, published through the Oracle Reports XML Publisher (XMLP) concurrent program infrastructure. It serves as the report's PL/SQL library, providing the anchor functions and formula columns consumed by the report layout. The package is classified under the ETRM "OTHER" API category, reflecting its role as internal report-support logic rather than a public application programming interface. Its principal responsibility is to resolve report parameters, derive runtime filter ranges, and expose formatted values for the printed output.

In the 12.1.1 and 12.2.2 releases, the report logic is anchored in the BEFOREREPORT function, which establishes a session context before the report query executes. It captures FND_GLOBAL.CONC_REQUEST_ID, transfers report parameters into package-level local variables (including the date parameters surfaced by the user's search, such as LP_CREATION_DATE_TO), and queries AR_SYSTEM_PARAMETERS to determine the active set of books.

Key Procedures and Functions

• BEFOREREPORT — The report's before-report trigger. It copies report parameters into local variables, populates the set of books identifier, and constructs dynamic range clauses.
• AFTERREPORT — The after-report trigger, used to finalize the report session.
• AFTERPFORM — A parameter-form trigger. The historical FND SRWINIT user exit call is disabled (NULL) in this version, indicating the report relies on the XMLP/CP framework rather than legacy SRW initialization.
• CF_CURRENT_DATEFORMULA — A formula column returning the current date for display.
• CF_BR_DATEFORMULA — A formula column producing a business-report date value.
• GET_COUNTRY_DESCRIPTION — Resolves a country's descriptive name, typically from a territory reference.
• CUSTOMER_ADDRESS_STRINGFORMULA — A formula column that assembles a formatted customer address string.
• C_OUR_STREET_P, C_OUR_ZIPCITY_P, C_OUR_SOB_NAME_P, C_LOCATION_P — Group functions returning the remitting organization's street address, ZIP/city line, set-of-books name, and location for the letter header.
• C_LISTNUM_P — A group function returning a list number for the letter.

Tables Accessed

AR_SYSTEM_PARAMETERS is the single documented table, queried via its APPS synonym in BEFOREREPORT to retrieve SET_OF_BOOKS_ID. From this the report establishes the ledger context used to select the correct organization address, set-of-books name, and remittance data. Customer, transaction, and party data referenced in the dynamic range clauses (party.party_name, cust.cust_account_id, trx_date) are supplied by the embedded report query rather than by package-level SQL.

Usage Notes

This package is invoked implicitly whenever the multilingual remittance letter concurrent program runs; it is not called directly by forms or custom code and is referenced by no other packages. The parameter-handling logic is significant for the search term "lp_creation_date_to": the package mirrors P_CREATION_DATE_TO into LP_CREATION_DATE_TO, and if either creation-date bound is null it is set equal to the other, producing the LP_CREATION_DATE_RANGE predicate "trx_date between ... and ...". If both bounds remain null, no date restriction is applied. Similar cross-population and range construction occur for drawee name and number. Because the package is ETRM-classified as OTHER and unsupported for direct invocation, customizations should modify the report definition rather than the package body.