[Home] [Help]
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
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 (+)
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;
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
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