1224: INTO v_delete_allowed
1225: FROM sys.dual
1226: WHERE NOT EXISTS (
1227: SELECT null
1228: FROM RCV_TRANSACTIONS
1229: WHERE deliver_to_location_id = p_location_id
1230: OR location_id = p_location_id
1231: );
1232:
1235: INTO v_delete_allowed
1236: FROM sys.dual
1237: WHERE NOT EXISTS (
1238: SELECT null
1239: FROM RCV_TRANSACTIONS_INTERFACE
1240: WHERE ship_to_location_id = p_location_id
1241: OR deliver_to_location_id = p_location_id
1242: OR location_id = p_location_id
1243: );