APPS.FTE_WSH_TRIPS_PVT dependencies on FTE_MLS_UTIL

Line 279: fte_mls_util.get_trip_segment_name

275: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
276:
277: wsh_debug_sv.dlog (c_debug,'about to get segment name...');
278:
279: fte_mls_util.get_trip_segment_name
280: (
281: p_trip_segment_id => p_trip_info.WSH_TRIP_ID,
282: x_trip_segment_name => l_wsh_trip_name,
283: x_return_status => x_return_status

Line 354: fte_mls_util.get_next_segment_id

350: end if;
351:
352: -- segment can only be added to the end of in-transit trip
353: if (l_status = 'IT') then
354: fte_mls_util.get_next_segment_id
355: (
356: p_trip_segment_id => p_trip_info.WSH_TRIP_ID,
357: p_sequence_number => p_trip_info.SEQUENCE_NUMBER,
358: p_trip_id => p_trip_info.FTE_TRIP_ID,

Line 428: fte_mls_util.get_previous_segment_id

424: if (p_action_code = 'CREATE') then
425:
426: wsh_debug_sv.dlog (c_debug,'about to get_previous_segment_id...');
427:
428: fte_mls_util.get_previous_segment_id
429: (
430: p_trip_segment_id => p_trip_info.WSH_TRIP_ID,
431: p_sequence_number => p_trip_info.SEQUENCE_NUMBER,
432: p_trip_id => p_trip_info.FTE_TRIP_ID,

Line 463: fte_mls_util.get_first_stop_location_id

459: and wsh_trip_id = l_previous_segment_id;
460:
461: wsh_debug_sv.dlog (c_debug,'about to get_first_stop_location_id...');
462:
463: fte_mls_util.get_first_stop_location_id
464: (
465: p_trip_segment_id => p_trip_info.WSH_TRIP_ID,
466: x_trip_segment_name => l_trip_segment_name,
467: x_first_stop_location_id => l_first_stop_location_id,

Line 488: fte_mls_util.check_previous_segment

484: wsh_debug_sv.dlog (c_debug,'return status', x_return_status);
485:
486: wsh_debug_sv.dlog (c_debug,'about to check_previous_segment...');
487:
488: fte_mls_util.check_previous_segment
489: (
490: p_trip_id => p_trip_info.FTE_TRIP_ID,
491: p_trip_segment_id => l_previous_segment_id,
492: p_sequence_number => l_previous_sequence_number,

Line 537: fte_mls_util.get_next_segment_id

533: end if; -- l_previous_segment_id is NOT null
534:
535: wsh_debug_sv.dlog (c_debug,'about to get_next_segment_id...');
536:
537: fte_mls_util.get_next_segment_id
538: (
539: p_trip_segment_id => p_trip_info.WSH_TRIP_ID,
540: p_sequence_number => p_trip_info.SEQUENCE_NUMBER,
541: p_trip_id => p_trip_info.FTE_TRIP_ID,

Line 572: fte_mls_util.get_last_stop_location_id

568: and wsh_trip_id = l_next_segment_id;
569:
570: wsh_debug_sv.dlog (c_debug,'about to get_last_stop_location_id...');
571:
572: fte_mls_util.get_last_stop_location_id
573: (
574: p_trip_segment_id => p_trip_info.WSH_TRIP_ID,
575: x_trip_segment_name => l_trip_segment_name,
576: x_last_stop_location_id => l_last_stop_location_id,

Line 597: fte_mls_util.check_next_segment

593: wsh_debug_sv.dlog (c_debug,'return status', x_return_status);
594:
595: wsh_debug_sv.dlog (c_debug,'about to check_next_segment...');
596:
597: fte_mls_util.check_next_segment
598: (
599: p_trip_id => p_trip_info.FTE_TRIP_ID,
600: p_trip_segment_id => l_next_segment_id,
601: p_sequence_number => l_next_sequence_number,

Line 934: fte_mls_util.get_trip_segment_name

930: END IF;
931:
932: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
933:
934: fte_mls_util.get_trip_segment_name
935: (
936: p_trip_segment_id => p_wsh_trip_id,
937: x_trip_segment_name => l_wsh_trip_name,
938: x_return_status => x_return_status

Line 982: fte_mls_util.get_previous_segment_id

978: select sequence_number into l_sequence_number
979: from fte_wsh_trips
980: where fte_trip_id = p_fte_trip_id and wsh_trip_id = p_wsh_trip_id;
981:
982: fte_mls_util.get_previous_segment_id
983: (
984: p_trip_segment_id => p_wsh_trip_id,
985: p_sequence_number => l_sequence_number,
986: p_trip_id => p_fte_trip_id,

Line 1008: fte_mls_util.get_next_segment_id

1004: );
1005: RETURN;
1006: END IF;
1007:
1008: fte_mls_util.get_next_segment_id
1009: (
1010: p_trip_segment_id => p_wsh_trip_id,
1011: p_sequence_number => l_sequence_number,
1012: p_trip_id => p_fte_trip_id,