Search Results change_ss_status

Overview

GMD_STABILITY_STUDIES_GRP is a packaged PL/SQL API owned by the APPS schema within the Oracle E-Business Suite Process Manufacturing (formerly Oracle Quality and Oracle Process Manufacturing) product family. It is classified as a GRP (group) package, meaning it exposes a collection of related public procedures and functions rather than a single business object interface. In Oracle EBS 12.1.1 and 12.2.2, the package encapsulates the core server-side logic supporting the Stability Studies form, which is used by process manufacturers to plan, schedule, approve, and launch stability testing programs for products under regulatory and quality control scrutiny.

The package centralizes the calculation of stability study time points, end dates derived from storage plans, sample quantity and unit-of-measure determination, checklist validation for approvals and launches, and controlled status transitions. A header comment dated 2005 indicates the package has been in production since an early release of the 11i Process Manufacturing suite and remains part of the documented 12.2.2 API surface. Because it is a group package rather than a published public API, it is intended primarily for internal consumption by Oracle Forms and concurrent processing, though custom code can call it when the same business logic is required.

Key Procedures and Functions

• STABILITY_STUDY_EXIST — A function that determines whether a stability study identified by a stability study number already exists. It returns a BOOLEAN and is typically used for duplicate-key validation before creating a study record.
• CALCULATE_END_DATE — A function that computes the projected end date of a stability study. It accepts a storage plan identifier and a start date, and returns a DATE. This is the entry point most frequently referenced in searches for the "calculate_end_date" keyword, and it drives the schedule generated from the storage plan and its associated test interval periods.
• CALCULATE_SAMPLE_QTY — A procedure that derives the required sample quantity and the corresponding sample unit of measure for a given material source, returning both values as OUT parameters along with a standard return status. It supports pull-down and defaulting behavior on the material sources region of the form.
• SS_APPROVAL_CHECKLIST_OK — A procedure that validates whether all mandatory checklist items for approving a stability study have been satisfied, returning a status indicator. It gates the approval action in the Stability Studies workflow.
• SS_LAUNCH_CHECKLIST_OK — A procedure that performs the equivalent validation for launching a stability study, ensuring launch prerequisites are complete before time points are activated.
• CHANGE_SS_STATUS — A procedure that transitions a stability study from a source status to a target status, returning both a status code and a message. Status transitions are validated against the configured next-status matrix.

The package source also documents a comment indicating that an earlier validate_sampling_event procedure and a check_doc_numbering function were removed or disabled, as their validations were absorbed by the material sources form and by subsequent INVCONV changes.

Tables Accessed

Database access occurs through APPS synonyms for the Process Manufacturing and Oracle Inventory base tables:

• GMD_STABILITY_STUDIES_B, GMD_SS_TIME_POINTS, GMD_SS_MATERIAL_SOURCES, GMD_SS_VARIANTS — core stability study definition, time point schedule, sample source, and variant data used by nearly every procedure.
• GMD_STORAGE_PLAN_DETAILS, GMD_TEST_INTERVAL_PLANS_B, GMD_TEST_INTERVAL_PLAN_PERIODS — storage plan and interval plan definitions from which end dates and time points are derived by CALCULATE_END_DATE.
• GMD_SPECIFICATIONS, GMD_QUALITY_CONFIG, GMD_QC_STATUS_NEXT — specification linkage, quality configuration options, and the status transition matrix validated by CHANGE_SS_STATUS.
• MTL_SYSTEM_ITEMS_B, MTL_PARAMETERS — item and organization context used to resolve the item and organization under which a study is executed.
• WF_EVENTS, WF_EVENT_SUBSCRIPTIONS — Oracle Workflow event publication and subscription used to signal stability study status changes.
• DUAL — used for scalar evaluations within PL/SQL expressions.

Usage Notes

GMD_STABILITY_STUDIES_GRP is invoked primarily from the Stability Studies Oracle Forms module, where its functions supply default and calculated values and its procedures perform server-side validation during commit, approval, and launch actions. It is also callable from custom PL/SQL, concurrent programs, or workflow activities when the same stability study logic is required outside the form. The package is not referenced by any other documented package in the 12.2.2 metadata, so its dependencies flow outward to tables and to Workflow rather than to other group APIs. Because it is a GRP-classified package rather than a formal public API, Oracle does not guarantee backward compatibility of its signatures across releases; implementers should treat it as internal and wrap calls appropriately when used in custom extensions.