Search Results gmo_sworkbench_grp

Overview

GMO_SWORKBENCH_GRP is a wrapper (GRP-classified) package body owned by APPS in the Oracle E-Business Suite, residing in the Process Manufacturing (GMO) schema family. It serves as a thin public façade over the private implementation package GMO_SWORKBENCH_PVT, which supports the Process Manufacturing "Workbench" — the graphical scheduling and task-tracking interface used by production supervisors and planners to monitor shop-floor task completion. The package exposes a small, stable set of calculation routines that derive percentage-completion metrics and time-component conversions, insulating callers from the internal logic and allowing the underlying private package to change without breaking dependent forms, reports, and concurrent programs. The body carries the header identifier $Header: GMOGSWBB.pls 120.1 2007/06/21 ... noship $, indicating a low-revision, non-shipped script that has remained functionally stable across the 12.1.1 and 12.2.2 releases.

The package name itself uses the "GRP" suffix convention common in EBS, denoting a group or publicly callable interface. Despite this, the body contains no independent business logic: every function simply delegates to its counterpart in GMO_SWORKBENCH_PVT and returns the result.

Key Procedures and Functions

The documented interface consists of seven overloaded and non-overloaded functions:

• GET_TASK_PERCENTAGE — Returns the percentage of scheduled tasks completed for a given work area over a specified date. It exists in two overloads: one taking the area identifier, a maximum task count, and a date value, and a second adding a numeric operand that selects an alternate calculation mode. Both accept area_id as the first argument, making it the principal search key for this package.
• GET_WEEKLY_TASK_PERCENTAGE — Returns the task completion percentage within a discrete weekly window defined by a start and end date. Like its daily counterpart, it is overloaded; the variant with the extra oper argument permits callers to choose between calculation styles.
• GET_DAYS — Converts a string-encoded time value into a numeric count of days.
• GET_HOURS — Extracts the hours component from a string-encoded time value and returns it as a number.
• GET_MINUTES — Extracts the minutes component from a string-encoded time value and returns it as a number.

Each function is a single-statement delegate; the declared local variable percentage defaults to zero, ensuring a deterministic return even if the private package yields a null.

Tables Accessed

The ETRM metadata records no direct table references from this body, which is consistent with its design: it performs no SQL of its own. Any data retrieval occurs inside GMO_SWORKBENCH_PVT, which queries the underlying Process Manufacturing workbench and task tables via APPS synonyms. Because the group layer never touches base tables directly, it holds no grants or DML privileges beyond EXECUTE on the private package.

Usage Notes

This package is typically invoked from the Process Manufacturing Workbench form and its associated OAF pages, from custom client extensions attempting to reproduce the completion-percentage displays, and from any concurrent program or PL/SQL block that needs the same metrics server-side. Callers should reference APPS.GMO_SWORKBENCH_GRP only and must never call GMO_SWORKBENCH_PVT directly, since the private package is not part of the supported API surface. Because the metadata records no other packages referencing this one, integration is via forms and ad-hoc custom code rather than through a package dependency chain. The area_id parameter is mandatory and nullable-safe; a null area generally yields a zero percentage rather than an error. The repository notes the object as non-shipped (noship), so implementations should confirm its presence before relying on it in a target environment.