Search Results organizationcp_p

Overview

GMF_CMR12USR_XMLP_PKG is an Oracle E-Business Suite package body owned by APPS and classified under the API classification OTHER. It is the runtime PL/SQL package generated to support an Oracle Reports (XML Publisher) concurrent program in the Process Manufacturing (GMF) module, specifically a cost management comparison report (the CMR12USR naming convention reflects a Cost Management Report). The package provides the report's parameter-level validation, before/after formatting hooks, SQL fragment builders, and lookup query functions that feed the report's data model. In Oracle EBS 12.1.1 and 12.2.2, such packages act as the bridge between the concurrent program definition and the underlying XML Publisher template, assembling bind parameters and dynamic WHERE clauses used by the report query.

Key Procedures and Functions

The package exposes fifteen documented program units. The four FORMULA functions—ITEMCFFORMULA, ITEMCPFORMULA, ORGANIZATIONCFFORMULA, and ORGANIZATIONCPFORMULA—construct dynamic SQL predicate fragments for item ranges and organization ranges. ORGANIZATIONCFFORMULA, referenced by the "to_org" search, evaluates FROM_ORG and TO_ORG and builds a clause against mtl.organization_code, defaulting missing bounds to SY_ALL. Additional formula functions include BASE_CURRCFFORMULA, PERIOD_IDFORMULA, COST_MTHD_CODEFORMULA, and CF_LEGAL_ENTITYFORMULA, each resolving and formatting their respective report parameters. BEFOREREPORT and AFTERREPORT are Oracle Reports triggers firing at report initialization and completion. AFTERPFORM is a report-level parameter form trigger. The helper procedures ITEMCP_P, ORGANIZATIONCP_P, and CP_PERIOD_STATUS_P likely populate parameter lists for the report. GMF_CMR12USR_XMLP_PKG_HEADER provides the package specification wrapper.

Tables Accessed

The package references three documented tables via APPS synonyms. GMF_PERIOD_STATUSES supplies cost period status information, driving the CP_PERIOD_STATUS_P helper and period-related parameters. GMF_FISCAL_POLICIES provides fiscal calendar policy definitions that govern which periods are valid for the cost management comparison. CM_MTHD_MST (cost method master) supplies the cost method codes used by COST_MTHD_CODEFORMULA. These tables represent the core Process Manufacturing costing configuration data required to scope the report.

Usage Notes

This package is invoked automatically by Oracle Reports when the associated concurrent program—the GMF Cost Management comparison report—is executed from the EBS concurrent manager or a responsibility menu. It is not called directly by custom code; rather, the report engine executes BEFOREREPORT, the formula functions, and AFTERREPORT as part of report execution. The dynamic predicates it builds, including the organization_code range from FROM_ORG and TO_ORG, are injected into the report's main query. Because the package is organization-sensitive through the mtl.organization_code clause, the "to_org" parameter directly bounds the report output by organization. Modifications should be avoided, as the package body is regenerated by Oracle Reports and any manual edits would be overwritten.