Search Results period_idformula

Overview

The APPS.GMF_CMR12USR_XMLP_PKG package is a report-support PL/SQL package used in Oracle E-Business Suite Process Manufacturing (OPM) environments on releases 12.1.1 and 12.2.2. Its header comment, $Header: CMR12USRS.pls 120.0 2007/12/24, indicates it originates from the CMR12USRS source file and belongs to the family of generated XML Publisher (XMLP) report packages. These packages exist to service Oracle Reports/XML Publisher concurrent programs by providing the PL/SQL anchors that the report layout calls during execution.

The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the invoking user rather than as the owner, which is typical for APPS-owned report packages. Its primary business purpose is to support a cost management report that compares item and organization cost information across a user-specified range of items and organizations, for a given cost type, legal entity, calendar, and period. The numerous package-level variables—item and organization ranges, calendar and period codes, cost type ID, legal entity ID, organization IDs, item IDs, and the concurrent request ID—correspond to the report parameter form and the report's internal state.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions. Grouped by role, they are:

• BEFOREREPORT — Boolean function invoked before report execution, used to initialize parameters and package state.
• AFTERPFORM — Boolean function executed after the report parameter form is processed, allowing validation or derivation of values.
• AFTERREPORT — Boolean function executed after the report body completes, typically for cleanup.
• GMF_CMR12USR_XMLP_PKG_HEADER — The header function the user searched for; it initializes the package's report context on the server side.
• ITEMCFFORMULA, ITEMCPFORMULA, ORGANIZATIONCFFORMULA, ORGANIZATIONCPFORMULA — Formula functions (CF/CP naming) that return display values for item and organization fields in the report layout.
• BASE_CURRCFFORMULA — Returns the base currency display value.
• PERIOD_IDFORMULA, COST_MTHD_CODEFORMULA, CF_LEGAL_ENTITYFORMULA — Formula functions returning the period identifier, cost method code, and legal entity name/identifier respectively.
• ITEMCP_P, ORGANIZATIONCP_P, CP_PERIOD_STATUS_P — Accessor functions that expose the item, organization, and period-status values held in package variables.

No parameter lists are declared in the documented metadata beyond the formula input shown for ITEMCPFORMULA; descriptions above reflect purpose only.

Tables Accessed

The package reads from three APPS synonyms:

• CM_MTHD_MST — The cost method master, used to resolve cost method codes for the report.
• GMF_FISCAL_POLICIES — Fiscal policy definitions, used to determine calendar and period context.
• GMF_PERIOD_STATUSES — Period status records, used to populate the period status and confirm whether the selected period is open or closed.

Only SELECT activity is implied; report-support packages of this type generally do not perform DML.

Usage Notes

The package is not referenced by any other PL/SQL package (referenced by 0 documented objects), confirming that it is called only by its associated XML Publisher report definition and concurrent program. It is invoked when the cost management report is submitted from the OPM cost management responsibility, either interactively with parameters populated by the parameter form or on a scheduled basis. Customizations should avoid modifying the package logic directly; instead, changes to report output should be layered through the XML template, since the standard package is patched with the EBS code line.