Search Results g_aps_version




Overview
Explore in AI Chat

Overview

MSC_ATP_GLOBAL is a global utility package within the Oracle Advanced Supply Chain Planning (ASCP) and Available-to-Promise (ATP) infrastructure of Oracle E-Business Suite. Its role is to expose shared, session-scoped services that support ATP processing across the planning applications. The package is declared with AUTHID CURRENT_USER, meaning its executable privileges and name resolution are governed by the invoking schema rather than the owner, which is consistent with its use as a common runtime library invoked from multiple planning modules. The single header comment ($Header: MSCGLBLS.pls 120.1 ...) indicates the file has been stable since release 12.0.1, with no functional revisions carried into 12.1.1 or 12.2.2 beyond the base version shown.

Key Procedures and Functions

The package exposes three documented entry points:

  • EXTEND_ATP — The principal business procedure. It accepts an ATP record structure (MRP_ATP_PUB.ATP_Rec_Typ) as an IN OUT NOCOPY parameter, together with an OUT return status and an optional record index defaulting to 1. Its purpose is to extend, or recalculate, ATP supply for a given record within a caller-supplied ATP result set, updating the structure in place rather than returning a separate result.
  • GET_APS_VERSION — A function returning a NUMBER that reports the current Advanced Planning and Scheduling (APS) engine version. This package-level constant is initialized to 10 (G_APS_VERSION NUMBER := 10), so the function provides a runtime-queryable version indicator for downstream compatibility checks.
  • GET_ATP_SESSION_ID — A procedure returning a session identifier along with an OUT return status. It supplies the ATP session context used to correlate ATP computations within a single user or concurrent request session.

Because the source header is a specification only, the exact internal implementation of each routine is not documented; the descriptions above reflect the signatures and intent visible in the specification.

Tables Accessed

Per the ETRM metadata, the package references a single documented table via an APPS synonym: PLITBLM, a standard EBS concurrent-manager internal table. Access to this table is consistent with the package's role in obtaining or maintaining session and request context on behalf of its callers. No ATP or planning transactional tables are listed as direct dependencies, which reflects the fact that the ATP record structure is passed in and out as a PL/SQL collection rather than being persisted by this package itself.

Usage Notes

MSC_ATP_GLOBAL is not a user-facing object; it is an internal building block. ETRM records that it is referenced by 16 other packages, indicating that ATP and planning modules call it to extend ATP results, resolve the active APS version, and establish an ATP session identifier. Typical invocation is therefore from within PL/SQL drivers, concurrent programs, or forms logic in ASCP and related ATP flows, rather than through direct end-user action. Customizations should treat the package as a stable interface: the version function should be consulted before assuming a given ATP behavior, and EXTEND_ATP should be called with a properly typed ATP record from MRP_ATP_PUB. In the context of a search for "charge GTP," this package is relevant because GTP (Global Trade Processing) and ATP calculations frequently share the same planning engine session and version contexts managed here; no GTP-specific logic is present in the specification itself.