Search Results inv_orgncpformula




Overview
Explore in AI Chat

Overview

GMF_CMRCWA_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as OTHER within the ETRM repository. The package name follows the Oracle XML Publisher (BI Publisher) concurrent program package convention, in which a database package is bound to a report definition generated from an Oracle Reports source and exposed as an XML Publisher concurrent program. The underlying source header CMRCWAS.pls identifies the report as belonging to the Process Manufacturing (GMF) cost management family, and the abbreviation CMRCWA is consistent with a Cost Management/Work in Process cost comparison or cost valuation report. In Oracle EBS 12.1.1 and 12.2.2, packages of this type act as the report's server-side shell: they declare the report's user-entered parameters, provide the lexical bind variables used to build dynamic WHERE clauses, and implement the pre-report and post-report trigger functions that XML Publisher invokes during execution. The package contains no autonomous business logic of its own; instead it defines the contract between the concurrent program parameter form and the SQL query embedded in the report data template.

Key Procedures and Functions

The package declares twelve documented procedures and functions:

  • G_COST_ORGANIZATIONGROUPFILTER — Returns BOOLEAN; controls the organization security group filter applied to the cost organization parameters.
  • G_INV_ORGANIZATIONGROUPFILTER — Returns BOOLEAN; the equivalent organization security group filter for the inventory organization parameters.
  • COST_ORGNCPFORMULA — Returns VARCHAR2 given a cost organization value; constructs the lexical WHERE fragment used to restrict the report to the selected cost organizations.
  • COST_ORGNCFFORMULA — Returns VARCHAR2; supplies the cost organization filter fragment used during the concurrent program's execution.
  • INV_ORGNCPFORMULA — Returns VARCHAR2 given an inventory organization value; constructs the corresponding inventory organization filter fragment. This is the function most closely associated with the user's search term "inv_orgncp_p".
  • INV_ORGNCFFORMULA — Returns VARCHAR2; supplies the inventory organization filter fragment at run time.
  • AFTERPFORM — Returns BOOLEAN; the XML Publisher after-parameter-form trigger, fired once the parameter form is submitted and before the report query executes.
  • GMF_CMRCWA_XMLP_PKG_HEADER — A header procedure, conventionally used by the XML Publisher behavior to initialize the package header state.
  • BEFOREREPORT — Returns BOOLEAN; the before-report trigger, invoked before data retrieval, typically used to derive the lexical filter strings and default values.
  • AFTERREPORT — Returns BOOLEAN; the after-report trigger, invoked after the report data has been fetched.
  • COST_ORGNCP_P — Returns VARCHAR2; a public accessor returning the current cost organization lexical clause (COST_ORGNCP).
  • INV_ORGNCP_P — Returns VARCHAR2; the public accessor returning the current inventory organization lexical clause (INV_ORGNCP), which is initialized to 'and 1=1' when no restriction is supplied.

The package-level variables SORT_BY, FROM_COST_ORGN, TO_COST_ORGN, FROM_INV_ORGN, TO_INV_ORGN, SY_ALL, NONBLOCKSQL, and the P_*_ID identity parameters hold the parameter form values for the duration of the run.

Tables Accessed

The ETRM metadata records no direct table references through APPS synonyms for this package. Its documented behavior is limited to defining parameters and generating lexical predicates; the actual query against cost and inventory organization data is executed by the XML Publisher data template rather than by PL/SQL inside the package. Consequently, no INSERT, UPDATE, or DELETE activity is exposed, and the package performs no writes.

Usage Notes

The package is not referenced by any other package in the ETRM repository, which confirms it is a top-level concurrent program artifact rather than a shared library. It is invoked indirectly whenever the associated XML Publisher report is run: Oracle Concurrent Manager instantiates the report, XML Publisher calls BEFOREREPORT and, depending on configuration, AFTERPFORM, and the data template then references COST_ORGNCP_P and INV_ORGNCP_P to splice the generated lexical clauses into its SQL. In Oracle EBS 12.1.1 and 12.2.2 this pattern is unchanged, though 12.2 deployments occasionally re-point the XML Publisher data definition to a newer template while leaving the package intact. Because the filter accessors default to 'and 1=1', a failed or empty parameter selection returns all organizations rather than suppressing the query, a behavior report developers should account for when restricting data by operating unit or inventory organization.