APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_FREIGHT_COSTS_INTERFACE

Line 1487: FROM wsh_freight_costs_interface

1483:
1484:
1485: -- Process Interface freight costs
1486: SELECT count(*) INTO l_det_freight_costs
1487: FROM wsh_freight_costs_interface
1488: WHERE delivery_detail_interface_id = del_det_int_rec.delivery_detail_interface_id
1489: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1490:
1491: IF l_debug_on THEN

Line 2421: FROM wsh_freight_costs_interface

2417: END IF;
2418: -- Process interface freight costs
2419: SELECT COUNT(*)
2420: INTO l_det_freight_costs
2421: FROM wsh_freight_costs_interface
2422: WHERE delivery_detail_interface_id = l_frt_detail_intf_tab(i)
2423: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2424:
2425: IF l_debug_on THEN

Line 3335: FROM wsh_freight_costs_interface

3331: END IF;
3332:
3333: -- TPW - Distributed changes
3334: SELECT count(*) INTO l_del_freight_costs
3335: FROM wsh_freight_costs_interface
3336: WHERE delivery_interface_id = p_delivery_interface_id
3337: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
3338:
3339: IF l_debug_on THEN

Line 3878: FROM wsh_freight_costs_interface

3874: PROGRAM_UPDATE_DATE,
3875: REQUEST_ID,
3876: FREIGHT_CODE,
3877: INTERFACE_ACTION_CODE
3878: FROM wsh_freight_costs_interface
3879: WHERE (delivery_detail_interface_id = NVL(p_del_detail_interface_id, -99999))
3880: OR (delivery_interface_id = NVL(p_delivery_interface_id, -99999))
3881: OR (stop_interface_id = NVL(p_stop_interface_id, -99999))
3882: OR (trip_interface_id = NVL(p_trip_interface_id, -99999))

Line 3978: l_loc_interface_error_rec.p_interface_table_name := 'WSH_FREIGHT_COSTS_INTERFACE';

3974: IF l_debug_on THEN
3975: wsh_debug_sv.logmsg(l_module_name, 'Invalid Freight Cost Type');
3976: END IF;
3977:
3978: l_loc_interface_error_rec.p_interface_table_name := 'WSH_FREIGHT_COSTS_INTERFACE';
3979: l_loc_interface_error_rec.p_interface_id := l_entity_interface_id;
3980:
3981: Log_Errors(
3982: p_loc_interface_errors_rec => l_loc_interface_error_rec,

Line 4055: l_loc_interface_error_rec.p_interface_table_name := 'WSH_FREIGHT_COSTS_INTERFACE';

4051: wsh_debug_sv.log (l_module_name, 'freight_cost id created', l_freight_cost_id);
4052: END IF;
4053:
4054: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4055: l_loc_interface_error_rec.p_interface_table_name := 'WSH_FREIGHT_COSTS_INTERFACE';
4056: l_loc_interface_error_rec.p_interface_id := l_entity_interface_id;
4057:
4058: Log_Errors(
4059: p_loc_interface_errors_rec => l_loc_interface_error_rec,