Search Results mst_excep_selection_criteria

Overview

APPS.MST_PQ_WORKS is a valid PL/SQL package body in the Oracle E-Business Suite APPS schema that supports the Personal Query (PQ) framework used by the Oracle Transportation Management (OTM) / ETRM integration and related logistics planning modules. Its principal business function is to persist, retrieve, and manipulate user-defined selection criteria associated with personal queries across several logistics domains, including load, order, shipment cost management (CM), and exception processing. The package serves as the persistence and orchestration layer that bridges the interactive query interface presented to end users and the underlying selection and results tables.

The package operates in both Oracle EBS 12.1.1 and 12.2.2 environments, which share the same APPS schema and PL/SQL architecture. Because it is a package body with no documented API classification beyond OTHER, it is treated as an internal implementation component rather than a formally published open interface.

Key Procedures and Functions

The documented package exposes eleven procedures and functions:

• POPULATE_RESULT_TABLE — Materializes the outcome of a saved personal query into the results table so that it can be displayed or consumed downstream.
• REMOVE_QUERY — Deletes a defined personal query from the user's query catalog.
• REMOVE_QRY_AND_RESULTS — Removes both the query definition and its previously generated result rows in a single operation.
• RENAME_QUERY — Updates the descriptive name of an existing personal query.
• INSERT_LOAD_SELECTION — Inserts selection criteria specific to the load domain.
• INSERT_CM_SELECTION — Inserts selection criteria specific to shipment cost management.
• INSERT_ORDER_SELECTION — Inserts selection criteria specific to the order domain.
• INSERT_EXCEP_SELECTION — Inserts selection criteria specific to exception handling.
• SAVE_QUERY_RESULT — Commits the evaluated result set of a personal query for later reuse.
• CLEAR_TEMP_QUERY — Purges transient or temporary query data that is not intended to persist.
• LAUNCH_REQUEST — Submits a concurrent request, typically to execute the query asynchronously or generate output.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

• MST_SELECTION and MST_SELECTION_CRITERIA — core storage for selection definitions and their criteria lines.
• MST_LOAD_SELECTION_CRITERIA, MST_ORDER_SELECTION_CRITERIA, MST_CM_SELECTION_CRITERIA, MST_EXCEP_SELECTION_CRITERIA — domain-specific criteria tables corresponding to each INSERT_* procedure.
• MST_PERSONAL_QUERIES — header records for user-defined queries.
• MST_PERSONAL_QUERY_RESULTS — stored output rows produced by POPULATE_RESULT_TABLE and SAVE_QUERY_RESULT.
• PLITBLM — a standard Oracle PL/SQL table type used for in-memory collections.

Message and profile utilities (FND_MESSAGE, FND_PROFILE) and concurrent submission (FND_REQUEST) are also referenced, supporting error reporting, profile-driven behavior, and request launching.

Usage Notes

MST_PQ_WORKS is referenced by zero other database objects, indicating it is invoked directly by EBS forms or concurrent programs rather than called by peer packages. Typical invocation occurs when a user defines, edits, executes, or deletes a personal query from an OTM/ETRM-related form, or when a scheduled concurrent request is launched through LAUNCH_REQUEST. The dependency on FND_REQUEST confirms support for concurrent submission, while FND_MESSAGE and FND_PROFILE provide error messaging and profile option evaluation. Customizations should treat this package as internal and avoid direct invocation unless replicating supported form behavior.