APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_NEW_DELIVERIES

Line 1732: l_dlvy_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

1728: x_return_status OUT NOCOPY VARCHAR2) IS
1729:
1730: -- Bug 2753330
1731: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
1732: l_dlvy_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1733: l_dlvy_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
1734: l_index NUMBER;
1735: l_number_of_errors NUMBER := 0;
1736: l_number_of_warnings NUMBER := 0;

Line 2107: FROM wsh_new_deliveries

2103: /*
2104: -- Commented this part of the code as we allow the
2105: -- manifesting system to change the carrier, srv lvl, and mot.
2106: SELECT ship_method_code INTO l_curr_ship_method
2107: FROM wsh_new_deliveries
2108: WHERE delivery_id = l_del_int_rec.delivery_id;
2109:
2110: IF l_debug_on THEN
2111: wsh_debug_sv.log (l_module_name,'Current ship method', l_curr_ship_method);

Line 2501: FROM wsh_new_deliveries

2497: cursor org_del_id(c_del_id IN NUMBER) IS
2498: SELECT NVL(gross_weight,0),
2499: NVL(net_weight,0),
2500: NVL(volume,0)
2501: FROM wsh_new_deliveries
2502: WHERE delivery_id = c_del_id;
2503:
2504:
2505: -- J: W/V changes

Line 2651: UPDATE wsh_new_deliveries

2647: l_org_net_weight,
2648: l_org_volume;
2649: CLOSE org_del_id;
2650:
2651: UPDATE wsh_new_deliveries
2652: SET gross_weight = l_gross_weight,
2653: net_weight = l_net_weight,
2654: volume = l_volume,
2655: wv_frozen_flag = l_wv_frozen_flag

Line 4128: FROM wsh_new_deliveries

4124: wsh_debug_sv.logmsg(l_module_name, 'Locking the Delivery');
4125: END IF;
4126: SELECT delivery_id
4127: INTO l_dummy_id
4128: FROM wsh_new_deliveries
4129: WHERE delivery_id = p_delivery_id
4130: FOR UPDATE NOWAIT;
4131:
4132: IF l_debug_on THEN