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.WSH_TMS_RELEASE dependencies on WSH_FREIGHT_COSTS

Line 973: FROM wsh_freight_costs_interface

969: uom,
970: total_amount,
971: currency_code,
972: delivery_id
973: FROM wsh_freight_costs_interface
974: WHERE delivery_id = p_delivery_id
975: AND interface_action_code = G_TMS_RELEASE_CODE;
976:
977: CURSOR c_get_currency_code(p_trip_interface_id IN NUMBER) IS

Line 1005: wsh_freight_costs_interface wfci,

1001: wfci.freight_cost_interface_id
1002: from wsh_trips_interface wti ,
1003: wsh_trip_stops_interface wtsi ,
1004: wsh_del_legs_interface wdli ,
1005: wsh_freight_costs_interface wfci,
1006: wsh_new_del_interface wndi
1007: where wti.trip_interface_id = c_trip_interface_id --Bug7717569
1008: and wdli.delivery_interface_id = wndi.delivery_interface_id
1009: and wndi.delivery_interface_id = wfci.delivery_interface_id (+)

Line 3133: -- Delivery id in wsh_freight_costs_interface would be populated

3129: WSH_DEBUG_SV.logmsg(l_module_name,'===============================');
3130: END IF;
3131:
3132: DECLARE
3133: -- Delivery id in wsh_freight_costs_interface would be populated
3134: -- while importing information from Glog
3135:
3136: -- variables
3137: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;

Line 3137: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;

3133: -- Delivery id in wsh_freight_costs_interface would be populated
3134: -- while importing information from Glog
3135:
3136: -- variables
3137: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
3138: l_in_rec WSH_FREIGHT_COSTS_GRP.freightInRecType;
3139: l_out_tab WSH_FREIGHT_COSTS_GRP.freight_out_tab_type;
3140: l_rs VARCHAR2(1);
3141: l_msg_count NUMBER;

Line 3138: l_in_rec WSH_FREIGHT_COSTS_GRP.freightInRecType;

3134: -- while importing information from Glog
3135:
3136: -- variables
3137: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
3138: l_in_rec WSH_FREIGHT_COSTS_GRP.freightInRecType;
3139: l_out_tab WSH_FREIGHT_COSTS_GRP.freight_out_tab_type;
3140: l_rs VARCHAR2(1);
3141: l_msg_count NUMBER;
3142: l_msg_data VARCHAR2(32767);

Line 3139: l_out_tab WSH_FREIGHT_COSTS_GRP.freight_out_tab_type;

3135:
3136: -- variables
3137: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
3138: l_in_rec WSH_FREIGHT_COSTS_GRP.freightInRecType;
3139: l_out_tab WSH_FREIGHT_COSTS_GRP.freight_out_tab_type;
3140: l_rs VARCHAR2(1);
3141: l_msg_count NUMBER;
3142: l_msg_data VARCHAR2(32767);
3143:

Line 3186: DELETE FROM wsh_freight_costs

3182: END LOOP;--}
3183:
3184: -- Records for Delivery Legs
3185: FORALL k in l_dleg_id_tab.FIRST..l_dleg_id_tab.LAST
3186: DELETE FROM wsh_freight_costs
3187: WHERE delivery_id = l_dleg_id_tab(k)
3188: AND freight_cost_type_id = l_frcost_type_id;
3189:
3190: -- Records for Delivery

Line 3192: DELETE FROM wsh_freight_costs

3188: AND freight_cost_type_id = l_frcost_type_id;
3189:
3190: -- Records for Delivery
3191: FORALL j in l_dlvy_id_tab.FIRST..l_dlvy_id_tab.LAST
3192: DELETE FROM wsh_freight_costs
3193: WHERE delivery_id = l_dlvy_id_tab(j)
3194: AND freight_cost_type_id = l_frcost_type_id;
3195:
3196: IF l_debug_on THEN

Line 3512: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs');

3508: l_in_rec.action_code := 'CREATE';
3509: l_in_rec.caller := 'FTE_TMS_INTEGRATION'; --'FTE_TMS_RELEASE';
3510:
3511: IF l_debug_on THEN
3512: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs');
3513: END IF;
3514:
3515: WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs
3516: (p_api_version_number => 1.0,

Line 3515: WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs

3511: IF l_debug_on THEN
3512: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs');
3513: END IF;
3514:
3515: WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs
3516: (p_api_version_number => 1.0,
3517: p_init_msg_list => FND_API.G_TRUE,
3518: p_commit => FND_API.G_FALSE,
3519: p_freight_info_tab => l_freight_info_tab,

Line 4171: -- Purge records in wsh_freight_costs_interface

4167: --=========================================================================
4168: -- Procedure: PURGE_INTERFACE_DATA
4169: -- Description:
4170: -- wsh_del_details_interface and wsh_del_assgn_interface will not be populated
4171: -- Purge records in wsh_freight_costs_interface
4172: -- If p_exception_action =PURGE, then purge the exceptions
4173: -- for WSH_OTM_SHIPMENT_ERROR
4174: -- elsif p_exception_action = CLOSE, then close the exception
4175: -- for WSH_OTM_SHIPMENT_ERROR(used for reprocessing from Interface Mesg

Line 4259: Delete from wsh_freight_costs_interface wfci

4255: END IF;
4256:
4257: -- Purge wsh_freight_cost_interface
4258: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4259: Delete from wsh_freight_costs_interface wfci
4260: where wfci.delivery_interface_id in (
4261: select wdli.delivery_interface_id
4262: from wsh_trip_stops_interface wtsi,
4263: wsh_del_legs_interface wdli