Results for “apply_fixed_process_loss”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GME_FPL_PVT is an Oracle EBS Process Manufacturing (OPM) private PL/SQL package owned by the APPS schema and classified in the ETRM repository as a PVT (private) API. It encapsulates the fixed process loss (FPL) logic used during batch creation and batch maintenance in Oracle Process Manufacturing. Process loss represents the anticipated or allowable yield variance for a batch, expressed as a quantity and a unit of measure, and is derived from recipe-level process loss definitions and validity rules. Rather than exposing FPL calculations directly to end users, the package centralizes retrieval, application, and batch-level recalculation of fixed process loss, so that forms, batch creation logic, and downstream packages share a single consistent implementation.

Because the package is declared with AUTHID CURRENT_USER, it executes with the privileges of the calling session. The header revision (120.1.12010000.1) confirms its presence in the 12.1.1 code line, and the object remains documented in ETRM 12.2.2, indicating continuity across both releases. The single metadata reference indicating that one other package depends on GME_FPL_PVT underscores its role as an internal building block rather than a public interface.

Key Procedures and Functions

  • GET_FIXED_PROCESS_LOSS — Resolves the fixed process loss for a given batch, validity rule, and organization, returning the loss quantity together with its unit of measure. It is the primary read operation for callers that need the FPL value without modifying batch data.
  • APPLY_FIXED_PROCESS_LOSS — Accepts a batch header record and a material details collection, evaluates the applicable fixed process loss, and returns updated batch header and material detail records along with a return status. The p_creation_mode and p_called_from parameters distinguish batch creation from batch detail maintenance, allowing the procedure to adjust behaviour by context.
  • FPL_BATCH_DETAILS — Performs batch-level FPL processing and populates the standard FND message list and message count alongside the return status, enabling callers to surface validation or processing messages to the user.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

Usage Notes

GME_FPL_PVT is invoked internally by the OPM batch creation and batch details forms and by the packages that support them, as evidenced by the single documented dependent package. It is not intended for direct invocation from custom code; developers requiring fixed process loss behaviour should use the supported public APIs that call this package, since the private signature may change between releases. Because there is no documented concurrent program interface, direct submission as a standalone concurrent request is not supported. Customizations that call GME_FPL_PVT directly must supply a valid batch header record and material details collection and must handle the NOCOPY OUT parameters and return status according to standard OPM API conventions.