Search Results aso_freight_charges_s

Overview

The ASO_FREIGHT_CHARGES_PKG package body in the APPS schema belongs to the Oracle Order Management / Advanced Pricing freight and shipping charge infrastructure within Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to provide the programmatic layer responsible for maintaining the base-table records that store freight charge definitions applied to shipments and delivery lines. These freight charges are surfaced through the ASO (Order Capture / Sales Order) module's shipping and freight calculation flows, where they drive landed-cost determination and freight estimation during order entry and shipping execution.

The package is classified as an OTHER API type rather than a formally published open API, indicating that it is primarily intended for internal use by other EBS components rather than as a public integration surface. The ETRM record confirms the object is VALID and is referenced by three other database objects.

Key Procedures and Functions

The documented package exposes five procedures, four of which are explicitly identified:

• INSERT_ROW — Creates a new freight charge record, populating the base table and its associated translated (TL/_S) table so that descriptive attributes are available in multiple languages.
• UPDATE_ROW — Modifies an existing freight charge record, synchronizing changes across both the base and _S tables.
• LOCK_ROW — Acquires a row-level lock on a freight charge record to support concurrency control during concurrent maintenance operations, relying on the WHO columns and Oracle's standard locking conventions.
• DELETE_ROW — Removes a freight charge record and its associated translated row.

The fifth documented routine supports the same CRUD pattern; together these procedures constitute a standard EBS table-handler API that enforces WHO-column auditing through FND_API utilities.

Tables Accessed

The package interacts with the following documented tables via APPS synonyms:

• ASO_FREIGHT_CHARGES — The base table storing freight charge definitions, including amounts, currency, and charge-type attributes.
• ASO_FREIGHT_CHARGES_S — The translated (_S) table holding language-specific descriptive columns such as charge name and description; this is the table referenced by users searching for "aso_freight_charges_s".
• ASO_SHIPMENTS — The shipments table, consulted to associate freight charges with specific shipment records during runtime calculation and validation.

Usage Notes

Because this package is classified as OTHER, it is not documented as a supported public API for external integrations. It is typically invoked internally — for example, by Order Management freight calculation logic, shipment confirmation flows, or administrative maintenance forms that manage freight charge setup. Customizations that must manipulate freight charge records should generally be directed at the corresponding UI or a supported API; direct calls to this package should be reserved for controlled extensions that replicate the same CRUD semantics, including WHO-column population, message-stack handling through FND_MESSAGE, and locking behavior. Its dependencies on ASO_UTILITY_PVT, FND_API, and APP_EXCEPTION confirm that it follows standard EBS error-handling patterns, raising and propagating application exceptions rather than raw SQL errors. The "not referenced by any database object" note indicates no database-level dependents such as triggers or views, so lifecycle changes to the package are comparatively low-risk from a schema-dependency standpoint.