Search Results gmp_bom_routing_pkg

Overview

GMP_BOM_ROUTING_PKG (source file GMPBMRTS.pls) is an Oracle EBS Process Manufacturing package owned by APPS and defined with AUTHID CURRENT_USER. It supports the interface between process manufacturing formulas, routings, and bill of material structures on one side and the Advanced Planning and Scheduling staging tables on the other. The package is central to the extraction, validation, and loading (export) of effectivity, routing, operation, and BOM component data used in the APS/ASCP planning cycle for process organizations.

Its scope includes effectivity extraction routines, formula and routing validation functions, routing search helpers, and the write procedures that populate the MSC_ST_* staging tables. The package is referenced by three other packages and is normally invoked from process manufacturing concurrent programs rather than directly by end users.

Key Procedures and Functions

EXTRACT_EFFECTIVITIES — extracts process effectivity records using the given apps link, delimiter, instance, and run date, returning a status flag.
TIME_STAMP and LOG_MESSAGE — utility routines for timestamping and writing log output during batch processing.
GMP_DEBUG_MESSAGE — diagnostic logging routine added under a defect fix for troubleshooting.
CHECK_FORMULA and CHECK_FORMULA_FOR_ORGANIZATION — boolean functions that determine whether a formula is valid, standalone and within the context of a specific organization.
VALIDATE_FORMULA and VALIDATE_FORMULA_FOR_ORGN — wrapper procedures that invoke the corresponding formula validation checks.
INVALIDATE_RTG_ALL_ORG — invalidates routing information across all organizations for a given routing identifier. This is the routine associated with this document and is typically called when routing data must be reset or flushed prior to a subsequent planning load.
VALIDATE_ROUTING — validates a routing against an organization, header locale, and returns a routing validity flag.
SEARCH_OPERATION_LEADTIME — returns top and bottom leadtime range values for an operation / effectivity combination, added under a defect fix.
LINK_ROUTING and LINK_OVERRIDE_ROUTING — establish the routing-to-operation linkage and the override linkage used during staging writes.
EXPORT_EFFECTIVITIES — exports effectivity records as part of the export phase.
BSEARCH_ROUTING and BSEARCH_SETUPID — binary search helpers used to locate routing identifiers and setup identifiers within staged collections.
WRITE_PROCESS_EFFECTIVITY, WRITE_BOM_COMPONENTS, WRITE_ROUTING, WRITE_ROUTING_OPERATIONS — the primary staging writers. Each accepts an effectivity-related identifier and returns a status flag, populating the MSC_ST_* interface tables.

Tables Accessed

The package reads and writes through APPS synonyms. AD_APPLIED_PATCHES is queried for patch-level tracking. GMD_OPERATIONS and GMP_SEQUENCE_TYPES provide the process manufacturing operation and sequence type definitions referenced during routing validation. IC_ITEM_MST supplies process item master data. MSC_APPS_INSTANCES identifies the planning instance. DBMS_SESSION is used for session-level context. The MSC_ST_BOMS, MSC_ST_BOM_COMPONENTS, MSC_ST_OPERATION_COMPONENTS, MSC_ST_OPERATION_NETWORKS, MSC_ST_OPERATION_RESOURCES, MSC_ST_OPERATION_RESOURCE_SEQS, MSC_ST_PROCESS_EFFECTIVITY, MSC_ST_ROUTINGS, and MSC_ST_ROUTING_OPERATIONS tables are the APS staging targets that receive the extracted and transformed process manufacturing structures.

Usage Notes

GMP_BOM_ROUTING_PKG is invoked from process manufacturing concurrent programs and programs that perform APS/ASCP data collection; it is not intended for direct interactive use. The presence of AUTHID CURRENT_USER indicates that it executes with the privileges of the calling schema, so callers must hold the necessary privileges on the process and staging tables. Custom code should avoid calling the extraction and export routines outside of the standard planning cycle, since INVALIDATE_RTG_ALL_ORG and the export writers manipulate staging content that the planning collection process depends upon. Defect-fix annotations in the source (GMP_DEBUG_MESSAGE, SEARCH_OPERATION_LEADTIME) indicate the package continues to receive targeted enhancements under Oracle support, and the header version (120.7.12020000.1) confirms applicability across the 12.1.1 and 12.2.2 releases.

PACKAGE: APPS.GMP_BOM_ROUTING_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMP_BOM_ROUTING_PKG, status:VALID,
PACKAGE BODY: APPS.GMP_BOM_ROUTING_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMP_BOM_ROUTING_PKG, status:VALID,
PACKAGE: APPS.GMP_BOM_ROUTING_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMP_BOM_ROUTING_PKG, status:VALID,
PACKAGE BODY: APPS.GMP_BOM_ROUTING_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMP_BOM_ROUTING_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
SYNONYM: APPS.MSC_ST_PROCESS_EFFECTIVITY 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_PROCESS_EFFECTIVITY, status:VALID,
SYNONYM: PUBLIC.V$STATNAME 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:V$STATNAME, status:VALID,
SYNONYM: APPS.MSC_ST_OPERATION_RESOURCES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_OPERATION_RESOURCES, status:VALID,
SYNONYM: APPS.MSC_ST_OPERATION_RESOURCE_SEQS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_OPERATION_RESOURCE_SEQS, status:VALID,
SYNONYM: APPS.MSC_ST_ROUTING_OPERATIONS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_ROUTING_OPERATIONS, status:VALID,
PACKAGE BODY: APPS.GMP_APS_DS_PULL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMP_APS_DS_PULL, status:VALID,
12.2.2 DBA Data 12.2.2
SYNONYM: APPS.GMP_SEQUENCE_TYPES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:GMP_SEQUENCE_TYPES, status:VALID,
SYNONYM: APPS.GMP_SEQUENCE_TYPES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMP_SEQUENCE_TYPES, status:VALID,
SYNONYM: APPS.MSC_ST_OPERATION_COMPONENTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_OPERATION_COMPONENTS, status:VALID,
SYNONYM: APPS.MSC_ST_PROCESS_EFFECTIVITY 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_PROCESS_EFFECTIVITY, status:VALID,
SYNONYM: APPS.MSC_ST_OPERATION_NETWORKS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_OPERATION_NETWORKS, status:VALID,
SYNONYM: APPS.MSC_ST_ROUTINGS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_ROUTINGS, status:VALID,
PACKAGE: APPS.GMP_CALENDAR_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMP_CALENDAR_PKG, status:VALID,
SYNONYM: APPS.MSC_ST_BOM_COMPONENTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_BOM_COMPONENTS, status:VALID,
SYNONYM: PUBLIC.V$STATNAME 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:V$STATNAME, status:VALID,
SYNONYM: APPS.MSC_ST_BOMS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_BOMS, status:VALID,
PACKAGE: APPS.GMP_CALENDAR_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMP_CALENDAR_PKG, status:VALID,
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
SYNONYM: PUBLIC.V$MYSTAT 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:V$MYSTAT, status:VALID,
SYNONYM: APPS.MSC_ST_OPERATION_COMPONENTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_OPERATION_COMPONENTS, status:VALID,
SYNONYM: APPS.AD_APPLIED_PATCHES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AD_APPLIED_PATCHES, status:VALID,
SYNONYM: PUBLIC.V$MYSTAT 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:V$MYSTAT, status:VALID,
SYNONYM: APPS.MSC_ST_OPERATION_RESOURCES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_OPERATION_RESOURCES, status:VALID,
SYNONYM: APPS.MSC_ST_OPERATION_RESOURCE_SEQS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_OPERATION_RESOURCE_SEQS, status:VALID,
SYNONYM: APPS.MSC_ST_ROUTING_OPERATIONS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_ROUTING_OPERATIONS, status:VALID,
SYNONYM: APPS.MSC_ST_OPERATION_NETWORKS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_OPERATION_NETWORKS, status:VALID,
PACKAGE BODY: APPS.GMP_APS_DS_PULL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMP_APS_DS_PULL, status:VALID,
SYNONYM: APPS.MSC_ST_BOMS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_BOMS, status:VALID,
SYNONYM: APPS.MSC_ST_BOM_COMPONENTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_BOM_COMPONENTS, status:VALID,
SYNONYM: APPS.MSC_ST_ROUTINGS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MSC_ST_ROUTINGS, status:VALID,
SYNONYM: APPS.GMD_OPERATIONS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMD_OPERATIONS, status:VALID,
PACKAGE BODY: APPS.MSC_CL_GMP_UTILITY 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_CL_GMP_UTILITY, status:VALID,
PACKAGE BODY: APPS.MSC_CL_PULL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_CL_PULL, status:VALID,
PACKAGE: APPS.GMP_BOM_ROUTING_PKG 12.1.1
PACKAGE BODY: APPS.MSC_CL_PULL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_CL_PULL, status:VALID,
SYNONYM: APPS.GMD_OPERATIONS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:GMD_OPERATIONS, status:VALID,
PACKAGE: APPS.GMP_BOM_ROUTING_PKG 12.2.2
SYNONYM: PUBLIC.DBMS_SESSION 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_SESSION, status:VALID,
SYNONYM: PUBLIC.DBMS_SESSION 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_SESSION, status:VALID,
SYNONYM: APPS.MSC_APPS_INSTANCES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_APPS_INSTANCES, status:VALID,
SYNONYM: APPS.IC_ITEM_MST 12.2.2
owner:APPS, object_type:SYNONYM, object_name:IC_ITEM_MST, status:VALID,
SYNONYM: PUBLIC.V$PARAMETER 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:V$PARAMETER, status:VALID,
SYNONYM: PUBLIC.V$PARAMETER 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:V$PARAMETER, status:VALID,