APPS.FTE_TENDER_PVT dependencies on WSH_TRIPS

Line 1102: from wsh_trips

1098: x_value VARCHAR2(200);
1099:
1100: cursor get_trip_cur(c_trip_id NUMBER) is
1101: select trip_id, name,load_tender_status
1102: from wsh_trips
1103: where trip_id = c_trip_id;
1104:
1105: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1106:

Line 1780: -- P_trip_segment_rec IN WSH_TRIPS_GRP.Trip_Pub_Rec_Type,

1776: -- NAME: CHECK_THRESHOLD_FOR_STOP --
1777: -- TYPE: PROCEDURE --
1778: -- PARAMETERS (IN): P_api_version IN NUMBER,
1779: -- P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1780: -- P_trip_segment_rec IN WSH_TRIPS_GRP.Trip_Pub_Rec_Type,
1781: -- P_old_segment_stop_rec IN WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
1782: -- P_new_segment_stop_rec IN WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type
1783: --
1784: -- PARAMETERS (OUT): X_return_status VARCHAR2 --

Line 1815: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

1811: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1812: X_return_status OUT NOCOPY VARCHAR2,
1813: X_msg_count OUT NOCOPY NUMBER,
1814: X_msg_data OUT NOCOPY VARCHAR2,
1815: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
1816: P_new_segment_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type)
1817: IS
1818:
1819: --{

Line 1862: from wsh_trips

1858: and stop_id = c_stop_id;
1859: ---
1860: cursor get_tender_number_cur(c_trip_id NUMBER) is
1861: select load_tender_number, wf_item_key,carrier_contact_id
1862: from wsh_trips
1863: where trip_id = c_trip_id;
1864: ---
1865: --
1866: cursor get_snapshot_session_cur(c_trip_id NUMBER, c_tender_number NUMBER,

Line 3546: wsh_exceptions we, wsh_trips wt where we.trip_id = wt.trip_id and

3542: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT'|| '.' || 'COMPLETE_CANCEL_TENDER';
3543:
3544: cursor check_exception_on_trip(p_tender_id Number) is
3545: select exception_id, status from
3546: wsh_exceptions we, wsh_trips wt where we.trip_id = wt.trip_id and
3547: (we.exception_name = 'FTE_CARRIER_PTIME' OR
3548: we.exception_name = 'FTE_CARRIER_DTIME') AND
3549: we.status <> 'CLOSED' AND
3550: wt.trip_id = p_tender_id;

Line 3971: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

3967: l_number_of_warnings NUMBER;
3968: l_number_of_errors NUMBER;
3969:
3970: --{Trip update parameters
3971: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3972: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
3973: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
3974: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
3975: --}

Line 3972: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

3968: l_number_of_errors NUMBER;
3969:
3970: --{Trip update parameters
3971: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3972: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
3973: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
3974: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
3975: --}
3976:

Line 3973: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

3969:
3970: --{Trip update parameters
3971: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3972: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
3973: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
3974: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
3975: --}
3976:
3977:

Line 3974: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

3970: --{Trip update parameters
3971: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3972: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
3973: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
3974: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
3975: --}
3976:
3977:
3978: BEGIN

Line 4715: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

4711:
4712: l_role_name VARCHAR2(32767);
4713:
4714: --{Trip update parameters
4715: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4716: p_wsh_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
4717: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
4718: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
4719: --}

Line 4716: p_wsh_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

4712: l_role_name VARCHAR2(32767);
4713:
4714: --{Trip update parameters
4715: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4716: p_wsh_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
4717: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
4718: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
4719: --}
4720:

Line 4717: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

4713:
4714: --{Trip update parameters
4715: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4716: p_wsh_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
4717: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
4718: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
4719: --}
4720:
4721:

Line 4718: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

4714: --{Trip update parameters
4715: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4716: p_wsh_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
4717: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
4718: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
4719: --}
4720:
4721:
4722: BEGIN