Search Results process_parcel

Overview

FTE_FREIGHT_PRICING_SPECIAL is a private engine package body within the Oracle E-Business Suite Freight and Transportation Execution (FTE) module, delivered under the APPS schema. Its business purpose is to compute freight charges for shipment lines that fall outside standard rate structures, applying special pricing logic such as dimensional weight, minimum charge floors, flat rates, and specialized handling for parcel and LTL (less-than-truckload) freight movements. The package supports the rate engine by evaluating carrier-specific rules and mitigating discrepancies between billed weight and actual shipment characteristics.

The header revision ($Header: FTEFRPSB.pls 120.6) indicates a relatively stable, mature code line dating to the 2005 timeframe, which is consistent with the 12.1.1 and 12.2.2 releases. The package relies heavily on package-level PL/SQL constructs, including associative arrays (rule_value_tab_type, bumped_rolledup_line_tab_type) and user-defined exceptions (g_finished_success, g_finished_warning) that drive control flow during pricing evaluation. Notably, the package body carries a bug fix reference (bug2803178) specific to parcel hundred-weight loose items, using the g_bumped_rolledup_lines array to manage rolled-up line quantities.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions, classified under ETRM as OTHER:

• INITIALIZE — Establishes package state, loads lane and carrier parameters, and prepares working structures before pricing execution.
• APPLY_DIMENSIONAL_WEIGHT — Computes chargeable weight by comparing actual weight against dimensional (volumetric) weight, using the container, volume, and weight basis constants.
• ISLTL — Predicate that determines whether the shipment is treated as LTL freight.
• ISPARCEL — Predicate that determines whether the shipment is treated as parcel freight; this is the entry context most relevant to searches for process_parcel.
• PROCESS_LTL — Executes the LTL pricing path, including any combined weight or distribution logic.
• PROCESS_PARCEL — Executes the parcel pricing path; the user's search term "process_parcel" maps directly to this procedure, which applies parcel-specific rating including dimensional and hundred-weight adjustments.
• PROCESS_OTHERS — Handles shipments that are neither LTL nor parcel.
• PROCESS_SPECIAL_CONDITIONS — Applies non-standard pricing conditions and exceptions.
• RATE_CONTAINER_ALL — Rates all containers associated with the shipment line.
• DISTRIBUTE_LTL_CONTAINER_WT — Allocates container weight across LTL lines for accurate rating.
• PROCESS_SHIPMENT_FLATRATE — Applies flat-rate pricing for shipments governed by flat-rate agreements.
• LOAD_CARRIER_DIM_WEIGHT_PARAMS — Loads carrier-specific dimensional weight parameters used by APPLY_DIMENSIONAL_WEIGHT.
• APPLY_MIN_CHARGE — Enforces minimum charge thresholds against calculated freight amounts.

Tables Accessed

The package references the following tables via APPS synonyms:

• FTE_PRC_PARAMETERS and FTE_PRC_PARAMETER_DEFAULTS — Source of pricing rule values and fallback defaults consumed via the rule_value structures.
• WSH_CARRIERS and WSH_CARRIER_SERVICES — Carrier and service definitions that determine applicable pricing logic.
• WSH_GLOBAL_PARAMETERS — Provides the UOM for number of units (cursor get_uom_for_each), used in parcel quantity interpretation.
• MTL_SYSTEM_ITEMS and MTL_CATEGORIES — Item attributes and category assignments used to classify freight and apply rules.
• DBMS_UTILITY and PLITBLM — Used for hashing (g_hash_base, g_hash_size) and collection utilities.

Usage Notes

FTE_FREIGHT_PRICING_SPECIAL is not a public API; it is invoked internally by the FTE rate engine during freight charge calculation for shipments. It is referenced by one other package, indicating a tightly coupled call path typically originating from shipment confirmation, rating, or freight audit processes. In EBS 12.1.1 and 12.2.2 environments, it is exercised when carrier services are rated, particularly for parcel and LTL shipments requiring dimensional weight or minimum-charge adjustments. Custom code should not call PROCESS_PARCEL directly; rather, integrations should invoke the standard FTE rating APIs that delegate to this package.