APPS.FTE_WSH_INTERFACE_PKG dependencies on FTE_WSH_TRIPS

Line 230: FROM fte_wsh_trips a, fte_trips b

226: --
227: CURSOR get_segment_trips_cur
228: IS
229: SELECT b.fte_trip_id, sequence_number, b.name fte_trip_name
230: FROM fte_wsh_trips a, fte_trips b
231: WHERE a.wsh_trip_id = p_trip_segment_rec.trip_id
232: AND a.fte_trip_id = b.fte_trip_id;
233: --
234: --

Line 505: FROM fte_wsh_trips a, fte_trips b

501: --
502: CURSOR get_segment_trips_cur
503: IS
504: SELECT b.fte_trip_id, sequence_number, b.name fte_trip_name
505: FROM fte_wsh_trips a, fte_trips b
506: WHERE a.wsh_trip_id = p_trip_segment_rec.trip_id
507: AND a.fte_trip_id = b.fte_trip_id;
508: --
509: --

Line 978: FROM fte_wsh_trips a, fte_trips b

974: --
975: CURSOR get_segment_trips_cur
976: IS
977: SELECT b.fte_trip_id, sequence_number, b.name fte_trip_name
978: FROM fte_wsh_trips a, fte_trips b
979: WHERE a.wsh_trip_id = p_trip_segment_rec.trip_id
980: AND a.fte_trip_id = b.fte_trip_id;
981: --
982: --

Line 1187: FROM fte_wsh_trips a, fte_trips b

1183: --
1184: CURSOR get_segment_trips_cur
1185: IS
1186: SELECT b.fte_trip_id, sequence_number, b.name fte_trip_name
1187: FROM fte_wsh_trips a, fte_trips b
1188: WHERE a.wsh_trip_id = p_trip_segment_rec.trip_id
1189: AND a.fte_trip_id = b.fte_trip_id;
1190: --
1191: --}

Line 1538: FROM fte_wsh_trips a, fte_trips b

1534: --
1535: CURSOR get_segment_trips_cur
1536: IS
1537: SELECT b.fte_trip_id, sequence_number, b.name fte_trip_name
1538: FROM fte_wsh_trips a, fte_trips b
1539: WHERE a.wsh_trip_id = p_trip_segment_rec.trip_id
1540: AND a.fte_trip_id = b.fte_trip_id;
1541: --
1542: --}

Line 2309: FROM fte_wsh_trips a, fte_trips b

2305: --
2306: CURSOR get_segment_trips_cur
2307: IS
2308: SELECT b.fte_trip_id, sequence_number, b.name fte_trip_name
2309: FROM fte_wsh_trips a, fte_trips b
2310: WHERE a.wsh_trip_id = p_new_trip_segment_rec.trip_id
2311: AND a.fte_trip_id = b.fte_trip_id;
2312: --
2313: --

Line 2321: FROM fte_wsh_trips a, wsh_trips b

2317: p_sequencE_number IN NUMBER
2318: )
2319: IS
2320: SELECT b.status_code, b.trip_id, b.name wsh_trip_name
2321: FROM fte_wsh_trips a, wsh_trips b
2322: WHERE a.fte_trip_id = p_trip_id
2323: AND a.sequence_number < p_sequence_number
2324: AND a.wsh_trip_id = b.trip_id;
2325: --

Line 2544: FROM fte_wsh_trips a, fte_trips b

2540: --
2541: CURSOR get_segment_trips_cur
2542: IS
2543: SELECT b.fte_trip_id, sequence_number, b.name fte_trip_name
2544: FROM fte_wsh_trips a, fte_trips b
2545: WHERE a.wsh_trip_id = p_trip_segment_rec.trip_id
2546: AND a.fte_trip_id = b.fte_trip_id;
2547: --
2548: --

Line 2576: fte_wsh_trips_pvt.delete_trip

2572: l_trip_name := get_segment_trips_rec.fte_trip_name;
2573: --
2574: --
2575: --{
2576: fte_wsh_trips_pvt.delete_trip
2577: (
2578: p_fte_trip_id => get_segment_trips_rec.fte_trip_id,
2579: P_wsh_trip_id => p_trip_segment_rec.trip_id,
2580: x_return_status => l_return_status,

Line 2588: p_api_name => 'FTE_WSH_TRIPS_PUB.DELETE_TRIP',

2584: --
2585: --
2586: FTE_MLS_UTIL.api_post_call
2587: (
2588: p_api_name => 'FTE_WSH_TRIPS_PUB.DELETE_TRIP',
2589: p_api_return_status => l_return_status,
2590: p_message_name => 'FTE_TRIP_SEGMENT_UNEXP_ERROR',
2591: p_trip_segment_id => p_trip_segment_rec.trip_id,
2592: p_trip_segment_name => p_trip_segment_rec.name,