APPS.FTE_WSH_INTERFACE_PKG dependencies on FTE_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 424: UPDATE fte_trips

420: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
421: l_number_of_warnings := l_number_of_warnings + 1;
422: --
423: --
424: UPDATE fte_trips
425: SET validation_required = 'Y'
426: WHERE fte_trip_id = get_segment_trips_rec.fte_trip_id;
427: --}
428: END IF;

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 699: UPDATE fte_trips

695: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
696: l_number_of_warnings := l_number_of_warnings + 1;
697: --
698: --
699: UPDATE fte_trips
700: SET validation_required = 'Y'
701: WHERE fte_trip_id = get_segment_trips_rec.fte_trip_id;
702: --}
703: END IF;

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 1445: fte_trips_pvt.validate_trip

1441: /*
1442: FOR get_segment_trips_rec IN get_segment_trips_cur
1443: LOOP
1444: --{
1445: fte_trips_pvt.validate_trip
1446: (
1447: p_trip_id => get_segment_trips_rec.fte_trip_id,
1448: x_return_status => l_return_status
1449: );

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 1636: UPDATE fte_trips

1632: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
1633: l_number_of_warnings := l_number_of_warnings + 1;
1634: --
1635: --
1636: UPDATE fte_trips
1637: SET validation_required = 'Y'
1638: WHERE fte_trip_id = get_segment_trips_rec.fte_trip_id;
1639: --}
1640: END IF;

Line 1693: UPDATE fte_trips

1689: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
1690: l_number_of_warnings := l_number_of_warnings + 1;
1691: --
1692: --
1693: UPDATE fte_trips
1694: SET validation_required = 'Y'
1695: WHERE fte_trip_id = get_segment_trips_rec.fte_trip_id;
1696: --}
1697: END IF;

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 2421: UPDATE fte_trips

2417: --}
2418: END LOOP;
2419: --
2420: --
2421: UPDATE fte_trips
2422: SET status_code = 'IT',
2423: last_update_date = sysdate,
2424: last_updated_by = FND_GLOBAL.USER_ID,
2425: last_update_login = FND_GLOBAL.LOGIN_ID

Line 2435: fte_trips_pvt.validate_trip

2431: THEN
2432: --{
2433: --
2434: --
2435: fte_trips_pvt.validate_trip
2436: (
2437: p_trip_id => get_segment_trips_rec.fte_trip_id,
2438: x_return_status => l_return_status,
2439: x_msg_count => l_msg_count,

Line 2446: p_api_name => 'FTE_TRIPS_PVT.VALIDATE_TRIP',

2442: --
2443: --
2444: FTE_MLS_UTIL.api_post_call
2445: (
2446: p_api_name => 'FTE_TRIPS_PVT.VALIDATE_TRIP',
2447: p_api_return_status => l_return_status,
2448: p_message_name => 'FTE_TRIP_SEGMENT_UNEXP_ERROR',
2449: p_trip_segment_id => p_new_trip_segment_rec.trip_id,
2450: p_trip_segment_name => p_new_trip_segment_rec.name,

Line 2481: UPDATE fte_trips

2477: )
2478: )
2479: THEN
2480: --{
2481: UPDATE fte_trips
2482: SET status_code = 'CL',
2483: last_update_date = sysdate,
2484: last_updated_by = FND_GLOBAL.USER_ID,
2485: last_update_login = FND_GLOBAL.LOGIN_ID

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 2619: UPDATE fte_trips

2615: )
2616: )
2617: THEN
2618: --{
2619: UPDATE fte_trips
2620: SET status_code = 'CL',
2621: last_update_date = sysdate,
2622: last_updated_by = FND_GLOBAL.USER_ID,
2623: last_update_login = FND_GLOBAL.LOGIN_ID