DBA Data[Home] [Help]

APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_PICKING_RULES

Line 3164: l_token := 'WSH_PICKING_RULES';

3160: END ;
3161:
3162:
3163: BEGIN
3164: l_token := 'WSH_PICKING_RULES';
3165: IF l_debug_on THEN
3166: wsh_debug_sv.LOG(l_module_name, 'Validating records in table', l_token);
3167: END IF;
3168: v_delete_permitted := NULL;

Line 3171: FROM WSH_PICKING_RULES

3167: END IF;
3168: v_delete_permitted := NULL;
3169: SELECT 'N'
3170: INTO v_delete_permitted
3171: FROM WSH_PICKING_RULES
3172: WHERE SHIP_FROM_LOCATION_ID = P_LOCATION_ID
3173: AND ROWNUM = 1;
3174:
3175: IF v_delete_permitted IS NOT NULL THEN