Search Results c_locn_flex_struct_p

Overview

APPS.FA_FASINSDR_XMLP_PKG is a report-support package generated by Oracle Reports for the Fixed Assets insurance distribution report identified by the source header FASINSDRS.pls. It belongs to the Fixed Assets (FA) module and carries an API classification of OTHER, indicating that it is not part of a formally published PL/SQL API and is intended solely to support the runtime behavior of its associated concurrent report. The package encapsulates the report's global parameters, its lexical and bind variables, its BeforeReport and AfterReport triggers, and a set of getter functions that expose derived report values to the XML Publisher rendering layer. Its principal business purpose is to select the insurance-related asset and book attributes, identify the distribution source book, resolve currency and precision information, and provide the location, category, and accounting flexfield structures and WHERE fragments required to constrain the report query.

Key Procedures and Functions

The documented callable units fall into three groups. The report lifecycle triggers are BEFORE_REPORT and AFTERREPORT, which execute the pre-query and post-query logic for the concurrent request. C_1FORMULA is the formula column function used by the report layout.

The remaining functions are accessors, each returning the value of a corresponding package variable: C_ACCT_FLEX_STRUCT_P, C_ACCT_FLEX_BAL_SEG_P, C_ACCT_FLEX_BAL_WHERE_P, C_CAT_FLEX_STRUCT_P, C_CAT_FLEX_SEG_P, C_WHERE_CAT_FLEX_P, C_LOCN_FLEX_STRUCT_P, C_LOC_FLEX_SEG_P, C_WHERE_LOCN_FLEX_P, C_SOB_NAME_P, C_BOOK_CLASS_P, C_BOOK_TYPE_CODE_P, C_DISTRIBUTION_SOURCE_BOOK_P, C_CURRENCY_CODE_P, C_PRECISION_P, C_NO_DATA_FOUND_P, and C_TODAYS_DATE_P. The user search term c_precision_p refers to the accessor for the c_precision package variable, declared as varchar2(1), which supplies the numeric precision setting used when formatting monetary output in the report. Each getter shields the underlying variable from direct reference and allows the report definition to bind values by name.

Tables Accessed

The package reads three tables through APPS synonyms. FA_BOOK_CONTROLS supplies book-level attributes, including the book class, book type code, distribution source book, and the accounting flexfield structure that the getters expose. FA_SYSTEM_CONTROLS supplies enterprise-level Fixed Assets settings required to drive report behavior. FND_CURRENCIES supplies currency definitions, supporting the C_CURRENCY_CODE_P accessor and precision handling. The package is documented as referencing no other packages.

Usage Notes

FA_FASINSDR_XMLP_PKG is invoked indirectly when the associated Fixed Assets insurance distribution concurrent program is submitted; the Oracle Reports runtime calls BeforeReport and AfterReport, and the layout calls the getter functions. It is not intended for direct invocation from forms or custom code, and because it is an OTHER-classified generated package, its signature is tied to the report definition and may change with report revisions. Customizations should therefore avoid calling these functions directly and instead rely on the supported concurrent program interface.