62: )
63: IS
64: x_rowid varchar2(30);
65: l_trip_info wsh_trips_pvt.trip_rec_type;
66: l_leg_info_new wsh_delivery_legs_pvt.delivery_leg_rec_type;
67: l_leg_info_old wsh_delivery_legs_pvt.delivery_leg_rec_type;
68: l_old_leg_id NUMBER;
69: l_new_leg_id NUMBER;
70: l_ledger_id NUMBER; -- LE Uptake
63: IS
64: x_rowid varchar2(30);
65: l_trip_info wsh_trips_pvt.trip_rec_type;
66: l_leg_info_new wsh_delivery_legs_pvt.delivery_leg_rec_type;
67: l_leg_info_old wsh_delivery_legs_pvt.delivery_leg_rec_type;
68: l_old_leg_id NUMBER;
69: l_new_leg_id NUMBER;
70: l_ledger_id NUMBER; -- LE Uptake
71: l_del_rows wsh_util_core.id_tab_type;
553: END IF;
554: END IF;
555:
556: IF l_debug_on THEN
557: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.DELETE_DELIVERY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
558: END IF;
559: --
560: wsh_delivery_legs_pvt.delete_delivery_leg
561: (l_rowid,
556: IF l_debug_on THEN
557: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.DELETE_DELIVERY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
558: END IF;
559: --
560: wsh_delivery_legs_pvt.delete_delivery_leg
561: (l_rowid,
562: p_entity_id,
563: x_return_status
564: );