Search Results c_flexpad_itemformula

Overview

APPS.BOM_CSTRDICR_XMLP_PKG is the packaged implementation of the Oracle Bills of Material "Costed Item Detail Report" (short name CSTRDICR), a discrete report delivered in Oracle E-Business Suite 12.1.1 and 12.2.2 that lists item cost details for items within a specified item and category range. The package body operates as the XML Publisher (BI Publisher) report logic container: it supplies the PL/SQL functions referenced from the report definition, performs pre-report setup, and computes derived display values used when the report layout is rendered. Its header comment identifies it as a non-shipped (noship) customization artifact dated 2007, meaning it is a customer-extensible copy of the seed report logic rather than the factory-shipped wrapper itself.

Key Procedures and Functions

• BEFOREREPORT — The Before Report trigger. It captures the concurrent request ID from FND_GLOBAL, resolves the enabled and frozen key flexfield structure number for the MSTK (Item) flexfield under application 401, assigns it to the L_ITEM_FLEX_NUM global, validates the P_VIEW_COST parameter, builds default WHERE fragments when the item and category range parameters are null, and initializes the numeric format mask from the quantity precision parameter via BOM_COMMON_XMLP_PKG.
• AFTERREPORT — The After Report trigger. It performs the corresponding report teardown and returns control to the concurrent manager; the legacy SRW exit calls are commented out in the converted XML Publisher version.
• DISP_CURRENCYFORMULA — A formatting function that wraps a saved currency code in parentheses for display in the report output.
• ORDER_FUNC — The function matched by the search term "order_func." It is a grouping/sort helper declared with item, category, and UOM inputs that returns a character value used by the report's Order By or group trigger to sequence and format item flexfield output. The excerpt truncates its body, so its internal logic is governed by the two companion flexfield formula functions below.
• C_FLEXPAD_ITEMFORMULA — A formula column that concatenates and pads the item flexfield segments for display, producing the formatted item identifier used on the report layout.
• C_FLEXPAD_CATFORMULA — A formula column performing the equivalent concatenation and padding for the item category flexfield, producing the formatted category identifier.
• AFTERPFORM — The After Parameter Form trigger, invoked after the report parameter window is populated and before the report executes; it is where parameter-dependent globals are finalized for use by the data model queries.

Tables Accessed

The package body reads FND_ID_FLEX_STRUCTURES through the APPS synonym during BEFOREREPORT. The query filters on application_id 401, id_flex_code 'MSTK', enabled_flag 'Y', and freeze_flex_definition_flag 'Y', and uses ROWNUM with an ORDER BY on id_flex_num to select a single active, frozen item key flexfield structure number. That structure number is stored in L_ITEM_FLEX_NUM and drives the segment padding applied by the item and category formula functions, ensuring the report formats flexfield segments consistently with the currently frozen item flexfield definition. No insert, update, or delete operations are performed; the package is strictly read-only against this reference table.

Usage Notes

This package executes solely within the context of the CSTRDICR concurrent program. The report definition references its trigger functions (BEFOREREPORT, AFTERPFORM, AFTERREPORT) and its formula columns (DISP_CURRENCYFORMULA, ORDER_FUNC, C_FLEXPAD_ITEMFORMULA, C_FLEXPAD_CATFORMULA), so it is never invoked directly from an Oracle Forms screen or by ad hoc application code. The ETRM metadata records no other packages referencing it, confirming that its callers are the report template and the concurrent manager. Because the artifact is client-extensible, sites that modify the layout or data model must keep the function signatures and the L_ITEM_FLEX_NUM and P_WHERE_ITEM/P_WHERE_CAT globals intact. The P_VIEW_COST parameter acts as an execution guard: any value other than 1 causes an application error and aborts the report run, so it must be supplied correctly by the concurrent program's parameter list.