DBA Data[Home] [Help]

APPS.WSH_USA_ACTIONS_PVT dependencies on WSH_DELIVERY_DETAILS

Line 17: source_code wsh_delivery_details.source_code%type,

13:
14: --bugfix 8915868 added record structure
15:
16: TYPE Cancel_Reservation_Table_Type is RECORD (
17: source_code wsh_delivery_details.source_code%type,
18: source_header_id NUMBER,
19: source_line_id NUMBER,
20: delivery_detail_id NUMBER,
21: organization_id NUMBER,

Line 36: wsh_delivery_details wdd where

32:
33: CURSOR c_check_ship_sets (c_p_set_id NUMBER,
34: c_p_source_header_id NUMBER) IS -- 2373131
35: select wdd.ship_set_id from
36: wsh_delivery_details wdd where
37: wdd.ship_set_id = c_p_set_id and
38: wdd.source_code = 'OE' and
39: wdd.source_header_id = c_p_source_header_id and
40: ((wdd.released_status = 'C') or exists (select wda.delivery_detail_id

Line 116: -- and updates WSH_DELIVERY_DETAILS

112: -- p_changed_detail Detail record of attributes to change
113: -- x_return_status return status
114: -- Description:
115: -- Maps the attributes to shipping values as needed
116: -- and updates WSH_DELIVERY_DETAILS
117: --
118: PROCEDURE Update_Attributes(
119: p_source_code IN VARCHAR2,
120: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,