Search Results lane_id_tbl

Overview

APPS.FTE_LANE_PKG is a PL/SQL package body belonging to the Oracle E-Business Suite Transportation Management (FTE) module. Its business purpose is to manage the definition, maintenance, and retrieval of lanes — the reusable routing records that specify a carrier, an origin, a destination, a mode of transportation, transit times, and special handling instructions for moving goods between two locations. In the Oracle EBS 12.1.1 and 12.2.2 code lines the package acts as the low-level data access and DML layer behind the Lane and Schedule setup windows, providing the primary key generators, validation routines, and insert/update/delete logic required to persist lane, lane commodity, lane service, schedule, and price parameter data.

The source header identifies the package as FTE_LANE_PKG with a version of 120.5 and a "noship" designation, indicating it is an internal, non-shipped object distributed as part of the FTE schema rather than exposed as a public API. Its classification in the ETRM metadata is OTHER, and it is referenced by six other packages, so it functions as a shared internal utility rather than a standalone entry point.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions, grouped functionally as follows.

• Primary key generators: GET_NEXT_LANE_ID, GET_NEXT_LANE_COMMODITY_ID, GET_NEXT_LANE_SERVICE_ID, GET_NEXT_SCHEDULE_ID, and GET_NEXT_PRC_PARAMETER_ID return the next available surrogate identifier for the corresponding lane-related tables.
• Lookup and retrieval: GET_LANE_ID resolves a lane identifier from supplied lane attributes, while GET_SCHEDULE returns schedule information associated with a lane.
• Validation routines: VERIFY_OVERLAPPING_DATE checks that effective date ranges do not overlap; CHECK_EXISTING_LOAD determines whether existing load or shipment data depends on a lane; and CHECK_LANES performs lane-level validation checks before persistence.
• Type resolution: FIND_TYPE derives or classifies a type value used by the lane business logic.
• DML procedures: INSERT_LANE_TABLES inserts the core lane record and its dependent commodity and service rows; INSERT_SCHEDULES creates schedule records; INSERT_PRC_PARAMETERS creates price parameter records; UPDATE_LANE_FLAGS maintains lane status and flag columns; UPDATE_LANE_RATE_CHART maintains rate chart references; UPDATE_PRC_PARAMETER modifies price parameter rows; and DELETE_ROW removes a lane or dependent record.

Tables Accessed

The package reads and writes the principal FTE lane tables, together with their _S shadow tables used by the FTE engine for denormalized or synchronized copies.

• FTE_LANES and FTE_LANES_S — the master lane definition, including lane number, carrier, origin, destination, mode of transportation, transit time, transit time UOM, special handling, additional instructions, and freight commodity class.
• FTE_LANE_COMMODITIES and FTE_LANE_COMMODITIES_S — commodity eligibility for a lane.
• FTE_LANE_SERVICES and FTE_LANE_SERVICES_S — service-level associations for a lane.
• FTE_SCHEDULES and FTE_SCHEDULES_S — lane schedules.
• FTE_PRC_PARAMETERS and FTE_PRC_PARAMETERS_S — lane price parameters.
• FTE_LANE_RATE_CHARTS — rate chart references maintained by UPDATE_LANE_RATE_CHART.
• QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL — Oracle Advanced Pricing list headers, consulted when lane rate charts are tied to pricing lists.
• DUAL — used for single-row lookups.
• PLITBLM — the standard PL/SQL table-to-string utility package, referenced for SQL IN-list handling.

Usage Notes

Because the package is internally classified and not shipped as a public API, it is normally invoked indirectly. The Lane and Schedule setup forms in Oracle Transportation Management call these procedures to validate, insert, update, and delete lane data, and concurrent or batch programs may call them when loading lanes in bulk. The collection type LANE_ID_TBL, the object the user searched for, is an INDEX BY BINARY_INTEGER PL/SQL associative array defined over FTE_LANES.LANE_ID%TYPE; it is one of a family of parallel array types (LANE_NUMBER_TBL, CARRIER_ID_TBL, ORIGIN_ID_TBL, DESTINATION_ID_TBL, and others) used to pass bulk lane attribute sets into and out of the package's procedures. Customizations should treat FTE_LANE_PKG as an internal object subject to change between releases; direct calls are unsupported, and any reliance on LANE_ID_TBL or the other collection types should be confined to tightly controlled extensions that are re-tested at each EBS upgrade.