Search Results process_rate_line

Overview

FTE_RATE_CHART_LOADER is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the bulk loading of rate chart and rating setup data within the Transportation and Logistics / Freight and Transportation Execution (FTE) module. Its principal responsibility is to parse structured upload blocks representing rating zones, rating setups, origins, destinations, rate charts, rate lines, rate breaks, rating attributes, and charges and discounts, and to persist them into the ETRM pricing model. The package is defined with AUTHID CURRENT_USER, meaning that it executes with the privileges of the invoking user rather than the owner, which is significant when it is called from concurrent programs or custom wrappers.

The package forms part of the rate chart bulk upload infrastructure, working alongside FTE_BULKLOAD_PKG, whose PL/SQL table types (block_header_tbl and block_data_tbl) are used as the primary input structures. A user searching for "process_qualifier" will be interested in the PROCESS_QUALIFIER procedure, which handles the qualifier component of a rate chart definition during the load.

Key Procedures and Functions

• PROCESS_DATA — The dispatcher entry point. It receives a block type, block header, block data, and starting line number, and routes the block to the appropriate processing routine. It returns a status code and an error message.
• PROCESS_RATE_CHART — Processes rate chart header lines, with optional column validation and data validation flags.
• PROCESS_RATE_LINE — Processes individual rate line records belonging to a rate chart.
• PROCESS_RATE_BREAK — Processes rate break records that define tiered or quantity-based rating structures.
• PROCESS_RATING_ATTRIBUTE — Processes rating attribute definitions associated with a rate chart.
• PROCESS_CHARGES_DISCOUNTS — Processes charges and discount header records.
• PROCESS_CHARGES_DISCOUNTS_LINE — Processes the detail lines for charges and discounts.
• PROCESS_ADJUSTED_RATE_CHART — Processes adjusted rate chart definitions.
• PROCESS_QUALIFIER — Processes qualifier records, which constrain the applicability of a rate chart or rate based on qualifying conditions.
• ADD_ATTRIBUTE — Adds a single attribute definition to the working attribute collection.
• SUBMIT_QP_PROCESS — Submits the Quick Price or qualifier processing step required to finalize loaded data.
• INIT_QP_TABLES — Initializes the PL/SQL tables used for QP (Quick Price / qualifier) processing.

Tables Accessed

The documented table reference for this package is PLITBLM, an Oracle Applications internal table commonly used for temporary storage during bulk processing routines. This table typically supports intermediate staging of parsed block data before it is committed to the permanent rate chart and rating tables. Because the metadata lists only this single referenced table, the package likely performs its primary inserts and updates through other procedures or packages invoked during processing.

Usage Notes

FTE_RATE_CHART_LOADER is not intended to be called directly by ad hoc SQL. It is designed to be invoked from FTE bulk upload concurrent programs, from the rate chart upload UI in Oracle Transportation Management / EBS transportation forms, or from custom uploader code that constructs the block header and block data PL/SQL tables. Because the package is referenced by four other packages and uses AUTHID CURRENT_USER, integrators should ensure that the invoking user has the necessary privileges on the underlying ETRM objects. Error handling follows the convention of returning x_status (with -1 indicating success) and x_error_msg, so callers must inspect both values after each invocation to detect partial or complete load failures.