Results for “create_update_freight_costs”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.WSH_FREIGHT_COSTS_PUB package is a public PL/SQL API within the Oracle E-Business Suite Shipping Execution module. It exposes the core business logic used to maintain freight cost records associated with shipments, delivery lines, and related transportation activities. Freight costs represent charges levied by carriers or incurred internally for moving goods, and they must be captured, validated, and stored consistently so downstream processes such as cost accounting, invoicing, and shipment analysis remain accurate. This package serves as the supported, publicly callable interface — indicated by its PUB classification — through which forms, concurrent programs, and custom extensions can create, update, validate, and remove freight cost data without manipulating the underlying base tables directly. It runs in the APPS schema and is documented as VALID under the ETRM metadata for 12.2.2, and the same interface behavior applies in 12.1.1.

Key Procedures and Functions

The package exposes three documented entry points. No parameter signatures are invented here; only the documented names and their functional intent are described.

• CREATE_UPDATE_FREIGHT_COSTS — The primary write routine. It inserts new freight cost records or modifies existing ones, applying the package's internal validation and derivation logic before persisting to the freight cost tables. This is the standard entry point for capturing carrier charges against a shipment or delivery.
• VALIDATE_FREIGHT_COST_TYPE — A validation routine that verifies whether a supplied freight cost type is defined and permitted. It prevents records from being written with invalid or unauthorized cost type codes, protecting the integrity of freight cost classification.
• DELETE_FREIGHT_COSTS — Removes freight cost records that are no longer required, for example when a shipment is cancelled or re-rated. It provides the supported mechanism for logical or physical removal of previously captured freight charges.

Tables Accessed

• WSH_FREIGHT_COST_TYPES — Stores the setup definitions of valid freight cost types. The package reads this table, primarily through VALIDATE_FREIGHT_COST_TYPE, to confirm that a cost type being written or referenced is legitimate.
• PLITBLM — An APPS synonym referenced by the package, typically used for bulk or array-based PL/SQL operations supporting set-based processing of freight cost rows.

The package relies on an APPS synonym layer, so its SQL executes with the privileges and object resolution of the APPS schema.

Usage Notes

WSH_FREIGHT_COSTS_PUB is normally invoked indirectly by Oracle's own Shipping Execution and Warehouse Management logic rather than called manually by end users. The metadata records that it is referenced by WMS_DIRECT_SHIP_PVT, WSH_INTERFACE_COMMON_ACTIONS, and a second unit named WSH_FREIGHT_COSTS_PUB, indicating that direct shipment processing and common interface actions drive freight cost creation and maintenance through this API. It also depends on the standard FND_API utility package, consistent with Oracle's public API conventions for message handling and return status. In 12.1.1 and 12.2.2 alike, developers extending freight cost functionality should call these procedures through the PUB interface rather than issuing DML against the base tables, ensuring validation, consistency, and upgrade safety. Any call should also respect the FND_API return conventions so error information propagates cleanly to the calling form or concurrent program.