APPS.WSH_DELIVERY_LEGS_GRP dependencies on WSH_NEW_DELIVERIES_PVT

Line 45: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12, glog proj

41: status_code,
42: planned_flag,
43: NVL(shipment_direction, 'O'), -- J IB jckwok
44: NVL(ignore_for_planning, 'N'), -- OTM R12, glog proj
45: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12, glog proj
46: FROM wsh_new_deliveries
47: WHERE delivery_id = p_delivery_id;
48:
49: CURSOR get_parent_leg(p_delivery_leg_id in number) is

Line 861: wsh_new_deliveries_pvt.lock_dlvy_no_compare(

857: IF l_delivery_id IS NOT NULL THEN
858:
859: -- Lock the delivery before update
860:
861: wsh_new_deliveries_pvt.lock_dlvy_no_compare(
862: p_delivery_id => l_delivery_id);
863:
864:
865: UPDATE wsh_new_deliveries