DBA Data[Home] [Help]

APPS.WSH_USA_ACTIONS_PVT dependencies on WSH_DELIVERY_DETAILS

Line 21: wsh_delivery_details wdd where

17:
18: CURSOR c_check_ship_sets (c_p_set_id NUMBER,
19: c_p_source_header_id NUMBER) IS -- 2373131
20: select wdd.ship_set_id from
21: wsh_delivery_details wdd where
22: wdd.ship_set_id = c_p_set_id and
23: wdd.source_code = 'OE' and
24: wdd.source_header_id = c_p_source_header_id and
25: ((wdd.released_status = 'C') or exists (select wda.delivery_detail_id

Line 101: -- and updates WSH_DELIVERY_DETAILS

97: -- p_changed_detail Detail record of attributes to change
98: -- x_return_status return status
99: -- Description:
100: -- Maps the attributes to shipping values as needed
101: -- and updates WSH_DELIVERY_DETAILS
102: --
103: PROCEDURE Update_Attributes(
104: p_source_code IN VARCHAR2,
105: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,