Search Results get_minutes

Overview

The APPS.GMO_SWORKBENCH_GRP package is a PL/SQL group (GRP) type package within the Oracle E-Business Suite Process Manufacturing (OPM/GMO) module. Its header comment identifies it as GMOGSWBS.pls, version 120.1, last updated in June 2007, and the package is owned by the APPS schema. The "SWORKBENCH" portion of the name indicates that the package supports the Shop Floor Workbench functionality used by process manufacturers to manage and track production activities, batch tasks, and resource usage. Specifically, this group package provides reusable calculation utilities that convert raw task and time data into percentage-complete metrics and decomposed time components (days, hours, minutes). These utilities allow the OPM workbench and related screens to report progress on routing tasks and resource usage over user-defined periods or weekly windows.

Key Procedures and Functions

The ETRM metadata documents seven callable elements in this package:

• GET_TASK_PERCENTAGE — Returns the percentage completion of tasks within a specified area, bounded by a maximum number of tasks and a given date. An overloaded signature additionally accepts an oper parameter (operator) that modifies the calculation context.
• GET_WEEKLY_TASK_PERCENTAGE — Returns the percentage completion of tasks within an area over a defined weekly window (week start date and week end date). An overloaded signature again accepts the oper parameter for alternate calculation behavior.
• GET_DAYS — Parses a string time value and returns the number of whole days it represents.
• GET_HOURS — Parses a string time value and returns the number of hours it represents.
• GET_MINUTES — Parses a string time value and returns the number of minutes it represents.

Together, the percentage functions provide progress metrics for workbench task areas, while the time-decomposition functions convert formatted duration strings into discrete day/hour/minute integers suitable for reporting or further arithmetic.

Tables Accessed

The ETRM documentation does not list any base tables referenced directly by this package; any table access would occur through APPS synonyms. Given its purpose, the package likely reads task and routing data stored in OPM workbench-related entities (for example, task area and task instance data) to compute the percentage values it returns. The time functions (GET_DAYS, GET_HOURS, GET_MINUTES) operate purely on their input strings and require no table access. Because no tables are documented, integrators should treat the package's data dependencies as internal to the Process Manufacturing schema and avoid relying on undocumented read patterns.

Usage Notes

This package is classified as a GRP (group) API, meaning it is intended primarily for internal use by Oracle EBS components rather than as a public integration interface. It is typically invoked from the OPM Shop Floor Workbench forms and related Process Manufacturing concurrent programs whenever task completion percentages or decomposed time values must be displayed or recalculated. Because the metadata records zero referencing packages, it is not a dependency of other PL/SQL APIs and should be considered a leaf-level utility. Custom code may call these functions when reusing the standard progress-calculation logic, but developers should validate behavior against the specific EBS release (12.1.1 or 12.2.2) in use, since the package has not been revised since 2007 and its GRP classification signals that Oracle does not guarantee backward-compatible signatures.