Search Results process_tl_surcharges

Overview

FTE_TL_LOADER is a PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Freight and Transportation Execution (FTE) module's Transportation Calendar (TL) rate-loading facility. Its primary business function is to accept block-structured rate data submitted through the FTE Bulk Load infrastructure and convert that data into the pricing entities used by Oracle Advanced Pricing and Oracle Shipping Execution — specifically rate charts, modifiers, surcharges, and facility charges. The package also resolves and caches the carrier, service level, unit of measure, currency, and rate-chart context that governs each inbound rate line.

The package header exposes several global package variables and associative-array caches. These include the precedence constants G_CONST_PRECEDENCE_LOW (180), G_CONST_PRECEDENCE_MID (200), and G_CONST_PRECEDENCE_HIGH (220), along with typed collections such as Number_Tab, Varchar100_Tab, and Varchar2000_Tab used to cache chart names, carriers, service levels, line numbers, process IDs, chart types, minimum charges, start and end dates, chart IDs, currencies, and link information for chart names and modifier names. Additional scalar globals hold the active chart name, carrier name, carrier ID, service level, carrier unit basis and its UOM, distance UOM, time UOM, currency, and weekend/layover UOM.

Key Procedures and Functions

• PROCESS_TL_BASE_RATES — Processes the base rate lines of a transportation calendar load, accepting block header and block data collections plus a line number, with an optional validation flag. Returns a status code and error message to the caller.
• PROCESS_TL_SURCHARGES — Processes surcharge lines for the transportation calendar load, applying the same block header/block data validation approach used for base rates.
• PROCESS_FACILITY_CHARGES — Handles facility charge lines, using the cached facility modifier name, basis, and UOM collections to build the appropriate pricing structures.
• SUBMIT_TL_CHART — Submits the fully assembled transportation calendar rate chart, typically by creating or updating the associated price list header and formula records.
• PROCESS_DATA — The central driver that iterates the bulk-load block data, dispatches the appropriate processing routine, and coordinates error accumulation across the load.
• RESET_ALL — Clears the package-level global variables and cache collections, restoring the package to a clean state before a new load begins. This is the routine most frequently referenced when a prior load must be abandoned or re-run, because the chart, carrier, and modifier globals otherwise persist across calls within the same session.

Tables Accessed

The package reads and writes across FTE pricing and shipping tables through APPS synonyms: FTE_LANES and FTE_LANE_RATE_CHARTS for lane and rate-chart definition; FTE_PRC_PARAMETERS and FTE_PRC_PARAMETERS_S for FTE pricing parameters; QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL for the price list header and its translated name; QP_PRICE_FORMULAS_B for pricing formulas; QP_QUALIFIERS for qualifier rules; HZ_PARTIES for carrier and party details; WSH_CARRIERS and WSH_CARRIER_SERVICES for carrier and service-level validation; and PLITBLM for bulk-load block data processing.

Usage Notes

FTE_TL_LOADER is invoked indirectly through the FTE bulk-load process, which stages inbound rate data in the block structures defined by FTE_BULKLOAD_PKG. It is referenced by two other packages in the ETRM schema, indicating that it serves as a shared processing layer rather than a standalone entry point. RESET_ALL is typically called at the start of each load cycle to prevent stale cache values from a previous chart from contaminating subsequent processing. Because the package maintains session-scoped state, care should be taken in concurrent or long-running sessions to invoke RESET_ALL between logically distinct loads.