DBA Data[Home] [Help]

APPS.FTE_TRIPS_PVT dependencies on FTE_MLS_UTIL

Line 817: fte_mls_util.get_first_stop_location_id(

813: end if;
814: l_segment_sequencenum_prev:=l_trip_segments.sequence_number;
815:
816:
817: fte_mls_util.get_first_stop_location_id(
818: P_trip_segment_id =>l_trip_segments.wsh_trip_id,
819: x_trip_segment_name =>l_trip_segment_name,
820: x_first_stop_location_id =>l_segment_origin,
821: x_return_status =>x_return_status

Line 909: fte_mls_util.get_last_stop_location_id(

905: );
906: return;
907: end if;
908:
909: fte_mls_util.get_last_stop_location_id(
910: P_trip_segment_id =>l_trip_segments.wsh_trip_id,
911: x_trip_segment_name =>l_trip_segment_name,
912: x_last_stop_location_id =>l_segment_dest,
913: x_return_status =>x_return_status

Line 1497: FTE_MLS_UTIL.get_location_info(l_pickup_location_id,

1493: --
1494: --
1495: l_pickup_location := NULL;
1496:
1497: FTE_MLS_UTIL.get_location_info(l_pickup_location_id,
1498: l_pickup_location,x_return_status);
1499:
1500: IF (l_loop_count = 1)
1501: THEN