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 980: FROM wsh_freight_costs_interface

976: uom,
977: total_amount,
978: currency_code,
979: delivery_id
980: FROM wsh_freight_costs_interface
981: WHERE delivery_id = p_delivery_id
982: AND interface_action_code = G_TMS_RELEASE_CODE;
983:
984: CURSOR c_get_currency_code(p_trip_interface_id IN NUMBER) IS

Line 1012: wsh_freight_costs_interface wfci,

1008: wfci.freight_cost_interface_id
1009: from wsh_trips_interface wti ,
1010: wsh_trip_stops_interface wtsi ,
1011: wsh_del_legs_interface wdli ,
1012: wsh_freight_costs_interface wfci,
1013: wsh_new_del_interface wndi
1014: where wti.trip_interface_id = c_trip_interface_id --Bug7717569
1015: and wdli.delivery_interface_id = wndi.delivery_interface_id
1016: and wndi.delivery_interface_id = wfci.delivery_interface_id (+)

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

3137: WSH_DEBUG_SV.logmsg(l_module_name,'===============================');
3138: END IF;
3139:
3140: DECLARE
3141: -- Delivery id in wsh_freight_costs_interface would be populated
3142: -- while importing information from Glog
3143:
3144: -- variables
3145: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;

Line 3145: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;

3141: -- Delivery id in wsh_freight_costs_interface would be populated
3142: -- while importing information from Glog
3143:
3144: -- variables
3145: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
3146: l_in_rec WSH_FREIGHT_COSTS_GRP.freightInRecType;
3147: l_out_tab WSH_FREIGHT_COSTS_GRP.freight_out_tab_type;
3148: l_rs VARCHAR2(1);
3149: l_msg_count NUMBER;

Line 3146: l_in_rec WSH_FREIGHT_COSTS_GRP.freightInRecType;

3142: -- while importing information from Glog
3143:
3144: -- variables
3145: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
3146: l_in_rec WSH_FREIGHT_COSTS_GRP.freightInRecType;
3147: l_out_tab WSH_FREIGHT_COSTS_GRP.freight_out_tab_type;
3148: l_rs VARCHAR2(1);
3149: l_msg_count NUMBER;
3150: l_msg_data VARCHAR2(32767);

Line 3147: l_out_tab WSH_FREIGHT_COSTS_GRP.freight_out_tab_type;

3143:
3144: -- variables
3145: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
3146: l_in_rec WSH_FREIGHT_COSTS_GRP.freightInRecType;
3147: l_out_tab WSH_FREIGHT_COSTS_GRP.freight_out_tab_type;
3148: l_rs VARCHAR2(1);
3149: l_msg_count NUMBER;
3150: l_msg_data VARCHAR2(32767);
3151:

Line 3194: DELETE FROM wsh_freight_costs

3190: END LOOP;--}
3191:
3192: -- Records for Delivery Legs
3193: FORALL k in l_dleg_id_tab.FIRST..l_dleg_id_tab.LAST
3194: DELETE FROM wsh_freight_costs
3195: WHERE delivery_id = l_dleg_id_tab(k)
3196: AND freight_cost_type_id = l_frcost_type_id;
3197:
3198: -- Records for Delivery

Line 3200: DELETE FROM wsh_freight_costs

3196: AND freight_cost_type_id = l_frcost_type_id;
3197:
3198: -- Records for Delivery
3199: FORALL j in l_dlvy_id_tab.FIRST..l_dlvy_id_tab.LAST
3200: DELETE FROM wsh_freight_costs
3201: WHERE delivery_id = l_dlvy_id_tab(j)
3202: AND freight_cost_type_id = l_frcost_type_id;
3203:
3204: IF l_debug_on THEN

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

3516: l_in_rec.action_code := 'CREATE';
3517: l_in_rec.caller := 'FTE_TMS_INTEGRATION'; --'FTE_TMS_RELEASE';
3518:
3519: IF l_debug_on THEN
3520: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs');
3521: END IF;
3522:
3523: WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs
3524: (p_api_version_number => 1.0,

Line 3523: WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs

3519: IF l_debug_on THEN
3520: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs');
3521: END IF;
3522:
3523: WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs
3524: (p_api_version_number => 1.0,
3525: p_init_msg_list => FND_API.G_TRUE,
3526: p_commit => FND_API.G_FALSE,
3527: p_freight_info_tab => l_freight_info_tab,

Line 4179: -- Purge records in wsh_freight_costs_interface

4175: --=========================================================================
4176: -- Procedure: PURGE_INTERFACE_DATA
4177: -- Description:
4178: -- wsh_del_details_interface and wsh_del_assgn_interface will not be populated
4179: -- Purge records in wsh_freight_costs_interface
4180: -- If p_exception_action =PURGE, then purge the exceptions
4181: -- for WSH_OTM_SHIPMENT_ERROR
4182: -- elsif p_exception_action = CLOSE, then close the exception
4183: -- for WSH_OTM_SHIPMENT_ERROR(used for reprocessing from Interface Mesg

Line 4267: Delete from wsh_freight_costs_interface wfci

4263: END IF;
4264:
4265: -- Purge wsh_freight_cost_interface
4266: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4267: Delete from wsh_freight_costs_interface wfci
4268: where wfci.delivery_interface_id in (
4269: select wdli.delivery_interface_id
4270: from wsh_trip_stops_interface wtsi,
4271: wsh_del_legs_interface wdli