Search Results get_global_parameters

Overview

WSH_SHIPPING_PARAMS_GRP is a public PL/SQL package owned by APPS in Oracle E-Business Suite, classified in ETRM as an API of type GRP (Group). It belongs to the Shipping Execution module (WSH) and serves as the centralized access layer for shipping configuration parameters in Release 12.1.1 and 12.2.2. Rather than querying the shipping setup tables directly, Oracle shipping code, forms, and concurrent programs call this group package to retrieve both shipping-parameter values and global-parameter values in a consistent, cached, and validated manner. The package declares a package-level record type, Shipping_Params_Rec, whose fields mirror the columns of WSH_SHIPPING_PARAMETERS—including SHIP_CONFIRM_RULE_ID, AUTOPACK_LEVEL, TASK_PLANNING_FLAG, EXPORT_SCREENING_FLAG, APPENDING_LIMIT, IGNORE_INBOUND_TRIP, PACK_SLIP_REQUIRED_FLAG, PICK_SEQUENCE_RULE_ID, PICK_GROUPING_RULE_ID, PRINT_PICK_SLIP_MODE, PICK_RELEASE_REPORT_SET_ID, AUTOCREATE_DEL_ORDERS_FLAG, DEFAULT_STAGE_SUBINVENTORY, DEFAULT_STAGE_LOCATOR_ID, AUTODETAIL_PR_FLAG, ENFORCE_PACKING_FLAG, and the various GROUP_BY_* flags. This record structure allows a caller to fetch an entire shipping-parameters row in one call instead of issuing many individual lookups, which is the principal reason the package was introduced. A user or developer searching for "get_global_parameters" has reached the correct object: GET_GLOBAL_PARAMETERS is one of the two documented entry points of this package.

Key Procedures and Functions

• GET_SHIPPING_PARAMETERS — Returns the shipping execution parameters for an operating unit (organization) as defined in WSH_SHIPPING_PARAMETERS. It is the primary accessor used by shipping forms and concurrent programs to determine pick, pack, ship-confirm, and staging behavior configured by the user.
• GET_GLOBAL_PARAMETERS — Returns the shipping global parameters maintained in WSH_GLOBAL_PARAMETERS. These values apply at a broader level than per-operating-unit shipping parameters and control system-wide shipping behavior. This procedure is the object referenced in the user's search.

Both procedures are documented as public and, consistent with the GRP classification, are intended to expose parameter values to other Oracle shipping packages (the package is referenced by five other packages) as well as to customer extensions.

Tables Accessed

• WSH_SHIPPING_PARAMETERS — The configuration table holding operating-unit-level shipping execution parameters. The package reads this table to populate the Shipping_Params_Rec structure and to serve GET_SHIPPING_PARAMETERS.
• WSH_GLOBAL_PARAMETERS — The configuration table holding system-level shipping parameters. It is read by GET_GLOBAL_PARAMETERS.

Access to these tables is through APPS synonyms, so the package runs under the APPS schema and observes the standard EBS multi-org and security model. The package is expected to be read-only with respect to both tables; its purpose is retrieval of configuration, not maintenance. All configuration changes occur through the Oracle Shipping setup forms, which write to these tables directly.

Usage Notes

• Internal shipping code — Other WSH packages (five documented referrers) and shipping forms call these procedures to obtain parameter values before performing pick release, packing, ship confirmation, or delivery creation logic.
• Concurrent programs — Pick Release, Ship Confirm, and related shipping concurrent programs rely on the returned parameter values to determine processing rules, report sets, and grouping behavior.
• Custom code and extensions — Customer-developed PL/SQL that must behave consistently with standard shipping logic should call GET_SHIPPING_PARAMETERS or GET_GLOBAL_PARAMETERS rather than reading the underlying tables directly, ensuring the same interpretation of the setup data.
• Version scope — The header of the source file identifies it as WSHSPGPS.pls (120.0.12010000.4), confirming its presence and use in the 12.1.x/12.2.x code line.