Search Results project_mfg




Overview
Explore in AI Chat

Overview

The APPS.PROJECT_MFG package is a restricted-scope PL/SQL stub residing in the APPS schema of Oracle E-Business Suite. Its designation as AUTHID CURRENT_USER indicates that it executes with the privileges of the invoking user rather than the definer, a convention typical of utility packages that must inherit the schema context of the calling session. The header comment ($Header: CSTPJCMS.pls 115.3 2002/11/11 18:59:53 awwang ship $) reveals that the package source is a member of the Cost Management (CST) module family — the CSTPJ prefix denotes Costing, Project, while the CMS suffix associates it with cost sub-element or cost method services. Despite its generic "project manufacturing" title, the package contains a single numeric and string formatting utility rather than a broad project manufacturing API. In EBS 12.1.1 and 12.2.2 the package has drifted out of active extension, having last been modified in 2002, and is retained primarily for backward compatibility with dependent objects.

Key Procedures and Functions

The package exposes one documented function:

  • matl_subelement — Returns a VARCHAR2 value that represents the material cost sub-element (or sub-element label) associated with a given item, cost type, and inventory organization. Its signature accepts three numeric inputs: I_ITEM_ID, I_RATES_COST_TYPE_ID, and I_ORG_ID. The function is annotated with PRAGMA RESTRICT_REFERENCES(matl_subelement, WNDS, WNPS), declaring that it writes neither database state (WNDS) nor packaged state (WNPS) — an assertion that permits the function to be invoked from SQL statements and from the WHERE clause of queries without violating purity rules.

No additional procedures or functions are documented, and no overloads exist.

Tables Accessed

Through APPS synonyms, the package resolves the following base tables:

  • BOM_RESOURCES — The Bill of Material resources table, which holds resource definitions and associated costs used in the derivation of manufacturing sub-elements.
  • CST_ITEM_COST_DETAILS — The detailed item cost store, containing per-level, per-cost-type cost breakdowns that supply the cost element partitioning logic.
  • MTL_PARAMETERS — The inventory organization parameter table, used to validate or contextualize the organization identifier supplied as I_ORG_ID.

The combination of these tables confirms that the function resolves organizational and cost-type context before returning a material cost sub-element designation, consistent with a cost rollup or cost-viewing helper.

Usage Notes

The package is referenced by one other documented package, which indicates that it is not typically invoked directly by end users but rather consumed within a costing call chain. Typical invocation points include:

  • Cost Management concurrent programs that assemble or display item cost sub-element breakdowns.
  • Project Manufacturing cost collection logic, where material sub-element identification is required during cost distribution.
  • Custom extensions or Oracle Forms personalizations that require a low-overhead, SQL-callable function to map an item/cost-type/organization triplet to a sub-element label.

Because the function is RESTRICT_REFERENCES-tagged with WNDS and WNPS, it is safe for use inside SQL in reporting and view definitions. Implementers should note the package's age and its narrow surface area when planning upgrades to 12.2.2, and should verify that the referencing package remains in the dependency chain before modifying or disabling it.