APPS.WSH_DATA_PROTECTION dependencies on WSH_DELIVERY_LEGS

Line 72: FROM wsh_delivery_legs

68: AND rownum = 1;
69:
70: CURSOR has_legs(x_delivery_id NUMBER) IS
71: SELECT delivery_leg_id
72: FROM wsh_delivery_legs
73: WHERE delivery_id = x_delivery_id
74: AND rownum = 1;
75:
76: CURSOR get_trip_status(x_entity_id NUMBER) IS

Line 88: FROM wsh_delivery_legs

84: WHERE stop_id = x_stop_id;
85:
86: CURSOR get_leg_status(x_leg_id NUMBER) IS
87: SELECT delivery_id, pick_up_stop_id, drop_off_stop_id
88: FROM wsh_delivery_legs
89: WHERE delivery_leg_id = x_leg_id;
90:
91: CURSOR has_pick_up_deliveries(x_stop_id NUMBER) IS
92: SELECT delivery_id

Line 93: FROM wsh_delivery_legs

89: WHERE delivery_leg_id = x_leg_id;
90:
91: CURSOR has_pick_up_deliveries(x_stop_id NUMBER) IS
92: SELECT delivery_id
93: FROM wsh_delivery_legs
94: WHERE pick_up_stop_id = x_stop_id
95: AND rownum = 1;
96:
97: CURSOR has_drop_off_deliveries(x_stop_id NUMBER) IS

Line 99: FROM wsh_delivery_legs

95: AND rownum = 1;
96:
97: CURSOR has_drop_off_deliveries(x_stop_id NUMBER) IS
98: SELECT delivery_id
99: FROM wsh_delivery_legs
100: WHERE drop_off_stop_id = x_stop_id
101: AND rownum = 1;
102:
103: i NUMBER := 0;

Line 232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.GET_DISABLED_LIST',WSH_DEBUG_SV.C_PROC_LEVEL);

228: --
229: -- Debug Statements
230: --
231: IF l_debug_on THEN
232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.GET_DISABLED_LIST',WSH_DEBUG_SV.C_PROC_LEVEL);
233: END IF;
234: --
235: WSH_DELIVERY_LEGS_PVT.Get_Disabled_List(
236: p_delivery_leg_id => p_entity_id,

Line 235: WSH_DELIVERY_LEGS_PVT.Get_Disabled_List(

231: IF l_debug_on THEN
232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.GET_DISABLED_LIST',WSH_DEBUG_SV.C_PROC_LEVEL);
233: END IF;
234: --
235: WSH_DELIVERY_LEGS_PVT.Get_Disabled_List(
236: p_delivery_leg_id => p_entity_id,
237: p_parent_entity_id => p_parent_entity_id,
238: p_list_type => p_list_type,
239: x_return_status => x_return_status,