Search Results get_sob_details

Overview

APPS.AR_ARXFXGL_XMLP_PKG is the generated PL/SQL package body that backs the Oracle Receivables foreign exchange gain and loss report (short name ARXFXGL), an XML Publisher concurrent program delivered in Oracle E-Business Suite 12.1.1 and 12.2.2. The package implements the report's data logic and formula columns rather than the report layout itself. Its header comment ($Header: ARXFXGLB.pls 120.0 2007/12/27) indicates that the body was last revised in the R12 development cycle and has remained stable across the 12.1 and 12.2 releases.

The package's principal entry point is the report trigger function BeforeReport, which is invoked automatically by the Oracle Reports runtime (or the XML Publisher engine executing the underlying report definition) before the result set is fetched. BeforeReport orchestrates a fixed sequence of build procedures that derive the report's selection criteria, populate package-level global variables, and supply contextual values such as the ledger and report title to the layout. In this way the package enacts the business function of reporting realized and unrealized foreign exchange gains and losses on Receivables transactions and receipts, including rate-based allocation of receipt amounts across currencies.

Key Procedures and Functions

All documented program units fall into three groups: initialization, parameter builders, and report formula columns.

• BeforeReport — the report-level trigger that sequentially calls the builder procedures and returns TRUE to allow the report to execute.
• Build_Customer_Details, Build_Location_Details, Build_Rate_Type_Details, Build_Receipt_Date_Details, Build_Currency_Details — each inspects a corresponding report parameter and, when that parameter is populated, constructs a dynamic WHERE fragment and/or resolves descriptive values (for example, customer account number and party name from HZ_CUST_ACCOUNTS and HZ_PARTIES) used to filter and label the report output.
• Get_SOB_Details — retrieves set of books / ledger attributes required to interpret currency and conversion data.
• Get_Report_Name — resolves the report's display title for the layout. This is the unit users locate when searching for get_report_name; it is a private package-level function called only from BeforeReport.
• Formula columns — CF_GAIN_LOSS_ACTUALFO, ALLOCATED_AMOUNT_RATEFORMULA, SYS_CROSS_CURRENCYFORMULA, RATE_ALLOC_RECEIPT_AMT_BASEFOR, RATE_GAIN_LOSSFORMULA, ABSOLUTE_DIFFERENCEFORMULA, ACTUAL_GAINFORMULA, ACTUAL_RATE_LOSSFORMULA, RATE_GAINFORMULA, RATE_LOSSFORMULA, RATE_SYS_CURR_RATE_DFORMULA and ACTUAL_CROSS_CURR_RATE_DFORMUL — compute the gain/loss, cross-currency, and rate-allocation figures that appear in the report's columns.

Tables Accessed

The package body references six tables through APPS synonyms:

• FND_CURRENCIES — currency code and name validation for the currency builder and conversion formulas.
• GL_DAILY_CONVERSION_TYPES — rate type definitions used to drive exchange-rate selection.
• HZ_CUST_ACCOUNTS and HZ_PARTIES — customer account number and party name lookup performed by Build_Customer_Details.
• HZ_CUST_SITE_USES_ALL — site use details resolved by Build_Location_Details.
• FND_CONCURRENT_REQUESTS — concurrent request context, used to derive report-run information.

Usage Notes

This package is not a public API. It is generated for, and invoked exclusively by, the ARXFXGL report definition; the ETRM metadata records zero packages referencing it. The srw.message and SRW.USER_EXIT('FND SRWINIT') statements are commented out in the body, reflecting conversion from Oracle Reports to the XML Publisher layout while retaining the original PL/SQL package structure in 12.1.1 and 12.2.2.

Customizations should be treated with care: changing the builder or formula procedures alters report output for every run of the Foreign Exchange Gain/Loss report. Because the standard body is overwritten on patch application, any required changes are better implemented through a custom copy of the report definition or a wrapper concurrent program rather than direct modification of APPS.AR_ARXFXGL_XMLP_PKG.