Search Results delete_main_records

Overview

APPS.FTE_TRIP_RATING_GRP is the group API package within Oracle Transportation/Enterprise Transportation Management (FTE) responsible for trip rating and re-rating operations in Oracle E-Business Suite 12.1.1 and 12.2.2. Its central purpose is to evaluate a trip against configured pricing, lane, schedule, and vehicle-type data and to produce or refresh the rate records associated with that trip. The package is declared AUTHID CURRENT_USER and exposes a small public interface centred on the Rate_Trip procedure, supported by sorting and maintenance utilities. Because rating can be triggered from multiple points in the transportation lifecycle, the package is designed to accept caller and event context so that the same rating engine can serve dispatch, shipping confirmation, and explicit re-rating scenarios.

Key Procedures and Functions

• SORT — Orders a supplied collection of sort values and returns the resulting index ordering and a return status. It supports variations in sorting behaviour and is used to rank or sequence rating candidates.
• RATE_TRIP — The principal public API. It rates a trip from various event points, accepting an action-parameter record that identifies the caller ('FTE' or 'WSH'), the event ('TP-RELEASE', 'SHIP-CONFIRM', 'RE-RATING'), the action ('RATE'), and the trip identifier. It returns the standard EBS API return status, message count, and message data, and honours the API version, message-list initialization, commit, and process-log initialization conventions.
• RATE_TRIP_CONC — A concurrent-program entry point used to drive trip re-rating. Documented behaviour indicates the input should be either a WSH trip identifier or a WSH trip name.
• MOVE_RECORDS_TO_MAIN — Moves working rating records into the main tables, consolidating newly computed results.
• DELETE_MAIN_RECORDS — Removes existing main rating records, typically ahead of a re-rating cycle.
• COMPARE_TRIP_RATES — Compares trip rate results, supporting validation of recalculated versus existing rates.
• SEARCH_RATE_SORT — Retrieves and orders rate records for comparison or display.
• DISPLAY_RANK_REC — Presents ranked rating records, supporting diagnostics and review.

Tables Accessed

The package references transportation configuration and transaction data through APPS synonyms. FTE_LANES, FTE_SCHEDULES, FTE_VEHICLE_TYPES, FTE_PRICING_COMP_REQUEST_S, and WSH_GLOBAL_PARAMETERS supply lanes, schedules, vehicle types, pricing computation requests, and system parameters used during evaluation. WSH_TRIPS, WSH_TRIP_STOPS, WSH_DELIVERY_LEGS, and WSH_NEW_DELIVERIES provide the trip, stop, leg, and delivery context required to rate a trip. FTE_TRIP_MOVES holds movement information consumed during rating. DBMS_UTILITY and PLITBLM provide collection and numeric-array utilities, while FTE_TRIP_RATING_GRP’s own structures carry the sort values and action parameters.

Usage Notes

FTE_TRIP_RATING_GRP is invoked programmatically rather than directly by end users. The FTE and WSH applications call it at events such as trip release, ship confirmation, and re-rating, passing the action-parameter record to identify the caller and event. The RATE_TRIP_CONC procedure is called directly from the trip re-rating concurrent program, accepting a WSH trip identifier or trip name. Because nine other packages reference this package, customizations should treat it as a stable group API and call RATE_TRIP with the documented parameters rather than replicating rating logic. Callers should set the commit flag appropriately and inspect the returned status and message data before proceeding, since rating failures are reported through the standard EBS API message stack.