Search Results aso_freight_charges_pkg




Overview
Explore in AI Chat

Overview

ASO_FREIGHT_CHARGES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Order Capture / Quoting (ASO) module, which is part of the broader Oracle Advanced Pricing and Order Management footprint. Its specific business purpose is to manage freight charge records associated with quotes and shipments. In the Quote-to-Order flow, freight or shipping charges are calculated and attached to a quote so that the customer sees an accurate landed cost before order placement. This package provides the low-level data manipulation layer that inserts, updates, locks, and deletes those freight charge rows within the ASO data model.

The package is classified in the ETRM metadata as an "OTHER" API, meaning it is not a publicly supported interface API but rather an internal utility package invoked by other ASO private packages. Its status is VALID in the APPS schema, and it is documented in both Oracle EBS 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The ETRM documentation identifies five documented program units, four of which are named procedures:

  • INSERT_ROW — Creates a new freight charge record in the underlying freight charges tables. It is the entry point for adding a calculated or manually entered freight line to a quote or shipment.
  • UPDATE_ROW — Modifies an existing freight charge record, typically used when freight amounts, carrier information, or charge attributes change during quote revision or repricing.
  • LOCK_ROW — Acquires a row-level lock on a freight charge record to ensure data integrity during concurrent update operations, preventing lost updates in multi-user quoting scenarios.
  • DELETE_ROW — Removes a freight charge record, invoked when a freight line is no longer applicable to the quote or shipment.

The metadata notes five total documented units but names only four procedures; the fifth is not identified in the excerpt. Parameter lists are not documented and are therefore not reproduced here.

Tables Accessed

The package operates against three documented tables via APPS synonyms:

  • ASO_FREIGHT_CHARGES — The primary transactional table storing freight charge header-level details for quotes and shipments.
  • ASO_FREIGHT_CHARGES_S — A secondary table in the ASO freight charges schema, generally used to hold supplementary or translated/sequence-related freight charge data.
  • ASO_SHIPMENTS — The shipment table against which freight charges are associated, linking charges to specific shipment records within the quote.

All DML performed by the four procedures targets these tables.

Usage Notes

ASO_FREIGHT_CHARGES_PKG is not intended for direct invocation by end users or custom extensions. According to the ETRM dependency data, it is referenced by three other ASO private packages: ASO_QUOTE_HEADERS_PVT, ASO_QUOTE_LINES_PVT, and ASO_SHIPMENT_PVT. It also references itself, indicating internal recursive or helper calls. This dependency pattern confirms that the package acts as a persistence helper supporting higher-level quote header, quote line, and shipment processing logic.

Typical invocation occurs indirectly when a user creates or modifies a quote in the Oracle Quoting / Order Capture forms, or when shipment information is processed. The _PVT packages call these procedures during their own insert, update, and delete flows. Customizations should avoid calling ASO_FREIGHT_charges_PKG directly; instead, they should use the supported public APIs exposed by the parent _PVT packages to maintain data integrity and upgrade safety.