Results for “get_cost_amount”

33 results




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

Overview

The APPS.OE_FREIGHT_RATING_UTIL package is a utility (UTIL classification) PL/SQL package in the Oracle Order Management module of Oracle E-Business Suite. Its primary business function is to support freight rating and estimated cost calculations during the order line pricing and freight determination cycle. Freight rating involves calculating the shipping charges that apply to order lines based on carrier, shipping method, and item attributes. This package provides helper logic that is called by the pricing and freight integration packages rather than being invoked directly by end users.

The package resides in the APPS schema; its status is VALID, and it depends on the SYS.STANDARD package. It is referenced by several core Order Management packages, including OE_CONFIG_UTIL, OE_FREIGHT_RATING_PVT, and OE_LINE_UTIL, as well as by itself. The dependency on OE_LINE_UTIL is particularly relevant for solutions that reference oe_line_util, since the line utility package consults the freight rating utility in the course of processing order lines.

Key Procedures and Functions

The ETRM documentation records six procedures and functions within this package:

  • IS_FREIGHT_RATING_AVAILABLE — Determines whether freight rating functionality is available for the current context. It acts as a guard condition used by calling packages before attempting rating or cost calculations.
  • GET_COST_AMOUNT — Returns the cost amount associated with freight rating for the relevant order or line context.
  • GET_LIST_LINE_TYPE_CODE — Retrieves the line type code used by the list or freight rating logic, enabling callers to classify lines appropriately.
  • GET_ESTIMATED_COST_AMOUNT — Provides the estimated cost amount used in freight rating calculations, typically before final costs are confirmed.
  • CREATE_DUMMY_ADJUSTMENT — Creates a placeholder or dummy price adjustment record, which is used in rating scenarios where an adjustment entry is required to support downstream pricing or freight processing.
  • GET_ESTIMATED_COST_AMOUNT_NS — A variant of the estimated cost amount function, distinguished by the _NS suffix, typically denoting a non-standardized or alternate implementation used internally.

Parameter lists are not documented in the ETRM metadata and should be verified against the package specification in a specific environment.

Tables Accessed

The package accesses the following tables through APPS synonyms:

  • OE_PRICE_ADJUSTMENTS — The base price adjustment table. The package reads or writes adjustment records, consistent with the behavior of CREATE_DUMMY_ADJUSTMENT.
  • OE_PRICE_ADJUSTMENTS_S — The corresponding audit/shadow table for price adjustments.
  • DUAL — The standard single-row Oracle table, used for simple value selection and availability checks.
  • PLITBLM — A PL/SQL index-by table type used internally to hold collections of values during processing rather than a physical base table.

Usage Notes

OE_FREIGHT_RATING_UTIL is an internal utility package; it is not exposed through Oracle Forms or standalone concurrent programs. It is invoked indirectly by other Order Management packages such as OE_FREIGHT_RATING_PVT, OE_CONFIG_UTIL, and OE_LINE_UTIL when an order line is priced or freight-rated. Because OE_LINE_UTIL depends on this package, customizations that modify order line processing may encounter it during freight and cost calculations.

Custom code should not call this package directly unless the calling environment already performs the prerequisite context setup carried out by the standard packages. Any customization should reference the current package specification, as signatures may differ between releases such as 12.1.1 and 12.2.2.