eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_WSH_INTERFACE_PKG dependencies on WSH_TRIPS

Line 67: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

63: --
64: --
65: PROCEDURE get_segment_stops
66: (
67: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
68: p_current_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
69: p_action_type IN VARCHAR2,
70: x_trip_stop_tab OUT NOCOPY trip_stop_tab_type,
71: x_current_stop_index OUT NOCOPY NUMBER,

Line 206: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

202: --
203: --
204: PROCEDURE validate_first_stop
205: (
206: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
207: P_current_stop_rec IN trip_stop_rec_type,
208: p_stop_validation_ctrl_rec IN stop_validation_ctrl_rec_type,
209: p_schedule_start_datetime IN DATE,
210: p_schedule_end_datetime IN DATE,

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 481: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

477: --
478: --
479: PROCEDURE validate_last_stop
480: (
481: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
482: P_current_stop_rec IN trip_stop_rec_type,
483: p_stop_validation_ctrl_rec IN stop_validation_ctrl_rec_type,
484: p_schedule_start_datetime IN DATE,
485: p_schedule_end_datetime IN DATE,

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 756: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

752: --
753: --
754: PROCEDURE validate_intermediate_stop
755: (
756: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
757: P_current_stop_rec IN Trip_Stop_Rec_Type,
758: p_stop_validation_ctrl_rec IN stop_validation_ctrl_rec_type,
759: p_schedule_start_datetime IN DATE,
760: p_schedule_end_datetime IN DATE,

Line 947: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

943: --
944: --
945: PROCEDURE validate_stop_add
946: (
947: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
948: P_trip_stop_tab IN Trip_Stop_Tab_type,
949: p_current_stop_index IN NUMBER,
950: p_stop_validation_ctrl_rec IN stop_validation_ctrl_rec_type,
951: p_schedule_start_datetime IN DATE,

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 1144: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

1140: --
1141: --
1142: PROCEDURE validate_stop_update
1143: (
1144: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
1145: P_trip_stop_tab IN Trip_Stop_Tab_type,
1146: p_current_stop_index IN NUMBER,
1147: p_curr_stop_old_position IN VARCHAR2,
1148: p_old_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

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 1503: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

1499: --
1500: --
1501: PROCEDURE validate_stop_delete
1502: (
1503: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
1504: P_trip_stop_tab IN Trip_Stop_Tab_type,
1505: p_current_stop_index IN NUMBER,
1506: p_schedule_start_datetime IN DATE,
1507: p_schedule_end_datetime IN DATE,

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 1851: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

1847: P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1848: X_return_status OUT NOCOPY VARCHAR2,
1849: X_msg_count OUT NOCOPY NUMBER,
1850: X_msg_data OUT NOCOPY VARCHAR2,
1851: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
1852: P_old_segment_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
1853: P_new_segment_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
1854: p_segmentStopChangeInRec IN segmentStopChangeInRecType,
1855: p_segmentStopChangeOutRec OUT NOCOPY segmentStopChangeOutRecType

Line 2281: P_new_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

2277: --
2278: --
2279: PROCEDURE validate_segment_update
2280: (
2281: P_new_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
2282: P_old_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
2283: x_return_status OUT NOCOPY VARCHAR2
2284: )
2285: IS

Line 2282: P_old_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

2278: --
2279: PROCEDURE validate_segment_update
2280: (
2281: P_new_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
2282: P_old_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
2283: x_return_status OUT NOCOPY VARCHAR2
2284: )
2285: IS
2286: --{

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 2334: FROM wsh_trips

2330: p_segment_id IN NUMBER
2331: )
2332: IS
2333: SELECT status_code, name
2334: FROM wsh_trips
2335: WHERE trip_id = p_segment_id;
2336: --
2337: --}
2338: BEGIN

Line 2518: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

2514: --
2515: --
2516: PROCEDURE validate_segment_delete
2517: (
2518: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
2519: x_return_status OUT NOCOPY VARCHAR2
2520: )
2521: IS
2522: --{

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 2556: FROM wsh_trips

2552: p_segment_id IN NUMBER
2553: )
2554: IS
2555: SELECT status_code, name
2556: FROM wsh_trips
2557: WHERE trip_id = p_segment_id;
2558: --
2559: --}
2560: BEGIN

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,

Line 2659: P_old_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

2655: P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2656: X_return_status OUT NOCOPY VARCHAR2,
2657: X_msg_count OUT NOCOPY NUMBER,
2658: X_msg_data OUT NOCOPY VARCHAR2,
2659: P_old_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
2660: P_new_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
2661: p_tripSegmentChangeInRec IN tripSegmentChangeInRecType,
2662: p_tripSegmentChangeOutRec OUT NOCOPY tripSegmentChangeOutRecType
2663: )

Line 2660: P_new_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

2656: X_return_status OUT NOCOPY VARCHAR2,
2657: X_msg_count OUT NOCOPY NUMBER,
2658: X_msg_data OUT NOCOPY VARCHAR2,
2659: P_old_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
2660: P_new_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
2661: p_tripSegmentChangeInRec IN tripSegmentChangeInRecType,
2662: p_tripSegmentChangeOutRec OUT NOCOPY tripSegmentChangeOutRecType
2663: )
2664: IS