Search Results search_services




Overview
Explore in AI Chat

Overview

FTE_MLS_TEST_NT is a PL/SQL package in the APPS schema that belongs to the Oracle E-Business Suite Transportation Management (FTE) module, part of the ETRM (Enterprise Transportation and Rate Management) product family. The package is classified as an "OTHER" API and forms part of the service tender and rate-shopping infrastructure. Its primary business purpose is to support the multi-leg shipping (MLS) test harness functionality used by the FTE user interface components—specifically Trip Workbench (TripWB), Delivery Workbench (DeliveryWB), and ManageItinerary. The package header captured in the ETRM documentation carries the revision marker $Header: FTEMLTES.pls 120.2 2005/07/06, indicating it is an older, non-shipped (noship) source unit retained for wrapper and test purposes.

At a functional level, the package exposes procedures that let callers assign a carrier service to a shipment or trip, generate or update ranked service lists, create and modify tenders (carrier rate agreements), and clean up obsolete rate records. When the FTE_TENDER_ATTR_REC record structure is populated, additional tender attributes are processed during the assignment operation—this is the linkage that the search term fte_tender_attr_rec refers to.

Key Procedures and Functions

The documented package exposes two public procedures:

  • ASSIGN_SERVICE_TENDER — Performs the core service tender assignment. It assigns a service to a shipment or trip, creates or updates the ranked service list, generates and updates tenders, and deletes stale rates. The presence of the FTE_TENDER_ATTR_REC parameter record determines whether additional tender attributes are applied. This procedure is called directly by the FTE user interface screens TripWB, DeliveryWB, and ManageItinerary. It returns standard API status information through return status, message count, and message data output parameters.
  • SEARCH_SERVICES — Executes a search for eligible services based on a supplied attribute record and the caller context. It returns the list creation type, a sorted rate table, and the pricing request identifier along with the standard API return status, message count, and message data. This procedure serves the rate-shopping and service selection paths invoked from the UI layers.

No private functions or helper routines are documented in the metadata; only these two public entry points are exposed in the package specification.

Tables Accessed

The ETRM metadata documents a single table reference through APPS synonyms: PLITBLM. This is the FTE multi-leg shipping table used internally to persist service and tender processing context. Reads and writes against this table occur during the assign and search flows described above. Other supporting tables for rates, tenders, and ranked lists are accessed indirectly through the underlying FTE API calls rather than being referenced directly by name in the documented metadata.

Usage Notes

FTE_MLS_TEST_NT is not intended as a primary integration API. The "TEST" and "NT" tokens in its name, together with the noship header, indicate this package is a wrapper and test variant used by the FTE multil-leg shipping UI rather than a supported enterprise interface. It is invoked from:

  • FTE-based Oracle Forms: TripWB, DeliveryWB, and ManageItinerary, which call ASSIGN_SERVICE_TENDER when a user assigns a carrier service, and SEARCH_SERVICES when a user performs rate shopping.
  • Internal FTE wrapper logic that prepares the FTE_SS_ATTR_REC and FTE_TENDER_ATTR_REC structures before delegating to the base FTE APIs.

Because it is referenced by zero other packages and is not part of the shipped support boundary, customers and integrators should not build custom code directly against this package. The correct approach for customization is to use the supported FTE public APIs, such as FTE_SERVICE_ASSIGN_PVT or the corresponding public tender APIs, which FTE_MLS_TEST_NT itself wraps. Any direct dependency risks breakage on patch application and is unsupported by Oracle Support.