Search Results inv_orgncp

Overview

GMF_CMRCWA_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema, classified under the ETRM as "OTHER." The package is a report logic container associated with an Oracle Reports (XML Publisher/XMLP) concurrent program in the Process Manufacturing (GMF) product family. Its naming convention, the "_XMLP_PKG" suffix, identifies it as the generated PL/SQL library that is bound to an Oracle Reports executable, providing report-level filter functions and before/after formatting hooks. The business function it serves is the retrieval and conditional filtering of cost organization and inventory organization data used in a cost management comparison or workbench-style report. Its principal role is to determine, at report runtime, which organizational filter clause should be applied to the report query based on the user's Sort By selection and the From/To organization parameters supplied at submission time.

Key Procedures and Functions

The package exposes twelve documented program units. The filter-predicate functions determine which grouping mode is active:

• G_COST_ORGANIZATIONGROUPFILTER — Returns TRUE when the report Sort By value equals 'Cost Organization', activating the cost organization grouping in the report layout.
• G_INV_ORGANIZATIONGROUPFILTER — Returns TRUE when Sort By equals 'Inventory Organization', activating the inventory organization grouping.

The formula functions build and return the dynamic SQL WHERE fragments applied to the report query:

• COST_ORGNCFFORMULA — Constructs the organization_code range predicate for the cost organization query, handling the four combinations of null and non-null FROM_COST_ORGN and TO_COST_ORGN values. When both are null it substitutes the literal predicate "and 1=1"; where a bound is missing it substitutes the SY_ALL sentinel into the corresponding display variable (FROM_COST_ORGN_P or TO_COST_ORGN_P) rather than assigning it to the query bind variable, a change introduced under Bug14095673.
• COST_ORGNCPFORMULA — Companion formula placeholder returned as an empty string, included for the Reports formula-column scaffolding.
• INV_ORGNCFFORMULA and INV_ORGNCPFORMULA — The equivalent range-predicate and placeholder functions for the inventory organization side of the report.
• COST_ORGNCP_P and INV_ORGNCP_P — Placeholder program units supporting the cost and inventory organization filter columns.

Report lifecycle hooks complete the package: BEFOREREPORT, AFTERREPORT, and AFTERPFORM supply the standard before-report, after-report, and after-parameter-form initialization logic, while GMF_CMRCWA_XMLP_PKG_HEADER defines the package header section.

Tables Accessed

The ETRM metadata for this object lists no directly referenced tables or APPS synonyms. This is consistent with a report logic package: the SQL statements themselves reside in the associated Oracle Reports query definition, and the package only supplies predicate strings and boolean grouping flags. The referenced columns visible in the source — cmp.organization_code, FROM_COST_ORGN, TO_COST_ORGN, and SORT_BY — are bound to the report's own data model rather than to tables the package queries directly. Any organization master data (for example, cost organization and inventory organization records) is retrieved by the report query through the standard EBS organization views, not by this package.

Usage Notes

This package is invoked indirectly by the Oracle Reports runtime for the associated GMF cost management concurrent program. It is not intended for direct invocation from forms, custom PL/SQL, or other packages; the ETRM metadata records zero dependent packages. The SY_ALL value — the search term associated with this object — is a report parameter sentinel meaning "all organizations." It is set into the display variables FROM_COST_ORGN_P and TO_COST_ORGN_P when a user leaves one or both organization bounds blank, so the report can render the full range label without corrupting the bind variables used in the where clause. The commented-out lines surrounding Bug14095673 document a prior approach that overwrote FROM_COST_ORGN and TO_COST_ORGN with SY_ALL; that behavior was replaced by assignment to the parallel _P display variables. The package is version-controlled as CMRCWAB.pls, with the current header at 120.0.12020000.2 (2012/08/29), indicating it is certified for both the 12.1.1 and 12.2.2 code lines.