APPS.WSH_EXCEPTIONS_GRP dependencies on WSH_DELIVERY_DETAILS

Line 567: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

563:
564: -- cursor to validate delivery_detail_id
565: CURSOR C2(c_delivery_id NUMBER) IS
566: SELECT wdd.delivery_detail_id, wda.delivery_id, wda.delivery_assignment_id
567: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
568: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
569: AND ((c_delivery_id is null) or (wda.delivery_id =c_delivery_id))
570: AND wdd.delivery_detail_id = p_exception_rec.delivery_detail_id
571: AND wdd.container_flag IN ('N', 'Y'); -- R12 MDC

Line 576: FROM wsh_delivery_details

572:
573: -- cursor to get the delivery_detail_id for container_name
574: CURSOR C_del_detail (c_container_name VARCHAR2) IS
575: SELECT delivery_detail_id
576: FROM wsh_delivery_details
577: WHERE container_flag = 'Y'
578: AND container_name = c_container_name
579: AND delivery_detail_id =
580: nvl(p_exception_rec.delivery_detail_id, delivery_detail_id);

Line 858: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);

854: --
855: -- Debug Statements
856: --
857: IF l_debug_on THEN
858: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
859: END IF;
860: --
861: WSH_DELIVERY_DETAILS_INV.Validate_Serial(
862: p_serial_number => p_exception_rec.serial_number,

Line 861: WSH_DELIVERY_DETAILS_INV.Validate_Serial(

857: IF l_debug_on THEN
858: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
859: END IF;
860: --
861: WSH_DELIVERY_DETAILS_INV.Validate_Serial(
862: p_serial_number => p_exception_rec.serial_number,
863: p_lot_number => p_exception_rec.lot_number,
864: p_organization_id => p_exception_rec.org_id,
865: p_inventory_item_id => p_exception_rec.inventory_item_id,