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_MLS_WRAPPER dependencies on WSH_TRIPS

Line 1054: -- COMMENT : Wrapper around WSH_TRIPS_PUB.Create_Update_Trip

1050:
1051: --========================================================================
1052: -- PROCEDURE : Create_Update_Trip FTE wrapper
1053: --
1054: -- COMMENT : Wrapper around WSH_TRIPS_PUB.Create_Update_Trip
1055: -- Passes in all the parameters reqd (record type input changed to
1056: -- number of parameters which are collected, assigned to a record
1057: -- and call WSH_TRIPS_PUB.Create_Update_Trip
1058: -- MODIFIED 09/04/2002 HBHAGAVA

Line 1057: -- and call WSH_TRIPS_PUB.Create_Update_Trip

1053: --
1054: -- COMMENT : Wrapper around WSH_TRIPS_PUB.Create_Update_Trip
1055: -- Passes in all the parameters reqd (record type input changed to
1056: -- number of parameters which are collected, assigned to a record
1057: -- and call WSH_TRIPS_PUB.Create_Update_Trip
1058: -- MODIFIED 09/04/2002 HBHAGAVA
1059: -- Added new paramters for Load Tender
1060: -- p_rec_tender_id
1061: -- p_delivery_leg_ids

Line 1144: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

1140: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
1141: ) IS
1142:
1143: --
1144: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1145: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1146: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1147: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1148: p_commit VARCHAR2(1);

Line 1145: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

1141: ) IS
1142:
1143: --
1144: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1145: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1146: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1147: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1148: p_commit VARCHAR2(1);
1149:

Line 1146: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

1142:
1143: --
1144: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1145: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1146: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1147: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1148: p_commit VARCHAR2(1);
1149:
1150: l_shipper_wait_time NUMBER;

Line 1147: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

1143: --
1144: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1145: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1146: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1147: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1148: p_commit VARCHAR2(1);
1149:
1150: l_shipper_wait_time NUMBER;
1151: l_carrier_name VARCHAR2(1000);

Line 1292: FROM WSH_TRIPS

1288:
1289: -- Get Current load tender status of trip
1290: -- Modified for REL12 HBHAGAVA
1291: SELECT LOAD_TENDER_STATUS, LANE_ID INTO l_db_tender_status, l_db_lane_id
1292: FROM WSH_TRIPS
1293: WHERE TRIP_ID = p_rec_TRIP_ID;
1294:
1295:
1296: IF l_debug_on THEN

Line 1482: FROM WSH_TRIPS

1478: SELECT CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
1479: LAST_UPDATED_BY,LAST_UPDATE_LOGIN
1480: INTO x_CREATION_DATE,x_CREATED_BY,x_LAST_UPDATE_DATE,
1481: x_LAST_UPDATED_BY, x_LAST_UPDATE_LOGIN
1482: FROM WSH_TRIPS
1483: WHERE TRIP_ID = p_rec_TRIP_ID;
1484: END IF;
1485:
1486: IF l_number_of_errors > 0

Line 1585: p_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

1581:
1582:
1583:
1584: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
1585: p_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
1586: x_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
1587: p_commit VARCHAR2(1);
1588:
1589: --

Line 1586: x_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

1582:
1583:
1584: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
1585: p_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
1586: x_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
1587: p_commit VARCHAR2(1);
1588:
1589: --
1590: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 1800: FROM WSH_TRIPS

1796:
1797: CURSOR c_tripDetails(p_tripID NUMBER) IS
1798: SELECT CARRIER_ID, NAME, LANE_ID, MODE_OF_TRANSPORT, SERVICE_LEVEL, SHIPMENTS_TYPE_FLAG,
1799: LOAD_TENDER_STATUS
1800: FROM WSH_TRIPS
1801: WHERE TRIP_ID = p_tripID;
1802:
1803: CURSOR c_isCarrierTenderEnabled (p_CarrierID NUMBER) IS
1804: SELECT 'Y', decode(ENABLE_AUTO_TENDER,null,'N','N','N','Y') AUTO_TENDER,

Line 2461: FROM WSH_TRIPS

2457:
2458: CURSOR c_tripDetails (p_tripID NUMBER) IS
2459: SELECT NAME, PLANNED_FLAG, LOAD_TENDER_STATUS,
2460: CARRIER_ID, CARRIER_CONTACT_ID, WF_ITEM_KEY, LANE_ID
2461: FROM WSH_TRIPS
2462: WHERE TRIP_ID = p_tripID;
2463:
2464: l_tripName VARCHAR2(30);
2465: l_laneID NUMBER;

Line 2883: l_wsh_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

2879:
2880: l_trip_id NUMBER;
2881:
2882: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;
2883: l_wsh_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2884: l_wsh_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
2885:
2886: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2887: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME ||

Line 2884: l_wsh_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

2880: l_trip_id NUMBER;
2881:
2882: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;
2883: l_wsh_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2884: l_wsh_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
2885:
2886: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2887: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME ||
2888: '.' || 'TRIP_ACTION';

Line 5882: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

5878:
5879: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'TRIP_ACTION';
5880:
5881: --{Trip update parameters
5882: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
5883: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
5884: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
5885: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
5886: --}

Line 5883: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

5879: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'TRIP_ACTION';
5880:
5881: --{Trip update parameters
5882: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
5883: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
5884: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
5885: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
5886: --}
5887: l_tmp VARCHAR2(100);

Line 5884: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

5880:
5881: --{Trip update parameters
5882: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
5883: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
5884: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
5885: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
5886: --}
5887: l_tmp VARCHAR2(100);
5888: l_db_sm_code VARCHAR2(30);

Line 5885: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

5881: --{Trip update parameters
5882: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
5883: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
5884: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
5885: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
5886: --}
5887: l_tmp VARCHAR2(100);
5888: l_db_sm_code VARCHAR2(30);
5889:

Line 5953: INTO l_db_sm_code,db_mode_of_transport FROM WSH_TRIPS

5949:
5950: l_item_key := FTE_TENDER_PVT.GET_ITEM_KEY(p_trip_info_rec.trip_id);
5951:
5952: SELECT SHIP_METHOD_CODE,MODE_OF_TRANSPORT
5953: INTO l_db_sm_code,db_mode_of_transport FROM WSH_TRIPS
5954: WHERE TRIP_ID = p_trip_info_rec.trip_id;
5955:
5956: l_trip_info_rec := FTE_TENDER_ATTR_REC(
5957: p_trip_info_rec.trip_id, -- TripId

Line 6010: UPDATE WSH_TRIPS

6006: );
6007:
6008:
6009: /**
6010: UPDATE WSH_TRIPS
6011: SET shipper_wait_time = l_trip_info_rec.SHIP_WAIT_TIME,
6012: wait_time_uom = l_trip_info_rec.SHIP_TIME_UOM,
6013: wf_name = l_trip_info_rec.wf_name,
6014: wf_process_name = l_trip_info_rec.wf_process_name,

Line 6121: select wf_item_key into l_item_key from wsh_trips

6117: WSH_DEBUG_SV.C_PROC_LEVEL);
6118: END IF;
6119:
6120:
6121: select wf_item_key into l_item_key from wsh_trips
6122: where trip_id = p_trip_info_rec.trip_id;
6123:
6124: IF (l_tender_action = FTE_TENDER_PVT.S_REJECTED) THEN
6125: l_trip_info_rec := FTE_TENDER_ATTR_REC(

Line 6306: select wf_item_key into l_item_key from wsh_trips

6302: WSH_DEBUG_SV.C_PROC_LEVEL);
6303: END IF;
6304:
6305:
6306: select wf_item_key into l_item_key from wsh_trips
6307: where trip_id = p_trip_info_rec.trip_id;
6308:
6309: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6310: p_trip_info_rec.trip_id, -- TripId

Line 6352: select wf_item_key into l_item_key from wsh_trips

6348: WSH_DEBUG_SV.C_PROC_LEVEL);
6349: END IF;
6350:
6351:
6352: select wf_item_key into l_item_key from wsh_trips
6353: where trip_id = p_trip_info_rec.trip_id;
6354:
6355: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6356: p_trip_info_rec.trip_id, -- TripId

Line 6845: PROCEDURE INITIALIZE_TRIP_REC(x_trip_info OUT NOCOPY WSH_TRIPS_PVT.Trip_Rec_Type)

6841: p_encoded => FND_API.G_FALSE
6842: );
6843: END UPDATE_SERVICE_ON_TRIP;
6844: --
6845: PROCEDURE INITIALIZE_TRIP_REC(x_trip_info OUT NOCOPY WSH_TRIPS_PVT.Trip_Rec_Type)
6846: IS
6847:
6848: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
6849:

Line 6848: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

6844: --
6845: PROCEDURE INITIALIZE_TRIP_REC(x_trip_info OUT NOCOPY WSH_TRIPS_PVT.Trip_Rec_Type)
6846: IS
6847:
6848: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
6849:
6850: BEGIN
6851:
6852: p_trip_info.TRIP_ID := FND_API.G_MISS_NUM;