Search Results update_code_assgn

Overview

APPS.WSH_CREATE_CARRIERS_PKG is a shipping-execution utility package in the Oracle E-Business Suite WSH (Shipping) module. It centralizes the creation, maintenance, activation, and deactivation of carrier definitions and their associated code assignments, which are the master data records that drive freight rating, manifesting, and transportation planning. The package header (WSHCATHS.pls, version 120.0.12010000.1) declares a PL/SQL record type, CARecType, that mirrors the column structure of WSH_CARRIERS and selected HZ_PARTIES columns. That record exposes carrier identity (CARRIER_ID, SCAC_CODE, FREIGHT_CODE), operational flags (MANIFESTING_ENABLED), financial attributes (CURRENCY_CODE), the fifteen descriptive flexfield columns (ATTRIBUTE_CATEGORY through ATTRIBUTE15), and transportation-planning constraints such as MAX_NUM_STOPS_PERMITTED, MAX_TOTAL_DISTANCE, MAX_TOTAL_TIME, ALLOW_INTERSPERSE_LOAD, MAX_LAYOVER_TIME, MIN_LAYOVER_TIME, MAX_TOTAL_DISTANCE_IN_24HR, MAX_DRIVING_TIME_IN_24HR, MAX_DUTY_TIME_IN_24HR, ALLOW_CONTINUOUS_MOVE, and MAX_CM_DISTANCE. The package is classified as OTHER in the ETRM metadata and is referenced by two other packages, indicating it acts as a shared service layer rather than a standalone entry point. The presence of an X_SQLERR-style error-out convention is consistent with the standard EBS API pattern in which the caller retrieves the Oracle error message from a PL/SQL exception handler for logging or user feedback.

Key Procedures and Functions

Seven documented program units comprise the public interface:

• CREATE_CARRIERINFO — Creates a new carrier record, populating WSH_CARRIERS and the related HZ_PARTIES party record from the CARecType structure.
• UPDATE_CARRIERINFO — Modifies an existing carrier definition, including planning constraints, flexfield attributes, and manifesting flags.
• LOCK_CARRIERS — Obtains a lock on carrier rows to serialize concurrent updates and prevent lost updates during multi-step maintenance.
• CREATE_CODE_ASSGN — Inserts a code assignment linking a carrier to service, vehicle-type, or freight terminology values used for rating and validation.
• UPDATE_CODE_ASSGN — Maintains or expires an existing code assignment, supporting effective-dating and status changes.
• GET_SITE_TRANS_DETAILS — Returns site and transportation detail for a carrier or carrier site, typically used to populate downstream processing or inquiry screens.
• CARRIER_DEACTIVATE — Deactivates a carrier and its dependent relationships, removing it from active selection without physical deletion.

Tables Accessed

The package operates against the following tables through APPS synonyms:

• WSH_CARRIERS — Primary carrier master, holding SCAC, freight code, currency, manifesting flag, flexfield attributes, and planning constraints.
• HZ_PARTIES and HZ_PARTY_SITES — TCA party and site records supplying carrier name, status, and location context.
• HZ_CODE_ASSIGNMENTS — Classifications created and maintained by the code-assignment procedures.
• WSH_CARRIER_SITES, WSH_ORG_CARRIER_SITES, and WSH_CARRIER_SERVICES — Carrier-to-site, organization-carrier, and service mappings used during create, update, and deactivate operations.
• WSH_CARRIER_VEHICLE_TYPES, FND_LOOKUP_VALUES, and ORG_FREIGHT_TL — Validation and reference data for vehicle types, lookup codes, and translated freight terminology.

Usage Notes

The package is typically invoked from the Shipping carrier setup forms, from concurrent programs that load or refresh carrier records, and from custom PL/SQL that requires programmatic carrier maintenance. Callers should supply values through the CARecType record rather than ad-hoc DML, invoke LOCK_CARRIERS before updates in concurrent scenarios, and check the error out parameter for the SQLERRM text when an operation fails. Direct table updates bypass the package validation logic and are not recommended.